I_PT_SAFTAccountingItem

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_PT_SAFTAccountingItem.
-- 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: IPTSAFTACCITE

CREATE VIEW I_PT_SAFTAccountingItem AS
SELECT
  b.PortugueseInvoiceNumber AS PortugueseInvoiceNumber,
  cast( a.AccountingDocumentItem as abap.char(12)) AS DocumentItemNumber,
  a.FiscalYear AS FiscalYear,
  b.PortugueseInvoiceDate AS PortugueseInvoiceDate,
  c.CustomerInvoiceType AS DocumentType,
  a.CompanyCode AS CompanyCode,
  a.Material AS Material,
  a.ChartOfAccounts AS ChartOfAccounts,
  a.GLAccount AS GLAccount,
  a.Quantity AS Quantity,
  a.DocumentItemText AS DocumentItemText,
  a.UnitOfMeasure AS UnitOfMeasure,
  a.BaseUnit AS BaseUnit,
  a.NetPriceAmount AS NetPriceAmount,
  a.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  a.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  a.AmountInCompanyCodeCurrency AS NetAmount,
  a.CompanyCodeCurrency AS CompanyCurrency,
  a.AccountingDocument AS AccountingDocument,
  a.TaxCode AS TaxCode,
  a._TaxItem.TaxRate AS TaxRate,
  coalesce(_ItemCustomer.CashDiscountAmtInCoCodeCrcy,0) AS CashDiscountAmtInCoCodeCrcy,
  a.InvoiceReference AS InvoiceReference,
  a.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  a._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  a._CompanyCodeCurrency AS _CompanyCodeCurrency,
  a._CompanyCode AS _CompanyCode
FROM I_SAFTAccountingItem AS a
INNER JOIN I_PT_AcctgDocDgtlSgntr AS b ON /* join condition not captured in parsed metadata */
INNER JOIN P_PT_SAFTFIlterInvType AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PT_SAFTDownPaymentFinance AS d ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PT_SAFTAccountingTax AS _TaxInfo ON PortugueseInvoiceNumber = _TaxInfo.PortugueseInvoiceNumber AND TaxCode = _TaxInfo.TaxCode  -- association [0..1]
LEFT OUTER JOIN I_PT_SAFTTaxNotConfigured AS _TaxNotConf ON _TaxNotConf.TaxCode = ''  -- association [0..*]
LEFT OUTER JOIN I_PT_SAFTAcctgDocMatlHist AS _MaterialHist ON AccountingDocument = _MaterialHist.AccountingDocument AND CompanyCode = _MaterialHist.CompanyCode AND FiscalYear = _MaterialHist.FiscalYear AND Material = _MaterialHist.Material  -- association [0..1]
;