I_CommodityCodeForKeyDate

DDL: I_COMMODITYCODEFORKEYDATE SQL: ICMDTYCDFORKDATE Type: view COMPOSITE Package: VDM_SLL_CLS
20 Fields 2 Data Sources

Commodity Code for Key Date

I_CommodityCodeForKeyDate is a Composite CDS View that provides data about "Commodity Code for Key Date" in SAP S/4HANA. It reads from 2 data sources (I_TrdClassfctnNmbrSchmCntntAct, I_CommodityCode) and exposes 20 fields with key fields TrdClassfctnNmbrSchm, CommodityCode. Part of development package VDM_SLL_CLS.

Data Sources (2)

SourceAliasJoin Type
I_TrdClassfctnNmbrSchmCntntAct _TrdClassfctnNmbrSchmCntntAct inner
I_CommodityCode CommodityCode from

Parameters (1)

NameTypeDefault
P_KeyDate sll_validon

Annotations (8)

NameValueLevelField
EndUserText.label Commodity Code for Key Date view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ICMDTYCDFORKDATE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY TrdClassfctnNmbrSchm I_TrdClassfctnNmbrSchmCntntAct TrdClassfctnNmbrSchm Numbering Scheme
KEY CommodityCode CommodityCode Commodity Code
TrdClassfctnNmbrSchmCntnt I_CommodityCode TrdClassfctnNmbrSchmCntnt No. Scheme Content
ValidityStartDate I_CommodityCode ValidityStartDate Validity Start Date
ValidityEndDate I_CommodityCode ValidityEndDate ValidTo
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbrForOfclDesc
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbrForCnctntdDesc
UnitOfMeasureSystem UnitOfMeasureSystem
CustomsUnitOfMeasure CustomsUnitOfMeasure
SecondCustomsUnitOfMeasure SecondCustomsUnitOfMeasure
SupplementaryUnit SupplementaryUnit
SecondSupplementaryUnit SecondSupplementaryUnit
_OfficialDesc _OfficialDesc
_CnctntdDesc _CnctntdDesc
_TrdClassfctnNmbrSchmCntnt _TrdClassfctnNmbrSchmCntnt
_TrdClassfctnNmbrSchm I_TrdClassfctnNmbrSchmCntntAct _TrdClassfctnNmbrSchm
_SupplementaryUnit _SupplementaryUnit
_SecondSupplementaryUnit _SecondSupplementaryUnit
_CustomsUnitOfMeasure _CustomsUnitOfMeasure
_SecondCustomsUnitOfMeasure _SecondCustomsUnitOfMeasure

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_CommodityCodeForKeyDate.
-- 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: ICMDTYCDFORKDATE
-- Parameters: P_KeyDate : sll_validon

CREATE VIEW I_CommodityCodeForKeyDate AS
SELECT
  _TrdClassfctnNmbrSchmCntntAct.TrdClassfctnNmbrSchm AS TrdClassfctnNmbrSchm,
  CommodityCode,
  CommodityCode.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  CommodityCode.ValidityStartDate AS ValidityStartDate,
  CommodityCode.ValidityEndDate AS ValidityEndDate,
  TrdClassfctnNmbrForOfclDesc,
  TrdClassfctnNmbrForCnctntdDesc,
  UnitOfMeasureSystem,
  CustomsUnitOfMeasure,
  SecondCustomsUnitOfMeasure,
  SupplementaryUnit,
  SecondSupplementaryUnit,
  _TrdClassfctnNmbrSchmCntntAct._TrdClassfctnNmbrSchm AS _TrdClassfctnNmbrSchm
FROM I_CommodityCode AS CommodityCode
INNER JOIN I_TrdClassfctnNmbrSchmCntntAct AS _TrdClassfctnNmbrSchmCntntAct ON /* join condition not captured in parsed metadata */
;

Learn More