P_CN_GoldenTaxSettlmtDocItem

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 P_CN_GoldenTaxSettlmtDocItem.
-- 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 P_CN_GoldenTaxSettlmtDocItem AS
SELECT
  SettlmtDoc,
  SettlmtDocItem,
  _Header.CN_GoldenTaxDocument AS CN_GoldenTaxDocument,
  _Header.CN_GoldenTaxCombinationID AS CN_GoldenTaxCombinationID,
  Product,
  _ProductText[1:Language=$session.system_language].ProductName AS ProductName,
  _Product.SizeOrDimensionText AS SizeOrDimensionText,
  ProductGroup,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  _Header.ExchangeRateDate AS ExchangeRateDate,
  _Header.LocalCurrency AS LocalCurrency,
  CustomerItemNetAmount,
  CustomerTaxCode,
  CustomerItemTaxAmount,
  SettlmtDocCurrency,
  NetPriceQuantity,
  cast('' as idgt_entrcomm_code ) AS CN_GoldenTaxCommodityCode,
  _Header.ExchangeRateType AS ExchangeRateType,
  _GTPersonalSetting.CN_GoldenTaxConditionType AS CN_GoldenTaxConditionType
FROM I_SettlmtDocItem
LEFT OUTER JOIN P_CN_GoldenTaxSettlmtDocBasic AS _Header ON SettlmtDoc = _Header.SettlmtDoc  -- association [0..1]
LEFT OUTER JOIN I_CN_GoldenTaxPersonalSetting AS _GTPersonalSetting ON _GTPersonalSetting.UserID = $session.user  -- association [0..1]
LEFT OUTER JOIN I_CN_GoldenTaxMatlClsfctnNmbr AS _MatClfnNmbrByGroupMatNmbr ON Product = _MatClfnNmbrByGroupMatNmbr.Product AND ProductGroup = _MatClfnNmbrByGroupMatNmbr.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_CN_GoldenTaxMatlClsfctnNmbr AS _MatClfnNmbrByGroup ON ProductGroup = _MatClfnNmbrByGroup.ProductGroup AND _MatClfnNmbrByGroup.Product is initial  -- association [0..1]
LEFT OUTER JOIN I_CN_GoldenTaxMatlClsfctnNmbr AS _MatClfnNmbrByMatNmbr ON Product = _MatClfnNmbrByMatNmbr.Product AND _MatClfnNmbrByMatNmbr.ProductGroup is initial  -- association [0..1]
;