I_CN_GoldenTaxDocumentMapping

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_CN_GoldenTaxDocumentMapping.
-- 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.

CREATE VIEW I_CN_GoldenTaxDocumentMapping AS
SELECT
  eiv_gtd_map.map_uuid AS CN_GoldenTaxMapUUID,
  eiv_gtd_map.gtd_nmbr AS CN_GoldenTaxDocument,
  eiv_gtd_map.gtd_item_nmbr AS CN_GoldenTaxDocumentItem,
  eiv_gtd_map.combine_id AS CN_GoldenTaxCombinationID,
  eiv_gtd_map.doc_type AS CN_GoldenTaxDataSourceType,
  cast(eiv_gtd_map.doc_key1 as eiv_doc_key1) AS CN_GoldenTaxSourceDocument1,
  cast(eiv_gtd_map.doc_key2 as eiv_doc_key2) AS CN_GoldenTaxSourceDocument2,
  cast(eiv_gtd_map.doc_key3 as eiv_doc_key3) AS CN_GoldenTaxSourceDocument3,
  cast(eiv_gtd_map.doc_item_nmbr as cds_source_document_item) AS SourceDocumentItem,
  eiv_gtd_map.company_code AS CompanyCode,
  eiv_gtd_map.sales_org AS SalesOrganization,
  eiv_gtd_map.distr_chnl AS DistributionChannel,
  eiv_gtd_map.division AS Division,
  eiv_gtd_map.cntax_entity_id AS CN_TaxEntityID,
  eiv_gtd_map.create_user AS CreatedByUser,
  eiv_gtd_map.create_time AS CreationDateTime,
  eiv_gtd_map.change_user AS LastChangedByUser,
  eiv_gtd_map.change_time AS ChangedDateTime
FROM eiv_gtd_map
LEFT OUTER JOIN I_CN_GoldenTaxDocumentBasic AS _GTDHeader ON CN_GoldenTaxDocument = _GTDHeader.CN_GoldenTaxDocument  -- association [1]
LEFT OUTER JOIN I_CN_GoldenTaxDocumentItmBasic AS _GTDItem ON CN_GoldenTaxDocument = _GTDItem.CN_GoldenTaxDocument AND CN_GoldenTaxDocumentItem = _GTDItem.CN_GoldenTaxDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;