P_RU_StRpJournalEntryLogStat2

DDL: P_RU_STRPJOURNALENTRYLOGSTAT2 SQL: PRUSRJRNLENTRLS2 Type: view BASIC

P_RU_StRpJournalEntryLogStat2 is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_StRpRepRun) and exposes 9 fields.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_StRpRepRun run from

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PRUSRJRNLENTRLS2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
StatryRptgEntity I_StRpRepRun StatryRptgEntity
StatryRptCategory I_StRpRepRun StatryRptCategory
StatryRptRunID I_StRpRepRun StatryRptRunID
StatryRptRunStatus I_StRpRepRun StatryRptRunStatus
StatryRptRunCreatedByUser I_StRpRepRun StatryRptRunCreatedByUser
ts_delta run_log timestamp_delta
StatryRptCatPhase I_StRpRepRun StatryRptCatPhase
StatryRptDef I_StRpRepRun StatryRptDef
StatryRptRunUUID I_StRpRepRun StatryRptRunUUID 
@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PRUSRJRNLENTRLS2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_StRpJournalEntryLogStat2
  as select from           I_StRpRepRun       as run

    left outer to one join P_RU_StRpRepRunLog as run_log on run_log.StatryRptRunUUID = run.StatryRptRunUUID


{
  run.StatryRptgEntity,
  run.StatryRptCategory,
  run.StatryRptRunID,
  run.StatryRptRunStatus,
  run.StatryRptRunCreatedByUser,

  run_log.timestamp_delta as ts_delta,
  concat_with_space ( concat_with_space ( cast(run_log.timestamp_delta_h as char100),
                                          cast(run_log.timestamp_delta_m as char100),
                                          1),
                      cast(run_log.timestamp_delta_s as char100),
                      1)  as time_delta,

  run.StatryRptCatPhase,
  run.StatryRptDef,
  run.StatryRptRunUUID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STRPREPRUN",
"P_RU_STRPREPRUNLOG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More