P_CO_DIANJrnlEntrWthInvcFinDoc

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

CREATE VIEW P_CO_DIANJrnlEntrWthInvcFinDoc AS
SELECT
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.CompanyCode AS CompanyCode,
  cast( JournalEntryItem.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  DIAN_GLAccount.CO_DIANReportFormat AS CO_DIANReportFormat,
  DIAN_GLAccount.CO_DIANReportItemType AS CO_DIANReportItemType,
  InvoiceFinDocument.AccountingDocument AS IncgInvoiceAccountingDocument,
  JournalEntryItem._Ledger AS _Ledger,
  JournalEntryItem._CompanyCode AS _CompanyCode,
  JournalEntryItem._FiscalYear AS _FiscalYear,
  JournalEntryItem._JournalEntry AS _JournalEntry
INNER JOIN I_CO_DIANGeneralLedgerAccount AS DIAN_GLAccount ON /* join condition not captured in parsed metadata */
INNER JOIN I_CO_DIANItemType AS DIANItemType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JournalEntryItem AS InvoiceFinDocument ON /* join condition not captured in parsed metadata */
;