SalesOrderStatus
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - SalesOrderStatus
Overview
This reporting view provides a comprehensive overview of sales documents and their related items, deliveries, and statuses from SAP systems. It combines data from multiple SAP tables to offer a consolidated view of sales transactions.
Data Sources
| Source Table/View | Description |
|---|---|
| vbap | Sales document item table containing information about individual items within a sales document, including quantity, material number, and batch number. |
| vbup | Goods movement table that tracks the status of goods movements for each sales document item. |
| lips | Delivery item table that provides details about deliveries related to sales document items, such as actual quantity delivered and reference document. |
| vbak | Sales document header table that contains general information about sales documents, such as document type, customer group, and creation date. |
| vbuk | Sales document status table that indicates the overall status of a sales document, including rejection and delivery status. |
Key Use Cases
- Analyzing sales performance by item, customer group, and other dimensions.
- Monitoring the status of deliveries and goods movements.
- Identifying potential issues or delays in the sales process.
- Providing insights for optimizing inventory management and logistics.
Query Logic
The query combines data from the vbap, vbup, lips, vbak, and vbuk tables using inner joins to ensure that only matching records are included. It calculates the open quantity for each sales document item by subtracting the actual quantity delivered from the cumulative order quantity.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VA01 | Create Sales Order |
| VA02 | Change Sales Order |
| VL01N | Create Delivery |
| VL02N | Change Delivery |
| SD_VBAK | Display Sales Document Header |
| SD_VBAP | Display Sales Document Item |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| SalesDocument_VBELN | Sales Document Number | |
| Item_POSNR | Item Number | |
| MaterialNumber_MATNR | Material Number | |
| SalesDocumentType_AUART | Sales Document Type | |
| Reason_AUGRU | Reason for Sales Document | |
| CustomerGroup1_KVGR1 | Customer Group 1 | |
| CustomerGroup2_KVGR2 | Customer Group 2 | |
| CustomerGroup3_KVGR3 | Customer Group 3 | |
| CustomerGroup4_KVGR4 | Customer Group 4 | |
| CustomerGroup5_KVGR5 | Customer Group 5 | |
| DeliveryBlock_LIFSK | Delivery Block | |
| PlanningPlant_VPWRK | Planning Plant | |
| StorageLocation_LGORT | Storage Location | |
| BatchNumber_CHARG | Batch Number | |
| CumulativeOrderQuantity_KWMENG | Cumulative Order Quantity | |
| ReferenceDocument_VGBEL | Reference Document Number | |
| ReferenceItem_VGPOS | Reference Item Number | |
| ActualQuantityDelivered_LFIMG | Actual Quantity Delivered | |
| DocumentCategory_VGTYP | Document Category | |
| SerialNumberProfile_SERAIL | Serial Number Profile | |
| NumberOfSerialNumbers_ANZSN | Number of Serial Numbers | |
| HeaderRejectionStatus_ABSTK | Header Rejection Status | |
| HeaderDeliveryStatus_LFGSK | Header Delivery Status | |
| GoodsMovementStatus_WBSTA | Goods Movement Status | |
| CreationDate_ERDAT | Creation Date | |
| CreationTime_ERZET | Creation Time | |
| RequestedDeliveryDate_VDATU | Requested Delivery Date | |
| CompleteDeliveryFlag_AUTLF | Complete Delivery Flag | |
| Delivery_VBELN | Delivery Document Number | |
| DeliveryItem_POSNR | Delivery Item Number | |
| OPENQTY | Open Quantity |