I_TrdCmplncDocItemBasic

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_TrdCmplncDocItemBasic.
-- 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: ITRDCMPDOCITMB

CREATE VIEW I_TrdCmplncDocItemBasic AS
SELECT
  db_key AS TrdCmplncDocItemUUID,
  docca AS ReferenceDocumentCategory,
  docno AS ReferenceDocument,
  itmno AS ReferenceDocumentItem,
  docca AS TrdCmplncDocCategory,
  docno AS TradeComplianceDocument,
  itmno AS TrdCmplncDocItem,
  tcckd AS TrdCmplncCheckDrctn,
  docco AS CompanyCode,
  werks AS Plant,
  cast ( matnr as productnumber preserving type ) AS Product,
  tcpco AS Country,
  tcpno AS BusinessPartner,
  cldcd AS ReferenceDocumentCreationDate,
  opind AS TrdCmplncDocIsOutbound,
  ipind AS TrdCmplncDocIsInbound
FROM /sapsll/cldit
LEFT OUTER JOIN I_CountryText AS _CountryText ON _CountryText.Country = Country AND _CountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IntlTrdDocumentCategoryText AS _IntlTrdDocumentCategoryText ON ReferenceDocumentCategory = _IntlTrdDocumentCategoryText.ReferenceDocumentCategory AND _IntlTrdDocumentCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TrdCmplncDocCategoryText AS _TrdCmplncDocCategoryText ON TrdCmplncDocCategory = _TrdCmplncDocCategoryText.TrdCmplncDocCategory  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncCheckDrctnTxt AS _TrdCmplncCheckDrctnTxt ON TrdCmplncCheckDrctn = _TrdCmplncCheckDrctnTxt.TrdCmplncCheckDrctn  -- association [0..*]
;