P_PT_SAFTDownPaymentProduct

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_PT_SAFTDownPaymentProduct.
-- 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: PPTSAFTDWPPRD

CREATE VIEW P_PT_SAFTDownPaymentProduct AS
SELECT
  accprod.AccountingDocument AS AccountingDocument,
  accprod.FiscalYear AS FiscalYear,
  accprod.CompanyCode AS CompanyCode,
  accprod.Product AS Product,
  accprod.GLAccount AS GLAccount,
  b.PortugueseInvoiceDate AS PortugueseInvoiceDate,
  accprod.ProductType AS ProductType,
  accprod.ChartOfAccounts AS ChartOfAccounts,
  materialHist.Material AS Material,
  case when accprod.Product is not initial then materialHist.PortugueseMaterialWithVersion else accprod.GLAccount end as ProductID AS GLAccountendasProductID,
  materialHist._Product AS _Product
INNER JOIN I_PT_AcctgDocDgtlSgntr AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PT_SAFTAcctgDocMatlHist AS materialHist ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PT_SAFTProductType AS _ProductType ON accprod.CompanyCode = _ProductType.CompanyCode AND accprod.ProductType = _ProductType.MaterialType  -- association [1..1]
LEFT OUTER JOIN I_PT_SAFTDangerousGoodsCode AS _DangerousGoodsIdnNumber ON Product = _DangerousGoodsIdnNumber.ProductID  -- association [0..1]
;