P_PL_SAFTInvoiceHeaderBasic

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

CREATE VIEW P_PL_SAFTInvoiceHeaderBasic AS
SELECT
  Entry.CompanyCode AS CompanyCode,
  Entry.AccountingDocument AS AccountingDocument,
  Entry.FiscalYear AS FiscalYear,
  max(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,
  Customer,
  Supplier,
  DocumentItemText,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  BillingDocument,
  IsEUTriangularDeal,
  Item.VATRegistration AS VATRegistration,
  Item.TaxCountry AS TaxCountry,
  sum(MapTaxCode.AmountInTransactionCurrency) AS AmountInTransactionCurrency,
  sum(MapTaxCode.AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency
FROM I_JournalEntry AS Entry
INNER JOIN I_OperationalAcctgDocItem AS Item ON /* join condition not captured in parsed metadata */
INNER JOIN P_PL_SAFTMapTaxCode AS MapTaxCode 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]
;