P_CO_DIANInvoiceFinDocument

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_CO_DIANInvoiceFinDocument.
-- 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: PSRCOINVFINDOC
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW P_CO_DIANInvoiceFinDocument AS
SELECT
  JournalEntryItem.SourceLedger AS SourceLedger,
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.CompanyCode AS CompanyCode,
  cast( JournalEntryItem.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.PurchasingDocument AS PurchasingDocument,
  JournalEntryItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  JournalEntryItem._Ledger AS _Ledger,
  JournalEntryItem._CompanyCode AS _CompanyCode,
  JournalEntryItem._FiscalYear AS _FiscalYear,
  JournalEntryItem._JournalEntry AS _JournalEntry,
  JournalEntryItem._PurchasingDocument AS _PurchasingDocument,
  JournalEntryItem._PurchasingDocumentItem AS _PurchasingDocumentItem
FROM I_JournalEntryItem AS JournalEntryItem
INNER JOIN I_StRpJournalEntryLog AS ReportedItemsLog ON /* join condition not captured in parsed metadata */
;