I_CN_GoldenTaxDocumentItmBasic

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_GoldenTaxDocumentItmBasic.
-- 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_GoldenTaxDocumentItmBasic AS
SELECT
  gtd_item_uuid AS CN_GoldenTaxItemUUID,
  gtd_header_uuid AS CN_GoldenTaxUUID,
  gtd_nmbr AS CN_GoldenTaxDocument,
  gtd_item_nmbr AS CN_GoldenTaxDocumentItem,
  matl_nmbr AS Product,
  matl_group AS ProductGroup,
  matl_desc AS ProductName,
  matl_spec AS SizeOrDimensionText,
  unit_of_msr AS BilledQuantityUnit,
  blld_qty AS BilledQuantity,
  unit_of_msr_desc AS BilledQuantityUnitName,
  net_value AS NetAmount,
  tax_amount AS TaxAmount,
  disc_amount AS CN_TaxInvcDiscNetAmtInLoclCrcy,
  disc_tax_amount AS CN_TaxInvcDiscTaxAmtInLoclCrcy,
  deductions AS CN_GoldenTaxDdctdAmtInLoclCrcy,
  unit_price AS CN_GoldenTaxUnitPrice,
  matl_code AS CN_GoldenTaxClassfctnNumber,
  discount_flag AS CN_GoldenTaxPrfntlTreatment,
  zerotax_flag AS CN_GoldenTaxIdentification,
  discount_note AS CN_GoldenTxPrfntlTrtmtNote,
  entrcomm_code AS CN_GoldenTaxCommodityCode,
  matl_cat_name AS CN_GoldenTaxClassificationDesc,
  _GTDHeader.LocalCurrency AS LocalCurrency
FROM eiv_gtd_itm
LEFT OUTER JOIN I_CN_GoldenTaxDocumentBasic AS _GTDHeader ON CN_GoldenTaxUUID = _GTDHeader.CN_GoldenTaxUUID  -- association [1]
;