P_PL_SAFTInvcHeaderBscVersion2

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_PL_SAFTInvcHeaderBscVersion2.
-- 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.
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_PL_SAFTInvcHeaderBscVersion2 AS
SELECT
  Entry.CompanyCode AS CompanyCode,
  Entry.AccountingDocument AS AccountingDocument,
  Entry.FiscalYear AS FiscalYear,
  max(Item.AccountingDocumentItem) AS AccountingDocumentItem,
  Entry.BusinessTransactionType AS BusinessTransactionType,
  Entry.TaxReportingDate AS TaxReportingDate,
  Entry.PostingDate AS PostingDate,
  Entry.DocumentDate AS DocumentDate,
  Entry.ReferenceDocumentType AS ReferenceDocumentType,
  Entry.TransactionCurrency AS TransactionCurrency,
  Entry.CompanyCodeCurrency AS CompanyCodeCurrency,
  Entry.DocumentReferenceID AS DocumentReferenceID,
  Entry.AlternativeReferenceDocument AS AlternativeReferenceDocument,
  Item.Customer AS Customer,
  Item.Supplier AS Supplier,
  Item.DocumentItemText AS DocumentItemText,
  Item.InvoiceReference AS InvoiceReference,
  Item.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  Item.BillingDocument AS BillingDocument,
  Item.IsEUTriangularDeal AS IsEUTriangularDeal,
  Item.VATRegistration AS VATRegistration,
  Item.TaxCountry AS TaxCountry,
  sum (Item.AmountInTransactionCurrency) * -1 AS AmountInTransactionCurrency,
  sum(Item.AmountInCompanyCodeCurrency) * -1 AS AmountInCompanyCodeCurrency,
  Entry._CompanyCode AS _CompanyCode,
  Item._Customer AS _Customer,
  Item._Supplier AS _Supplier
FROM I_JournalEntry AS Entry
INNER JOIN I_OperationalAcctgDocItem AS Item ON /* join condition not captured in parsed metadata */
INNER JOIN P_PL_SAFTINVOICETAXD AS Tax ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JournalEntryItemOneTimeData AS _OneTimeAccountBP ON CompanyCode = _OneTimeAccountBP.CompanyCode AND FiscalYear = _OneTimeAccountBP.FiscalYear AND AccountingDocument = _OneTimeAccountBP.AccountingDocument AND AccountingDocumentItem = _OneTimeAccountBP.AccountingDocumentItem  -- association [0..1]
;