UoMConversionUtil
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - UoMConversionUtil
Overview
This reporting view provides a mechanism to convert values between different units of measure in SAP systems. It calculates the conversion factor based on the unit of measure dimensions and the number of units in each dimension.
Data Sources
| Source Table/View | Description |
|---|---|
| t006 | Table containing unit of measure conversions |
Key Use Cases
- Converting values between different units of measure in reports and analysis
- Ensuring accuracy and consistency in unit of measure conversions
Query Logic
The view uses a combination of joins and calculations to determine the conversion factor between two units of measure. It first identifies the relevant unit of measure dimensions and the number of units in each dimension. Then, it calculates the conversion factor based on the formula: conversion_factor = (numerator / denominator) + (addition / denominator), where numerator = (unit_to_nennr * unit_from_zaehl) * (10 ^ (unit_to_exp10 - unit_from_exp10)), denominator = (unit_from_nennr * unit_to_zaehl) * (10 ^ (unit_from_exp10 - unit_to_exp10)), and addition = (unit_to_addko - unit_from_addko) * unit_from_to_conv.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM02 | Material Master: Create/Change |
| ME21N | Create Purchase Order |
| VL01N | Create Delivery |
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 conversion | |
| val_out | Conversion value |