SalesStatus_Items
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - SalesStatus_Items
Overview
This reporting view provides a consolidated view of sales order, delivery, and invoice data for SAP systems. It combines information from multiple tables to offer a comprehensive view of the sales process, including order status, quantities, values, and material details.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.SDDocumentFlow (SO) |
Sales order header data, including order status and key identifiers. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.SalesOrders (vbap) |
Sales order item data, including quantities, pricing, and material information. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.MaterialsMD (mat) |
Material master data, including material descriptions and product hierarchy. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.SDStatus_Items (so_status) |
Sales order status data, including delivery and invoice status. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.SDStatus_Items (del_status) |
Delivery status data, including delivery quantities and units of measure. |
Key Use Cases
- Analyzing sales performance and order fulfillment.
- Tracking the status of sales orders, deliveries, and invoices.
- Identifying bottlenecks and inefficiencies in the sales process.
- Providing insights for sales forecasting and inventory management.
Query Logic
The query joins the SDDocumentFlow table with the SalesOrders, MaterialsMD, and SDStatus_Items tables using the Client_MANDT, SalesOrder_VBELV, SalesItem_POSNV, and SDDocumentNumber_VBELN fields to link related records. It also includes a left outer join to the SDStatus_Items table (aliased as del_status) to retrieve delivery status information. The query retrieves key sales order, delivery, and invoice data, as well as material details and status information.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VA01 | Create Sales Order |
| VA02 | Change Sales Order |
| VL01N | Create Delivery |
| VL02N | Change Delivery |
| VF01 | Create Invoice |
| VF02 | Change Invoice |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| SalesOrder_VBELV | Sales Order Number | |
| SalesItem_POSNV | Sales Order Item Number | |
| Delivery_Status | Delivery Status | |
| DeliveryNumber_VBELV | Delivery Number | |
| DeliveryItem_POSNV | Delivery Item Number | |
| InvoiceNumber_VBELN | Invoice Number | |
| InvoiceItem_POSNN | Invoice Item Number | |
| SalesQty | Sales Quantity | |
| SalesUnit_VRKME | Sales Unit of Measure | |
| NetPrice_NETWR | Net Price | |
| Currency_WAERK | Currency | |
| DeliveredQty_RFMNG | Delivered Quantity | |
| DeliveredUoM_MEINS | Delivered Unit of Measure | |
| InvoiceQty_RFMNG | Invoice Quantity | |
| InvoiceUoM_MEINS | Invoice Unit of Measure | |
| InvoiceValue_RFWRT | Invoice Value | |
| InvoiceCurrency_WAERS | Invoice Currency | |
| MaterialNumber_MATNR | Material Number | |
| MaterialText_MAKTX | Material Description | |
| ProductHierarchy_PRODH | Product Hierarchy | |
| Language_SPRAS | Language |