I_PT_SAFTBillgAcctgHeader

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_SAFTBillgAcctgHeader.
-- 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_PT_SAFTBillgAcctgHeader AS
SELECT
  Doc.CompanyCode AS CompanyCode,
  cast(Sig.PortugueseInvoiceNumber as abap.char(60)) AS PT_SAFTDocumentNumber,
  Sig.PortugueseInvoiceDate AS PortugueseInvoiceDate,
  Doc.AccountingDocument AS AccountingDocument,
  Doc.FiscalYear AS FiscalYear,
  Doc.AccountingDocumentType AS AccountingDocumentType,
  Sig.PT_SeriesDocumentType AS PT_SeriesDocumentType,
  Sig.PortugueseDigitalSignature AS PortugueseDigitalSignature,
  Sig.PortugueseDgtlSgntrKeyVersion AS PortugueseDgtlSgntrKeyVersion,
  Sig.PT_SeriesDocumentNumber AS PT_SeriesDocumentNumber,
  Sig.PTDgtlSgntrSystemDateTimeText AS PTDgtlSgntrSystemDateTimeText,
  Doc.ReverseDocument AS ReverseDocument,
  Doc.IsReversed AS IsReversed,
  Doc.IsReversal AS IsReversal,
  Doc.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  Doc.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  Doc.CreationTime AS CreationTime,
  Doc.ReversalReason AS ReversalReason,
  Doc.AccountingDocumentCategory AS AccountingDocumentCategory,
  JournalEntryItem.FiscalPeriod AS FiscalPeriod,
  Doc.DocumentDate AS DocumentDate,
  Doc.PostingDate AS PostingDate,
  Doc.CompanyCodeCurrency AS CompanyCodeCurrency,
  Doc._OperationalAcctgDocItem[FinancialAccountType = 'D'].SpecialGLCode AS SpecialGLCode,
  Doc.AccountingDocCreatedByUser AS CreatedByUser
FROM I_PT_AcctgDocDgtlSgntr AS Sig
INNER JOIN I_JournalEntry AS Doc ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_SAFTGenericSettings AS GenSet ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntryItem AS JournalEntryItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ReversalReason AS _RevReason ON _RevReason.ReversalReason = Doc.ReversalReason  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _ReversalDocument ON _ReversalDocument.AccountingDocument = Doc.ReverseDocument AND _ReversalDocument.FiscalYear = Doc.ReverseDocumentFiscalYear AND _ReversalDocument.CompanyCode = Doc.CompanyCode  -- association [0..1]
;