I_PT_SAFTBillgSlsInvcHeader

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_SAFTBillgSlsInvcHeader.
-- 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_SAFTBillgSlsInvcHeader AS
SELECT
  Doc.CompanyCode AS CompanyCode,
  cast(Sig.PortugueseInvoiceNumber as abap.char(60)) AS PT_SAFTDocumentNumber,
  Sig.PortugueseInvoiceDate AS PortugueseInvoiceDate,
  GenSet.SourceLedger AS Ledger,
  Sig.PortugueseDigitalSignatureDate AS PortugueseDigitalSignatureDate,
  Sig.PortugueseDigitalSignatureTime AS PortugueseDigitalSignatureTime,
  Doc.BillingDocumentDate AS BillingDocumentDate,
  Doc.FiscalYear AS FiscalYear,
  Doc.AccountingDocument AS AccountingDocument,
  Doc.SDDocumentCategory AS SDDocumentCategory,
  cast(case when Doc.SDDocumentCategory = 'M' or Doc.SDDocumentCategory = 'N' or Doc.SDDocumentCategory = '5' then 'FT' when Doc.SDDocumentCategory = 'S' or Doc.SDDocumentCategory = 'O' or Doc.SDDocumentCategory = '6' or Doc.SDDocumentCategory = '4' then 'NC' when Doc.SDDocumentCategory = 'P' then 'ND' else 'FT' end as abap.char(3) ) as DocumentType AS char3asDocumentType,
  Doc.BillingDocument AS BillingDocument,
  Doc.BillingDocumentIsCancelled AS BillingDocumentIsCancelled,
  Sig.PT_SeriesDocumentType AS PT_SeriesDocumentType,
  Doc.ReversalReason AS ReversalReason,
  Doc._AccountingDocument.FiscalPeriod AS FiscalPeriod,
  cast('P' as abap.char(4) ) AS SourceBillingDocumentType,
  Sig.PortugueseDigitalSignature AS PortugueseDigitalSignature,
  Sig.PortugueseDgtlSgntrKeyVersion AS PortugueseDgtlSgntrKeyVersion,
  Sig.PTDgtlSgntrSystemDateTimeText AS PTDgtlSgntrSystemDateTimeText,
  Sig.PT_SeriesDocumentNumber AS PT_SeriesDocumentNumber,
  Doc.DocumentReferenceID AS DocumentReferenceID,
  Doc.CreatedByUser AS CreatedByUser,
  Sig.TotalGrossAmount AS TotalGrossAmount,
  Doc.TransactionCurrency AS TransactionCurrency,
  Doc.TotalNetAmount AS TotalNetAmount,
  Doc.TotalTaxAmount AS TotalTaxAmount,
  Doc.AccountingExchangeRate AS ExchangeRate,
  Doc.ExchangeRateDate AS ExchangeRateDate,
  Sig.CompanyCodeCurrency AS CompanyCodeCurrency,
  Doc.CancelledBillingDocument AS CancelledBillingDocument
FROM I_BillingDocument AS Doc
INNER JOIN I_PT_BillgDocDgtlSgntr AS Sig ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ReversalReason AS _RevReason ON ReversalReason = _RevReason.ReversalReason  -- association [0..1]
LEFT OUTER JOIN I_BillingDocument AS _CancelBillingDocument ON _CancelBillingDocument.CancelledBillingDocument = Doc.BillingDocument  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON _JournalEntry.ReferenceDocumentType = 'VBRK' AND _JournalEntry.OriginalReferenceDocument = Doc.BillingDocument AND ( _JournalEntry.Ledger = GenSet.SourceLedger OR _JournalEntry.Ledger is initial OR _JournalEntry.Ledger is null ) AND not( _JournalEntry.AccountingDocumentCategory = 'U' ) AND not( _JournalEntry.AccountingDocumentCategory = 'V' ) AND not( _JournalEntry.AccountingDocumentCategory = 'W' )  -- association [0..1]
;