OneTouchOrder
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - OneTouchOrder
Overview
This reporting view provides a distinct count of one-touch orders for a given sales document and item combination. It combines data from the VBAP, VBEP, LIPS, and VBRP tables to calculate the total ordered quantity, actual billed quantity, and number of one-touch orders for each combination.
Data Sources
| Source Table/View | Description |
|---|---|
| VBAP | Sales Document Item table |
| VBEP | Sales Document Schedule Line table |
| LIPS | Delivery Item table |
| VBRP | Billing Document Item table |
Key Use Cases
- Analyzing the number of one-touch orders for a given sales document and item combination
- Identifying sales documents and items with a high number of one-touch orders
- Understanding the relationship between ordered quantity, billed quantity, and one-touch orders
Query Logic
The query first calculates the total ordered quantity, actual billed quantity, and number of one-touch orders for each combination of sales document and item. It then joins the results with the VBRP table to filter for combinations where the total ordered quantity matches the actual billed quantity.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VA01 | Create Sales Order |
| VA02 | Change Sales Order |
| VF01 | Create Billing Document |
| VF02 | Change Billing Document |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| VBAPClient_MANDT | Client of the sales document item | |
| VBAPSalesDocument_VBELN | Sales document number | |
| VBAPSalesDocument_Item_POSNR | Item number of the sales document | |
| VBAPTotalOrder_KWMENG | Total quantity ordered | |
| ActualBilledQuantity_FKIMG | Actual billed quantity | |
| OneTouchOrderCount | Number of one-touch orders for the sales document item |