SEPM_I_UnitOfMeasureText

DDL: SEPM_I_UNITOFMEASURETEXT SQL: SEPM_IUOMT Type: view
6 Fields 1 Data Sources 2 Associations

EPM Demo: Unit of Measure Text

SEPM_I_UnitOfMeasureText is a CDS View that provides data about "EPM Demo: Unit of Measure Text" in SAP S/4HANA. It reads from 1 data source (t006a) and exposes 6 fields with key fields UnitOfMeasure, Language. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t006a t006a from

Associations (2)

CardinalityTargetAliasCondition
[1..1] SEPM_I_UnitOfMeasure _UnitOfMeasure $projection.UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure
[0..1] SEPM_I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
EndUserText.label EPM Demo: Unit of Measure Text view
ObjectModel.dataCategory #TEXT view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName SEPM_IUOMT view
ObjectModel.representativeKey UnitOfMeasure view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.numberOfKeyFields 2 view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY UnitOfMeasure msehi Unit of measmnt
_UnitOfMeasure _UnitOfMeasure
KEY Language spras Off. Language
_Language _Language
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 SEPM_I_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: SEPM_IUOMT

CREATE VIEW SEPM_I_UnitOfMeasureText AS
SELECT
  msehi AS UnitOfMeasure,
  spras AS Language,
  mseht AS UnitOfMeasureName,
  msehl AS UnitOfMeasureLongName
FROM t006a
LEFT OUTER JOIN SEPM_I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN SEPM_I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More