I_CommodityCodeCntntVersDetail

DDL: I_COMMODITYCODECNTNTVERSDETAIL SQL: ICMDTYCDCNTVERD Type: view COMPOSITE Package: VDM_SLL_CLS
15 Fields 2 Data Sources 2 Associations

Commodity Code Content Version Detail

I_CommodityCodeCntntVersDetail is a Composite CDS View that provides data about "Commodity Code Content Version Detail" in SAP S/4HANA. It reads from 2 data sources (I_TrdClassfctnCntntNmbr, I_TrdClassfctnCntntVersionLang) and exposes 15 fields with key fields TrdClassfctnNmbrUUID, Language. It has 2 associations to related views. Part of development package VDM_SLL_CLS.

Data Sources (2)

SourceAliasJoin Type
I_TrdClassfctnCntntNmbr _CommodityCode from
I_TrdClassfctnCntntVersionLang _Language cross

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_TrdClsfctnCntntNmbrOfclDesc _OfficialDesc _CommodityCode.TrdClassfctnNmbr = _OfficialDesc.TrdClassfctnNmbr and _CommodityCode.TrdClassfctnNmbrSchmCntnt = _OfficialDesc.TrdClassfctnNmbrSchmCntnt and _CommodityCode.TrdClassfctnCntntVersion = _OfficialDesc.TrdClassfctnCntntVersion and _CommodityCode.ValidityStartDate = _OfficialDesc.ValidityStartDate and _Language.Language = _OfficialDesc.Language
[0..1] I_TrdClsfctnCntntNmbrCoDesc _CnctntdDesc _CommodityCode.TrdClassfctnNmbr = _CnctntdDesc.TrdClassfctnNmbr and _CommodityCode.TrdClassfctnNmbrSchmCntnt = _CnctntdDesc.TrdClassfctnNmbrSchmCntnt and _CommodityCode.TrdClassfctnCntntVersion = _CnctntdDesc.TrdClassfctnCntntVersion and _CommodityCode.ValidityStartDate = _CnctntdDesc.ValidityStartDate and _Language.Language = _CnctntdDesc.Language

Annotations (9)

NameValueLevelField
EndUserText.label Commodity Code Content Version Detail view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ICMDTYCDCNTVERD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY TrdClassfctnNmbrUUID I_TrdClassfctnCntntNmbr TrdClassfctnNmbrUUID UUID
KEY Language I_TrdClassfctnCntntVersionLang Language Report Text Language
TrdClassfctnCntntUUID I_TrdClassfctnCntntNmbr TrdClassfctnCntntUUID UUID
CommodityCode
TrdClassfctnCntntVersUUID I_TrdClassfctnCntntNmbr TrdClassfctnCntntVersUUID UUID
TrdClassfctnNmbrSchmCntnt I_TrdClassfctnCntntNmbr TrdClassfctnNmbrSchmCntnt No. Scheme Content
TrdClassfctnCntntVersion I_TrdClassfctnCntntNmbr TrdClassfctnCntntVersion Version
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbr Number
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbr Number
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
CustomsUnitOfMeasure CustomsUnitOfMeasure 1st Customs Unit
SecondCustomsUnitOfMeasure SecondCustomsUnitOfMeasure 2nd Customs Unit
_OfficialDesc _OfficialDesc
_CnctntdDesc _CnctntdDesc

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_CommodityCodeCntntVersDetail.
-- 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: ICMDTYCDCNTVERD

CREATE VIEW I_CommodityCodeCntntVersDetail AS
SELECT
  _CommodityCode.TrdClassfctnNmbrUUID AS TrdClassfctnNmbrUUID,
  _Language.Language AS Language,
  _CommodityCode.TrdClassfctnCntntUUID AS TrdClassfctnCntntUUID,
  cast ( _CommodityCode.TrdClassfctnNmbr as /sapsll/comco) AS CommodityCode,
  _CommodityCode.TrdClassfctnCntntVersUUID AS TrdClassfctnCntntVersUUID,
  _CommodityCode.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  _CommodityCode.TrdClassfctnCntntVersion AS TrdClassfctnCntntVersion,
  TrdClassfctnNmbr AS TrdClassfctnNmbrForOfclDesc,
  TrdClassfctnNmbr AS TrdClassfctnNmbrForCnctntdDesc,
  ValidityStartDate,
  ValidityEndDate,
  CustomsUnitOfMeasure,
  SecondCustomsUnitOfMeasure
FROM I_TrdClassfctnCntntNmbr AS _CommodityCode
CROSS JOIN I_TrdClassfctnCntntVersionLang AS _Language
LEFT OUTER JOIN I_TrdClsfctnCntntNmbrOfclDesc AS _OfficialDesc ON _CommodityCode.TrdClassfctnNmbr = _OfficialDesc.TrdClassfctnNmbr AND _CommodityCode.TrdClassfctnNmbrSchmCntnt = _OfficialDesc.TrdClassfctnNmbrSchmCntnt AND _CommodityCode.TrdClassfctnCntntVersion = _OfficialDesc.TrdClassfctnCntntVersion AND _CommodityCode.ValidityStartDate = _OfficialDesc.ValidityStartDate AND _Language.Language = _OfficialDesc.Language  -- association [0..1]
LEFT OUTER JOIN I_TrdClsfctnCntntNmbrCoDesc AS _CnctntdDesc ON _CommodityCode.TrdClassfctnNmbr = _CnctntdDesc.TrdClassfctnNmbr AND _CommodityCode.TrdClassfctnNmbrSchmCntnt = _CnctntdDesc.TrdClassfctnNmbrSchmCntnt AND _CommodityCode.TrdClassfctnCntntVersion = _CnctntdDesc.TrdClassfctnCntntVersion AND _CommodityCode.ValidityStartDate = _CnctntdDesc.ValidityStartDate AND _Language.Language = _CnctntdDesc.Language  -- association [0..1]
;

Learn More