VendorLeadTimeOverview
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - VendorLeadTimeOverview
Overview
The 'VendorLeadTimeOverview' view provides a summary of vendor performance metrics, including average lead time in days, for a given client. It is designed as a reference for calculations used in dashboards and is not intended for extensive reporting or analytical use.
Data Sources
| Source Table/View | Description |
|---|---|
| VendorPerformance | A table that stores vendor performance data, including vendor account number, vendor name, vendor country, company code, company name, purchasing group, purchasing group name, purchasing organization, purchasing organization name, purchasing document date, target currency, and language key. |
Key Use Cases
- Monitoring vendor performance and identifying areas for improvement.
- Providing insights into vendor lead times and optimizing procurement processes.
- Supporting decision-making related to vendor selection and management.
Query Logic
The view calculates the average lead time in days for each vendor by partitioning the data by vendor account number and then calculating the average of the VendorCycleTimeInDays column within each partition. The query also includes filters to restrict the data to a specific client (specified by the '{{ mandt }}' parameter).
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| ME21N | Create Purchase Order |
| ME22N | Change Purchase Order |
| ME23N | Display Purchase Order |
| ME28 | Release Purchase Order |
| ME29N | Display Purchase Order History |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| VendorAccountNumber_LIFNR | Vendor account number | |
| NAME1 | Vendor name | |
| VendorCountry | Vendor country | |
| Company_BUKRS | Company code | |
| Company | Company name | |
| PurchasingGroup_EKGRP | Purchasing group | |
| PurchasingGroup | Purchasing group name | |
| PurchasingOrganization_EKORG | Purchasing organization | |
| PurchasingOrganization | Purchasing organization name | |
| PurchasingDocumentDate_BEDAT | Purchasing document date | |
| YearOfPurchasingDocumentDate_BEDAT | Year of purchasing document date | |
| MonthOfPurchasingDocumentDate_BEDAT | Month of purchasing document date | |
| WeekOfPurchasingDocumentDate_BEDAT | Week of purchasing document date | |
| TargetCurrency_TCURR | Target currency | |
| LanguageKey_SPRAS | Language key | |
| AverageLeadTimeInDays | Average lead time in days |