P_JournalEntryPerformance

DDL: P_JOURNALENTRYPERFORMANCE SQL: PJEP Type: view COMPOSITE Package: FIN_CS_RELEASE_UNIVERSAL_JRNL

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. Part of development package FIN_CS_RELEASE_UNIVERSAL_JRNL.

2 data source(s) 4 fields

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 
@AbapCatalog.sqlViewName: 'PJEP'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'FINCS Check Performance of Journal Entry'
define view P_JournalEntryPerformance
  with parameters
    P_CreationDateTimeRgFr :timestamp,
    P_CreationDateTimeRgTo :timestamp
  as

  select from I_JournalEntryItem as acdoca
{

  key cast('acdoca' as dbname)                  as dbname,
      count( distinct acdoca.CreationDateTime ) as count_docs,
      max( acdoca.CreationDateTime )            as last_tm_doc

}
where
  acdoca.CreationDateTime between :P_CreationDateTimeRgFr and :P_CreationDateTimeRgTo

union all

select from I_FinancialPlanningEntryItem as acdocp
{

  key cast('acdocp' as dbname)                              as dbname,
      count( distinct acdocp.FinPlngEntryItemCrtnDateTime ) as count_docs,
      max( acdocp.FinPlngEntryItemCrtnDateTime )            as last_tm_doc

}
where
  acdocp.FinPlngEntryItemCrtnDateTime between :P_CreationDateTimeRgFr and :P_CreationDateTimeRgTo

Learn More