Skip to content

VendorPerformance

Source SQL File - Google Cloud Cortex Data Foundation

Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - VendorPerformance

Overview

This view provides a comprehensive analysis of purchase order data from SAP systems. It combines data from multiple tables to provide insights into vendor performance, spend analysis, and delivery metrics. The view is designed to support reporting and analysis for procurement and supply chain management.

Data Sources

Source Table/View Description
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.Languages_T002 Table containing language keys for text fields.
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.CurrencyConversion Table containing currency conversion rates.
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.PurchaseDocuments Table containing purchase order header data.
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.POSchedule Table containing purchase order schedule line data.
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.PurchaseDocumentsHistory Table containing purchase order history data, including goods receipt and invoice data.
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.PurchasingOrganizationsMD Table containing master data for purchasing organizations.
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.PurchasingGroupsMD Table containing master data for purchasing groups.
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.VendorsMD Table containing master data for vendors.
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.CompaniesMD Table containing master data for companies.
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.MaterialsMD Table containing master data for materials.
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.MaterialTypesMD Table containing master data for material types.

Key Use Cases

  • Analyze vendor performance metrics such as delivery time, quality, and invoice accuracy.
  • Conduct spend analysis by vendor, material group, and purchasing organization.
  • Identify opportunities for cost savings and process improvements in the procurement process.
  • Provide insights for strategic decision-making related to vendor selection and management.
  • Support compliance with internal and external regulations related to procurement and supply chain management.

Query Logic

The view combines data from multiple tables using joins and aggregations. It calculates various metrics and flags based on the underlying data. The query logic ensures that the data is accurate, consistent, and relevant for the intended use cases.

Possible relation with SAP Transactions

Transaction Code Transaction Description
ME21N Create Purchase Order
ME22N Change Purchase Order
ME23N Display Purchase Order
ME28 Change Purchase Order Schedule Lines
MIGO Goods Receipt for Purchase Order
MIRO Invoice Receipt for Purchase Order
XK01 Create Vendor Master Data
XK02 Change Vendor Master Data
XK03 Display Vendor Master Data
MM01 Create Material Master Data
MM02 Change Material Master Data
MM03 Display Material Master Data

Data Lineage

Under Development

Table/View Fields

Field Field Description Description in SAP Dictionary (Comming soon)
Client_MANDT Client ID
DocumentNumber_EBELN Purchase Order Number
Item_EBELP Purchase Order Item Number
PurchasingDocumentDate_BEDAT Purchase Order Date
NetOrderValueinPOCurrency_NETWR Net Order Value in Purchase Order Currency
CurrencyKey_WAERS Purchase Order Currency Key
ItemDeliveryDate_EINDT Item Delivery Date
OrderDateOfScheduleLine_BEDAT Order Date of Schedule Line
PostingDateInTheDocument_BUDAT Posting Date in the Document
AmountInLocalCurrency_DMBTR Amount in Local Currency
POOrderHistoryCurrencyKey_WAERS Purchase Order History Currency Key
POQuantity_MENGE Purchase Order Quantity
UoM_MEINS Unit of Measure
NetPrice_NETPR Net Price
CreatedOn_AEDAT Created On
Status_STATU Status
MaterialNumber_MATNR Material Number
MaterialType_MTART Material Type
MaterialGroup_MATKL Material Group
PurchasingOrganization_EKORG Purchasing Organization
PurchasingGroup_EKGRP Purchasing Group
VendorAccountNumber_LIFNR Vendor Account Number
Company_BUKRS Company
Plant_WERKS Plant
YearOfPurchasingDocumentDate_BEDAT Year of Purchasing Document Date
MonthOfPurchasingDocumentDate_BEDAT Month of Purchasing Document Date
WeekOfPurchasingDocumentDate_BEDAT Week of Purchasing Document Date
IsDelivered Delivery Status
VendorCycleTimeInDays Vendor Cycle Time in Days
IsRejected Vendor Quality (Rejection)
RejectedQuantity Rejected Quantity
IsDeliveredOnTime Vendor On Time Delivery
IsDeliveredInFull Vendor InFull Delivery
IsGoodsReceiptAccurate Vendor Invoice Accuracy
GoodsReceiptQuantity Goods Receipt Quantity
GoodsReceiptAmountInSourceCurrency Vendor Spend Analysis (Goods Receipt Amount in Source Currency)
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
InvoiceQuantity Invoice Quantity
InvoiceAmountInSourceCurrency Vendor Spend Analysis (Invoice Amount in Source Currency)
InvoiceDate Invoice Date
YearOfInvoiceDate Year of Invoice Date
MonthOfInvoiceDate Month of Invoice Date
WeekOfInvoiceDate Week of Invoice Date
InvoiceCount Invoice Count
PurchasingOrganizationText_EKOTX Purchasing Organization Text
PurchasingGroupText_EKNAM Purchasing Group Text
CountryKey_LAND1 Vendor Country Key
NAME1 Vendor Name
CompanyText_BUTXT Company Text
FiscalyearVariant_PERIV Fiscal Year Variant
LanguageKey_SPRAS Language Key
MaterialText_MAKTX Material Text
DescriptionOfMaterialType_MTBEZ Description of Material Type
ExchangeRate_UKURS Exchange Rate
TargetCurrency_TCURR Target Currency
AmountInTargetCurrency_DMBTR Amount in Target Currency
NetPriceInTargetCurrency_NETPR Net Price in Target Currency
NetOrderValueinTargetCurrency_NETWR Net Order Value in Target Currency
GoodsReceiptAmountInTargetCurrency Goods Receipt Amount in Target Currency
InvoiceAmountInTargetCurrency Invoice Amount in Target Currency
VendorOnTimeDelivery Vendor On Time Delivery
VendorInFullDelivery Vendor InFull Delivery
VendorOnTimeInFullDelivery Vendor On Time In Full Delivery
VendorInvoiceAccuracy Vendor Invoice Accuracy
PastDueOrOpenItems Past Due and Open

Comments