P_JournalEntryPerformance

DDL: P_JOURNALENTRYPERFORMANCE SQL: PJEP Type: view COMPOSITE
4 Fields 2 Data Sources

FINCS Check Performance of Journal Entry

P_JournalEntryPerformance is a Composite CDS View that provides data about "FINCS Check Performance of Journal Entry" in SAP S/4HANA. It reads from 2 data sources (I_JournalEntryItem, I_FinancialPlanningEntryItem) and exposes 4 fields with key field dbname.

Data Sources (2)

SourceAliasJoin Type
I_JournalEntryItem acdoca from
I_FinancialPlanningEntryItem acdocp union_all

Parameters (2)

NameTypeDefault
P_CreationDateTimeRgFr timestamp
P_CreationDateTimeRgTo timestamp

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PJEP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label FINCS Check Performance of Journal Entry view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY dbname
count_docs
count_docs
last_tm_doc

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_JournalEntryPerformance.
-- 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: PJEP
-- Parameters: P_CreationDateTimeRgFr : timestamp, P_CreationDateTimeRgTo : timestamp

CREATE VIEW P_JournalEntryPerformance AS
SELECT
  cast('acdoca' as dbname) AS dbname,
  count( distinct acdoca.CreationDateTime ) AS count_docs,
  max( acdocp.FinPlngEntryItemCrtnDateTime ) AS last_tm_doc
FROM I_JournalEntryItem AS acdoca
-- UNION ALL with additional select branch(es): I_FinancialPlanningEntryItem
;

Learn More