C_CommodityCodeByLanguage

DDL: C_COMMODITYCODEBYLANGUAGE SQL: CCMDTYCDBYLANG Type: view CONSUMPTION
26 Fields 2 Data Sources 2 Associations

Commodity code for given language

C_CommodityCodeByLanguage is a Consumption CDS View that provides data about "Commodity code for given language" in SAP S/4HANA. It reads from 2 data sources (I_Language, I_CommodityCode) and exposes 26 fields with key fields Language, TrdClassfctnNmbrSchmCntnt, CommodityCode, ValidityStartDate. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_Language _Language cross
I_CommodityCode CommodityCode from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_TrdClassfctnNmbrOfclDescByLa _OfficialDescOnLanguage _OfficialDescOnLanguage.TrdClassfctnNmbrSchmCntnt = $projection.TrdClassfctnNmbrSchmCntnt and _OfficialDescOnLanguage.TrdClassfctnNmbr = $projection.CommodityCode and _OfficialDescOnLanguage.ValidityStartDate = $projection.ValidityStartDate and _OfficialDescOnLanguage.Language = $projection.Language
[0..1] I_TrdClassfctnNmbrCoDescByLa _CnctntdDescOnLanguage _CnctntdDescOnLanguage.TrdClassfctnNmbrSchmCntnt = $projection.TrdClassfctnNmbrSchmCntnt and _CnctntdDescOnLanguage.TrdClassfctnNmbr = $projection.CommodityCode and _CnctntdDescOnLanguage.ValidityStartDate = $projection.ValidityStartDate and _CnctntdDescOnLanguage.Language = $projection.Language

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCMDTYCDBYLANG view
AbapCatalog.preserveKey true view
EndUserText.label Commodity code for given language view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Language I_Language Language Report Text Language
KEY TrdClassfctnNmbrSchmCntnt I_CommodityCode TrdClassfctnNmbrSchmCntnt
KEY CommodityCode CommodityCode Commodity Code
KEY ValidityStartDate I_CommodityCode ValidityStartDate Validity Start Date
ValidityEndDate I_CommodityCode ValidityEndDate ValidTo
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbrForOfclDesc
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbrForCnctntdDesc
SupplementaryUnit SupplementaryUnit
SecondSupplementaryUnit SecondSupplementaryUnit
CustomsUnitOfMeasure CustomsUnitOfMeasure
SecondCustomsUnitOfMeasure SecondCustomsUnitOfMeasure
UnitOfMeasureSystem UnitOfMeasureSystem
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_OfficialDescOnLanguage _OfficialDescOnLanguage
_CnctntdDescOnLanguage _CnctntdDescOnLanguage
_OfficialDesc _OfficialDesc
_CnctntdDesc _CnctntdDesc
_SupplementaryUnit _SupplementaryUnit
_SecondSupplementaryUnit _SecondSupplementaryUnit
_CustomsUnitOfMeasure _CustomsUnitOfMeasure
_SecondCustomsUnitOfMeasure _SecondCustomsUnitOfMeasure
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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 C_CommodityCodeByLanguage.
-- 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: CCMDTYCDBYLANG

CREATE VIEW C_CommodityCodeByLanguage AS
SELECT
  _Language.Language AS Language,
  CommodityCode.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  CommodityCode,
  CommodityCode.ValidityStartDate AS ValidityStartDate,
  CommodityCode.ValidityEndDate AS ValidityEndDate,
  TrdClassfctnNmbrForOfclDesc,
  TrdClassfctnNmbrForCnctntdDesc,
  SupplementaryUnit,
  SecondSupplementaryUnit,
  CustomsUnitOfMeasure,
  SecondCustomsUnitOfMeasure,
  UnitOfMeasureSystem,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_CommodityCode AS CommodityCode
CROSS JOIN I_Language AS _Language
LEFT OUTER JOIN I_TrdClassfctnNmbrOfclDescByLa AS _OfficialDescOnLanguage ON _OfficialDescOnLanguage.TrdClassfctnNmbrSchmCntnt = TrdClassfctnNmbrSchmCntnt AND _OfficialDescOnLanguage.TrdClassfctnNmbr = CommodityCode AND _OfficialDescOnLanguage.ValidityStartDate = ValidityStartDate AND _OfficialDescOnLanguage.Language = Language  -- association [0..1]
LEFT OUTER JOIN I_TrdClassfctnNmbrCoDescByLa AS _CnctntdDescOnLanguage ON _CnctntdDescOnLanguage.TrdClassfctnNmbrSchmCntnt = TrdClassfctnNmbrSchmCntnt AND _CnctntdDescOnLanguage.TrdClassfctnNmbr = CommodityCode AND _CnctntdDescOnLanguage.ValidityStartDate = ValidityStartDate AND _CnctntdDescOnLanguage.Language = Language  -- association [0..1]
;

Learn More