POFulfillment
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - POFulfillment
Overview
This reporting view provides a comprehensive overview of purchase documents and their associated delivery schedules in SAP systems. It combines data from the PurchaseDocuments and POSchedule tables to offer insights into the status of purchase orders, including scheduled and received quantities, delivery dates, and other relevant information.
Data Sources
| Source Table/View | Description |
|---|---|
| PurchaseDocuments | Contains header-level information about purchase orders, such as document numbers, vendor details, and order values. |
| POSchedule | Provides schedule-level data for purchase orders, including scheduled delivery dates, quantities, and goods received information. |
Key Use Cases
- Monitoring the progress of purchase orders and deliveries.
- Identifying potential delays or discrepancies in delivery schedules.
- Analyzing purchase order performance and optimizing procurement processes.
- Providing a consolidated view of purchase order and delivery data for reporting and analysis purposes.
Query Logic
The view uses a common table expression (CTE) named eket to aggregate schedule-level data from the POSchedule table. This CTE is then joined with the PurchaseDocuments table using the Client_MANDT, DocumentNumber_EBELN, and Item_EBELP fields to link purchase order header information with the corresponding delivery schedule data. The query calculates total scheduled and received quantities, considering the ReturnsItem_RETPO flag to handle returns correctly.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| ME23N | Display Purchase Order |
| ME22N | Change Purchase Order |
| VL03N | Display Delivery |
| VL02N | Change Delivery |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| DocumentNumber_EBELN | Purchasing Document Number | |
| Item_EBELP | Item Number of Purchasing Document | |
| DocumentCategory_BSTYP | Document Category | |
| DocumentType_BSART | Document Type | |
| VendorAccountNumber_LIFNR | Vendor Account Number | |
| Language_SPRAS | Language | |
| TermsPaymentKey_ZTERM | Terms of Payment Key | |
| CashDiscountPercentage1_ZBD1P | Cash Discount Percentage 1 | |
| PurchasingOrganization_EKORG | Purchasing Organization | |
| PurchasingGroup_EKGRP | Purchasing Group | |
| CurrencyKey_WAERS | Currency Key | |
| MaterialNumber_MATNR | Material Number | |
| ShortText_TXZ01 | Short Text | |
| MaterialGroup_MATKL | Material Group | |
| StorageLocation_LGORT | Storage Location | |
| POQuantity_MENGE | PO Quantity | |
| UoM_MEINS | Unit of Measure | |
| OrderPriceUnit_BPRME | Order Price Unit | |
| NetPrice_NETPR | Net Price | |
| NetOrderValueinPOCurrency_NETWR | Net Order Value in PO Currency | |
| GrossordervalueinPOcurrency_BRTWR | Gross Order Value in PO Currency | |
| DeliveryCompletedFlag_ELIKZ | Delivery Completed Flag | |
| NetWeight_NTGEW | Net Weight | |
| ReturnsItem_RETPO | Returns Item | |
| ItemDeliveryDate_EINDT | Item Delivery Date | |
| TotalScheduledQty | Total Scheduled Quantity | |
| TotalReceivedQty | Total Received Quantity | |
| PendingQty | Pending Quantity |