P_IMPORTJOURNALENTRIES

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_IMPORTJOURNALENTRIES.
-- 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: PIMPORTJE

CREATE VIEW P_IMPORTJOURNALENTRIES AS
SELECT
  _Worklist.createdate AS createdate,
  _Worklist.status AS status,
  _Status[1: Language = $session.system_language].statust AS statust,
  _Worklist.belnr AS ConsolidationDocumentNumber,
  _Worklist.cnsldtnledger AS ConsolidationLedger,
  _Worklist.gjahr AS fiscalyear,
  _Worklist.draft_key AS draft_key,
  _Worklist.temporaryid AS temporaryid,
  _Worklist.entryid AS entryid,
  _Worklist.check_result AS check_result,
  _Worklist.je_bv_result_uuid AS CnsldtnJrnlEntrValdtnRsltUUID,
  _Entry.consolidationdocumentnumber AS ConsolidationDocumentNumber1,
  _Entry.consolidationledger AS ConsolidationLedger1,
  _Entry.fiscalperiod AS fiscalperiod,
  _Entry.postinglevel AS postinglevel,
  _Entry.postingdate AS postingdate,
  _Entry.creationdate AS creationdate,
  _Entry.creationtime AS creationtime,
  _Entry.userid AS userid,
  _Entry.FiscalYear AS FiscalYearForEdit,
  _Entry.ConsolidationDimension AS ConsolidationDimension,
  _Entry.ConsolidationVersion AS ConsolidationVersion,
  _Entry.ConsolidationUnit AS ConsolidationUnit,
  _Entry.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  _Entry.ConsolidationGroup AS ConsolidationGroup,
  _Entry.ConsolidationDocumentType AS ConsolidationDocumentType,
  _Entry.ConsolidationUnit1 AS ConsolidationUnit1,
  _Entry.ConsolidationUnit2 AS ConsolidationUnit2,
  _Entry.InvesteeConsolidationUnit AS InvesteeConsolidationUnit,
  _Entry.InvestmentActivityType AS InvestmentActivityType,
  _Entry.InvestmentActivity AS InvestmentActivity,
  _Entry.RefConsolidationDocumentNumber AS RefConsolidationDocumentNumber,
  _Entry.CnsldtnGroupJrnlEntryBundle AS CnsldtnGroupJrnlEntryBundle
FROM fincs_ije_wl AS _Worklist
INNER JOIN fincsjrnlentrh_d AS _Entry ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnJrnlEntryHeader AS _Entry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CNSLDTN_STATUS AS _Status ON _Worklist.status = _Status.status  -- association [0..1]
-- UNION with additional select branch(es): fincs_ije_wl
;