C_ProdCmmdtyCodeObjPage

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_ProdCmmdtyCodeObjPage.
-- 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: CPRCMDCDOP

CREATE VIEW C_ProdCmmdtyCodeObjPage AS
SELECT
  _TrdClassfctnProduct.Product AS Product,
  _CmmdtyCodeNmbrSchm.TrdClassfctnNmbrSchm AS TrdClassfctnNmbrSchm,
  _TrdClassfctnNmbrSchmText[ 1: Language = $session.system_language ].TrdClassfctnNmbrSchmName AS TrdClassfctnNmbrSchmName,
  _ProdCmmdtyCodeForKeyDate(P_KeyDate : $session.system_date).CommodityCode AS CommodityCode,
  _ProdCmmdtyCodeForKeyDate(P_KeyDate : $session.system_date).TrdClassfctnNmbrForOfclDesc AS TrdClassfctnNmbrForOfclDesc,
  _ProdCmmdtyCodeForKeyDate(P_KeyDate : $session.system_date).TrdClassfctnNmbrForCnctntdDesc AS TrdClassfctnNmbrForCnctntdDesc,
  _ProdCmmdtyCodeForKeyDate(P_KeyDate : $session.system_date).ValidityStartDate AS ValidityStartDate,
  _ProdCmmdtyCodeForKeyDate(P_KeyDate : $session.system_date).ValidityEndDate AS ValidityEndDate,
  _ProdCmmdtyCodeForKeyDate(P_KeyDate : $session.system_date).TrdClassfctnRemark AS TrdClassfctnRemark,
  _ProdCmmdtyCodeForKeyDate(P_KeyDate : $session.system_date).TrdClassfctnNmbr AS TrdClassfctnNmbr,
  _ProdCmmdtyCodeForKeyDate(P_KeyDate : $session.system_date).TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  _ProdCmmdtyCodeForKeyDate(P_KeyDate : $session.system_date).TrdClassfctnNmbrStartDate AS TrdClassfctnNmbrStartDate,
  _ProdCmmdtyCodeForKeyDate(P_KeyDate : $session.system_date)._OfficialDesc AS _OfficialDesc,
  _ProdCmmdtyCodeForKeyDate(P_KeyDate : $session.system_date)._CnctntdDesc AS _CnctntdDesc
FROM I_TrdClassfctnProduct AS _TrdClassfctnProduct
CROSS JOIN I_CmmdtyCodeNmbrSchm AS _CmmdtyCodeNmbrSchm
LEFT OUTER JOIN I_ProdCmmdtyCodeForKeyDate AS _ProdCmmdtyCodeForKeyDate ON TrdClassfctnNmbrSchm = _ProdCmmdtyCodeForKeyDate.TrdClassfctnNmbrSchm AND Product = _ProdCmmdtyCodeForKeyDate.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON _Product.Product = Product  -- association [0..1]
;