SDDocumentFlow
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - SDDocumentFlow
Overview
This reporting view provides a consolidated view of sales orders, deliveries, and invoices for SAP systems. It combines data from the VBFA table to display key information such as sales order numbers, delivery numbers, invoice numbers, delivered quantities, invoice quantities, invoice values, and currencies.
Data Sources
| Source Table/View | Description |
|---|---|
| vbfa | Sales Order Item Table |
Key Use Cases
- Analyzing sales performance and order fulfillment
- Reconciling deliveries and invoices with sales orders
- Identifying discrepancies in quantities and values between different documents
- Providing a comprehensive view of the sales order to invoice process
Query Logic
The query first selects data from the VBFA table for sales orders with vbtyp_V = 'C' and vbtyp_n IN ('J', 'T'). It then performs a left outer join with the same VBFA table to retrieve data for deliveries with vbtyp_n IN ('M') that are linked to the sales orders. The result is a consolidated view of sales orders, deliveries, and invoices.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VA01 | Create Sales Order |
| VL01N | Create Delivery |
| VF01 | Create 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 | |
| DeliveryNumber_VBELV | Delivery Number | |
| DeliveryItem_POSNV | Delivery Item Number | |
| InvoiceNumber_VBELN | Invoice Number | |
| InvoiceItem_POSNN | Invoice Item Number | |
| 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 |