I_ReclassifyProdCstmsTrifNmbr

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_ReclassifyProdCstmsTrifNmbr.
-- 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: IRECLSPRTRIFNMBR
-- Parameters: P_KeyDate : sll_validon

CREATE VIEW I_ReclassifyProdCstmsTrifNmbr AS
SELECT
  TrdClassfctnNmbrSchm,
  Product,
  AuthorizationGroup,
  IsMarkedForDeletion,
  Product.ProductCategory AS ProductCategory,
  Product.ProductGroup AS ProductGroup,
  Product.Division AS Division,
  Product.ProductHierarchy AS ProductHierarchy,
  Product.ProductType AS ProductType,
  Product.ExternalProductGroup AS ExternalProductGroup,
  Product.IndustrySector AS IndustrySector,
  Product.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  cast (Product.TrdClassfctnNmbr as /sapsll/tarno) AS CustomsTariffNumber,
  Product.ValidityStartDate AS ValidityStartDate,
  Product.ValidityEndDate AS ValidityEndDate,
  TrdClassfctnRemark
FROM P_ReclassifyProductForKeyDate
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_CstmsTrifNmbrNmbrSchm AS _TrdClassfctnNmbrSchm ON TrdClassfctnNmbrSchm = _TrdClassfctnNmbrSchm.TrdClassfctnNmbrSchm  -- association [0..1]
LEFT OUTER JOIN E_Product AS _Extension ON Product = _Extension.Product  -- association [0..1]
;