UoMConversionUtil
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - UoMConversionUtil
Overview
This view is a reporting view for SAP systems. It calculates the conversion factor between two units of measure.
Data Sources
| Source Table/View | Description |
|---|---|
| t006 | Table containing the unit of measure conversions. |
Key Use Cases
- Can be used to convert values between different units of measure.
- Can be used to create reports on unit of measure conversions.
Query Logic
The view uses a left outer join to combine the data from the two tables. The join condition is on the mandt field, which is the client number. The view then calculates the conversion factor by dividing the nennr field (numerator) by the zaehl field (denominator).
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| unit_to | Unit of measure to convert to | |
| unit_from | Unit of measure to convert from | |
| mandt | Client | |
| dimension | Dimension of the unit of measure | |
| val_out | Conversion factor |