P_CnsldtnJrnlEntryTP

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_CnsldtnJrnlEntryTP.
-- 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: PJRNLENTRTP

CREATE VIEW P_CnsldtnJrnlEntryTP AS
SELECT
  rldnr AS ConsolidationLedger,
  rdimen AS ConsolidationDimension,
  ryear AS FiscalYear,
  docnr AS ConsolidationDocumentNumber,
  a.rvers AS ConsolidationVersion,
  a.poper AS FiscalPeriod,
  a.ritclg AS ConsolidationChartOfAccounts,
  a.plevl AS PostingLevel,
  a.docty AS ConsolidationDocumentType,
  a.sgtxt AS DocumentItemText,
  a.budat AS PostingDate,
  a.cpudt AS CreationDate,
  a.cputm AS CreationTime,
  a.usnam AS UserID,
  cast ( a.coicu as fincs_investeeconsunit preserving type ) AS InvesteeConsolidationUnit,
  cast ( a.uppcu as fincs_investorconsunit preserving type ) AS InvestorConsolidationUnit,
  a.coiac AS InvestmentActivityType,
  a.coinr AS InvestmentActivity,
  a.refdocnr AS RefConsolidationDocumentNumber,
  a.orndocnr AS ReversedDocument,
  a.rvsdocnr AS ReverseDocument,
  a.revyear AS ConsolidationDocReversalYear,
  a.docnr AS CnsldtnDocumentNumberForEdit,
  a.bunnr AS CnsldtnGroupJrnlEntryBundle
FROM acdocu AS a
INNER JOIN P_CnsldtnJrnlEntryMaxItem AS _MaxItem ON /* join condition not captured in parsed metadata */
;