UoMMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - UoMMD
Overview
This reporting view provides information about units of measurement in SAP systems. It combines data from three tables: T006, T006T, and T006A.
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
- Identifying units of measurement for conversion between different units
- Displaying unit of measurement information in various applications
Query Logic
The view joins the three source tables on the MANDT (client) and MSEHI (unit of measurement) fields. It also filters the T006T table to include only rows with the specified language key (SPRAS).
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) |
|---|---|---|
| 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) |