UoMConversion
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - UoMConversion
Overview
This view is a reporting view for SAP systems. It is used to calculate 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
- This view can be used to convert values from one unit of measure to another.
- It can also be used to identify the conversion factor between two units of measure.
Query Logic
The view uses a left outer join to combine two instances of the t006 table. The first instance is used to represent the unit of measure that is being converted from, and the second instance is used to represent the unit of measure that is being converted to. The view then uses a series of calculations to determine the conversion factor between the two units of measure.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM02 | Create/Change Material Master |
| MM03 | Display Material Master |
| CUNI | Unit of Measure Conversion |
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 from input unit to output unit | |
| exp_pos | Exponent of the positive difference between the output and input values | |
| num_neg | Numerator of the negative difference between the output and input values | |
| denom_neg | Denominator of the negative difference between the output and input values | |
| num_pos | Numerator of the positive difference between the output and input values | |
| denom_pos | Denominator of the positive difference between the output and input values | |
| dimension | Dimension of the output value | |
| val_out | Output value |