P_RU_StRpJournalEntryLogStat2

DDL: P_RU_STRPJOURNALENTRYLOGSTAT2 SQL: PRUSRJRNLENTRLS2 Type: view BASIC Package: GLO_FIN_IS_VAT_RU

ACR Reported Tax Items Log Table Statistic-2

P_RU_StRpJournalEntryLogStat2 is a Basic CDS View that provides data about "ACR Reported Tax Items Log Table Statistic-2" in SAP S/4HANA. It reads from 1 data source (I_StRpRepRun) and exposes 9 fields. Part of development package GLO_FIN_IS_VAT_RU.

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
}

Learn More