SDDocumentFlow
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - 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 about sales orders, delivery items, and invoice items.
Data Sources
| Source Table/View | Description |
|---|---|
| vbfa | Sales Order Item Table |
Key Use Cases
- Analyzing sales performance by tracking the progress of sales orders through delivery and invoicing.
- Identifying discrepancies between sales orders, deliveries, and invoices.
- Reconciling sales data for financial reporting and auditing purposes.
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 delivery items with vbtyp_n = '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 |