C_ProdCommodityCodeForKeyDate

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_ProdCommodityCodeForKeyDate.
-- 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: CPRCMDTYCDFKDATE
-- Parameters: P_KeyDate : sll_validon

CREATE VIEW C_ProdCommodityCodeForKeyDate AS
SELECT
  Class.TrdClassfctnNmbrSchm AS TrdClassfctnNmbrSchm,
  Class.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  Class.Product AS Product,
  Class.ValidityStartDate AS ValidityStartDate,
  Class.ValidityEndDate AS ValidityEndDate,
  cast (_CommodityCode.TrdClassfctnNmbr as /sapsll/comco) AS CommodityCode,
  _TrdClassfctnNmbrSchmUsge.Country AS Country,
  _CommodityCode.CustomsUnitOfMeasure AS CustomsUnitOfMeasure,
  _CommodityCode.UnitOfMeasureSystem AS UnitOfMeasureSystem,
  _CommodityCode.SecondCustomsUnitOfMeasure AS SecondCustomsUnitOfMeasure,
  _CommodityCode.SecondSupplementaryUnit AS SecondSupplementaryUnit,
  _CommodityCode.SupplementaryUnit AS SupplementaryUnit,
  _CommodityCode._CustomsUnitOfMeasure AS _CustomsUnitOfMeasure,
  _CommodityCode._SecondCustomsUnitOfMeasure AS _SecondCustomsUnitOfMeasure,
  _CommodityCode._SupplementaryUnit AS _SupplementaryUnit,
  _CommodityCode._SecondSupplementaryUnit AS _SecondSupplementaryUnit
FROM C_ProductTrdClassfctn
INNER JOIN I_TrdClassfctnNmbrSchmUsge AS _TrdClassfctnNmbrSchmUsge ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TrdClassfctnNmbr AS _CommodityCode ON _CommodityCode.TrdClassfctnNmbr = Class.TrdClassfctnNmbr AND _CommodityCode.TrdClassfctnNmbrSchmCntnt = Class.TrdClassfctnNmbrSchmCntnt  -- association [0..1]
LEFT OUTER JOIN I_TrdClassfctnNmbrText AS _CommodityCodeText ON _CommodityCodeText.TrdClassfctnNmbrSchmCntnt = TrdClassfctnNmbrSchmCntnt AND _CommodityCodeText.TrdClassfctnNmbr = CommodityCode AND _CommodityCodeText.TrdClassfctnNmbrTextType = 'A' AND _CommodityCodeText.ValidityStartDate = ValidityStartDate  -- association [0..*]
;