UoMMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - UoMMD
Overview
This reporting view provides information about units of measurement in SAP systems. It includes data on the unit of measurement itself, such as its ID, description, and conversion factors, as well as information on the language and dimension of the unit of measurement.
Data Sources
| Source Table/View | Description |
|---|---|
| T006 | Unit of Measurement Master Data |
| T006T | Unit of Measurement Texts |
| T006A | Unit of Measurement Texts (Additional) |
Key Use Cases
- Reporting on units of measurement used in the system
- Converting units of measurement between different formats
- Validating the accuracy of unit of measurement data
Query Logic
The view joins the T006, T006T, and T006A tables on the MANDT, DIMID, and SPRAS fields, respectively. This ensures that the view contains all of the relevant data for each unit of measurement.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| OMWB | Unit of Measurement Maintenance |
| CUNI | Unit Conversion |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| UnitOfMeasurement_MSEHI | Unit of Measurement | |
| ThreeCharIndicatorForExternalUnitOfMeasurement_KZEX3 | Three Character Indicator for External Unit of Measurement | |
| SixCharIdForExternalUnitOfMeasurement_KZEX6 | Six Character Id for External Unit of Measurement | |
| LanguageKey_SPRAS | Language Key | |
| DimensionText_TXDIM | Dimension Text | |
| UnitOfMeasurementText__maximum10Characters___MSEHT | Unit of Measurement Text (maximum 10 characters) | |
| UnitOfMeasurementText__maximum30Characters___MSEHL | Unit of Measurement Text (maximum 30 characters) |