C_ProdCstmsTrifNmbrForKeyDate

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_ProdCstmsTrifNmbrForKeyDate.
-- 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: CPRTRIFNOFKDATE
-- Parameters: P_KeyDate : sll_validon

CREATE VIEW C_ProdCstmsTrifNmbrForKeyDate AS
SELECT
  Class.TrdClassfctnNmbrSchm AS TrdClassfctnNmbrSchm,
  Class.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  Class.Product AS Product,
  Class.ValidityStartDate AS ValidityStartDate,
  Class.ValidityEndDate AS ValidityEndDate,
  cast (_CustomsTariffNumber.TrdClassfctnNmbr as /sapsll/tarno) AS CustomsTariffNumber,
  _TrdClassfctnNmbrSchmUsge.Country AS Country,
  _CustomsTariffNumber.CustomsUnitOfMeasure AS CustomsUnitOfMeasure,
  _CustomsTariffNumber.UnitOfMeasureSystem AS UnitOfMeasureSystem,
  _CustomsTariffNumber.SecondCustomsUnitOfMeasure AS SecondCustomsUnitOfMeasure,
  _CustomsTariffNumber.SupplementaryUnit AS SupplementaryUnit,
  _CustomsTariffNumber._CustomsUnitOfMeasure AS _CustomsUnitOfMeasure,
  _CustomsTariffNumber._SecondCustomsUnitOfMeasure AS _SecondCustomsUnitOfMeasure,
  _CustomsTariffNumber._SupplementaryUnit AS _SupplementaryUnit
FROM C_ProductTrdClassfctn
LEFT OUTER JOIN I_TrdClassfctnNmbr AS _CustomsTariffNumber ON _CustomsTariffNumber.TrdClassfctnNmbr = Class.TrdClassfctnNmbr AND _CustomsTariffNumber.TrdClassfctnNmbrSchmCntnt = Class.TrdClassfctnNmbrSchmCntnt  -- association [0..1]
LEFT OUTER JOIN I_TrdClassfctnNmbrText AS _Text ON _Text.TrdClassfctnNmbrSchmCntnt = TrdClassfctnNmbrSchmCntnt AND _Text.TrdClassfctnNmbr = CustomsTariffNumber AND _Text.TrdClassfctnNmbrTextType = 'A' AND _Text.ValidityStartDate = ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_TrdClassfctnNmbrSchmUsge AS _TrdClassfctnNmbrSchmUsge ON _TrdClassfctnNmbrSchmUsge.TrdClassfctnNmbrSchm = Class.TrdClassfctnNmbrSchm  -- association [0..1]
;