I_CFD_UnitOfMeasureText

DDL: I_CFD_UNITOFMEASURETEXT SQL: ICFDUNITOFMSRTXT Type: view
6 Fields 1 Data Sources

I_CFD_UnitOfMeasureText is a CDS View in SAP S/4HANA. It reads from 1 data source (t006a) and exposes 6 fields with key fields Language, UnitOfMeasure.

Data Sources (1)

SourceAliasJoin Type
t006a t006a from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName ICFDUNITOFMSRTXT view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #TEXT view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Language spras Off. Language
KEY UnitOfMeasure msehi Unit of measmnt
UnitOfMeasure_E mseh3 Commercial
UnitOfMeasureTechnicalName mseh6 Unit (6-char.)
UnitOfMeasureName mseht Meas. Unit Text
UnitOfMeasureLongName msehl Meas. Unit Text

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CFD_UnitOfMeasureText.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICFDUNITOFMSRTXT

CREATE VIEW I_CFD_UnitOfMeasureText AS
SELECT
  spras AS Language,
  msehi AS UnitOfMeasure,
  mseh3 AS UnitOfMeasure_E,
  mseh6 AS UnitOfMeasureTechnicalName,
  mseht AS UnitOfMeasureName,
  msehl AS UnitOfMeasureLongName
FROM t006a
;

Learn More