I_PT_SAFTAccountingHeader

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_SAFTAccountingHeader.
-- 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: IPTSAFTACCHEADER

CREATE VIEW I_PT_SAFTAccountingHeader AS
SELECT
  b.PortugueseInvoiceNumber AS PortugueseInvoiceNumber,
  b.PortugueseInvoiceDate AS PortugueseInvoiceDate,
  c.CustomerInvoiceType AS DocumentType,
  case when a.ReverseDocument is not initial and a.IsReversed <> '' then _ReversalDocument.AccountingDocCreatedByUser else a.CreatedByUser end as LastChangedByUser AS CreatedByUserendasLastChangedByUser,
  b.PTDgtlSgntrSystemDateTimeText AS PTDgtlSgntrSystemDateTimeText,
  b.PortugueseDigitalSignature AS PortugueseDigitalSignature,
  b.PortugueseDgtlSgntrKeyVersion AS PortugueseDgtlSgntrKeyVersion,
  a.AccountingDocumentItem AS AccountingDocumentItem,
  a.AccountingDocument AS AccountingDocument,
  a.CompanyCode AS CompanyCode,
  a.FiscalYear AS FiscalYear,
  a.ReverseDocument AS ReverseDocument,
  a.IsReversed AS IsReversed,
  a.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  a.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  a.CreationTime AS CreationTime,
  a.ReversalReason AS ReversalReason,
  a.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  a.AccountingDocumentCategory AS AccountingDocumentCategory,
  a.FiscalPeriod AS FiscalPeriod,
  a.DocumentDate AS DocumentDate,
  a.PostingDate AS PostingDate,
  a.AccountingDocumentType AS AccountingDocumentType,
  a.CompanyCodeCurrency AS CompanyCodeCurrency,
  a.CreatedByUser AS CreatedByUser,
  case when a.TransactionCurrency <> a._CompanyCode.Currency and a.TransactionCurrency is not initial then a.ExchangeRate else 0 end as ExchangeRate AS ExchangeRateelse0endasExchangeRate,
  b.TotalGrossAmount AS TotalGrossAmount,
  (b.TotalGrossAmount - abs(coalesce(_TotalItems.TaxAmountInCoCodeCrcy,0))) AS TotalNetAmount,
  abs(coalesce(_TotalItems.TaxAmountInCoCodeCrcy,0)) AS TotalTaxAmount,
  a.Customer AS Customer,
  a.CustomerPaymentTerms AS CustomerPaymentTerms,
  a.CashDiscount1DueDate AS CashDiscount1DueDate,
  a.CashDiscount2DueDate AS CashDiscount2DueDate,
  cast( division(( a.CashDiscountBaseAmount * a.CashDiscount1Percent),100,2) as dmbtr ) AS CashDiscountAmtInCoCodeCrcy,
  a.IsOneTimeAccount AS IsOneTimeAccount,
  b.PT_SeriesDocumentNumber AS PT_SeriesDocumentNumber,
  b.PT_SeriesDocumentType AS PT_SeriesDocumentType,
  a._CompanyCode AS _CompanyCode
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 P_PT_SAFTTAXLAND AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomerPaymentTerms AS _Terms ON _Terms.CustomerPaymentTerms = a.CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_PT_SAFTAcctgDocCustAddrHist AS _CustHist ON _CustHist.AccountingDocument = a.AccountingDocument AND _CustHist.CompanyCode = a.CompanyCode AND _CustHist.FiscalYear = a.FiscalYear AND _CustHist.Customer = a.Customer  -- association [0..1]
LEFT OUTER JOIN I_PT_SAFTAcctgOneTimeCustomer AS _OneTimeAccount ON _OneTimeAccount.CompanyCode = a.CompanyCode AND _OneTimeAccount.AccountingDocument = a.AccountingDocument AND _OneTimeAccount.FiscalYear = a.FiscalYear  -- association [0..1]
;