UoMUsage_SAMPLE
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - UoMUsage_SAMPLE
Overview
This reporting view provides a consolidated view of sales fulfillment data from SAP systems, with a focus on converting delivered quantities to a consistent unit of measure (UoM). It joins data from the SalesFulfillment table with a UoM conversion utility table to perform the necessary conversions.
Data Sources
| Source Table/View | Description |
|---|---|
| SalesFulfillment | Contains sales fulfillment data, including material numbers, material descriptions, delivered quantities, and delivered UoMs. |
| UoMConversionUtil | Provides conversion factors for converting between different UoMs. |
Key Use Cases
- Reporting on sales fulfillment data in a consistent UoM.
- Analyzing sales trends and patterns across different materials and UoMs.
- Identifying areas for optimization in the sales fulfillment process.
Query Logic
The query first filters the SalesFulfillment data to include only records with delivered UoMs of 'G' (grams) or 'KG' (kilograms). It then joins this data with the UoMConversionUtil table to obtain the conversion factor for converting these UoMs to 'LB' (pounds). The converted quantities are calculated by multiplying the delivered quantities by the conversion factor.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VA01 | Create Sales Order |
| VA02 | Change Sales Order |
| VL01N | Create Delivery |
| VL02N | Change Delivery |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Salesfull.MaterialNumber_MATNR | Material number | |
| Salesfull.MaterialText_MAKTX | Material text | |
| Salesfull.DeliveredUoM_MEINS | Delivered unit of measure | |
| Salesfull.DeliveredQty | Delivered quantity | |
| conv.val_out | Conversion factor | |
| to_conv | Unit of measure to convert to | |
| converted | Converted quantity |