ESH_N_UNIT_OF_MEASURE_T006A

DDL: ESH_N_UNIT_OF_MEASURE_T006A SQL: ESH_L_UNI_T006A Type: view
7 Fields 1 Data Sources 1 Associations

Assign Internal to Language-Dependent Unit

ESH_N_UNIT_OF_MEASURE_T006A is a CDS View that provides data about "Assign Internal to Language-Dependent Unit" in SAP S/4HANA. It reads from 1 data source (t006a) and exposes 7 fields with key fields spras, msehi. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
t006a t006a from

Associations (1)

CardinalityTargetAliasCondition
[1..1] ESH_N_UNIT_OF_MEASURE_FMEASURE _TO_T006A $projection.msehi = _TO_T006A.msehi

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ESH_L_UNI_T006A view
EndUserText.label Assign Internal to Language-Dependent Unit view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
AbapCatalog.compiler.compareFilter true view

Fields (7)

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

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 ESH_N_UNIT_OF_MEASURE_T006A.
-- 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: ESH_L_UNI_T006A

CREATE VIEW ESH_N_UNIT_OF_MEASURE_T006A AS
SELECT
  spras,
  msehi,
  mseh3,
  mseh6,
  mseht,
  msehl
FROM t006a
LEFT OUTER JOIN ESH_N_UNIT_OF_MEASURE_FMEASURE AS _TO_T006A ON msehi = _TO_T006A.msehi  -- association [1..1]
;

Learn More