UoMConversion
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - UoMConversion
Overview
This reporting view is used to calculate the conversion factor between two units of measure in the SAP system. It takes two input units of measure, along with their respective quantities and dimensions, and calculates the conversion factor between them.
Data Sources
| Source Table/View | Description |
|---|---|
| t006 | The t006 table contains the unit of measure conversions for materials in the SAP system. |
Key Use Cases
- This view can be used to convert quantities between different units of measure in the SAP system.
- It can also be used to identify the conversion factor between two units of measure.
Query Logic
The view uses a combination of LEFT OUTER JOINs and arithmetic operations to calculate the conversion factor between the two input units of measure. The view first selects the rows from the t006 table that correspond to the two input units of measure. It then calculates the conversion factor by dividing the quantity in the output unit of measure by the quantity in the input unit of measure.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM02 | Create/Change Material Master |
| ME21N | Create Purchase Order |
| VL01N | Create Delivery |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| unit_out | Unit of measure for the output value | |
| dimid | Dimension of the output value | |
| nennr | Numerator of the output value | |
| zaehl | Denominator of the output value | |
| unit_in | Unit of measure for the input value | |
| to_nennr | Numerator of the input value | |
| to_zaehl | Denominator of the input value | |
| to_conv | Conversion factor between the input and output units of measure | |
| exp_pos | Difference between the exponents of the output and input values (positive) | |
| num_neg | Numerator of the negative conversion calculation | |
| denom_neg | Denominator of the negative conversion calculation | |
| num_pos | Numerator of the positive conversion calculation | |
| denom_pos | Denominator of the positive conversion calculation | |
| dimension | Dimension of the input and output values | |
| val_out | Output value |