P_SG_STRPRUNLOG2

DDL: P_SG_STRPRUNLOG2 Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_SG

Get Report Run Log

P_SG_STRPRUNLOG2 is a Composite CDS View that provides data about "Get Report Run Log" in SAP S/4HANA. It reads from 2 data sources (I_StRpRepRun, I_StRpTaskDetails) and exposes 6 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID. Part of development package GLO_FIN_IS_VAT_SG.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_StRpRepRun _StRpRepRun from
I_StRpTaskDetails _StRpTaskDetails inner

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity I_StRpTaskDetails StatryRptgEntity
KEY StatryRptCategory I_StRpTaskDetails StatryRptCategory
KEY StatryRptRunID
StatryRptRunStatus I_StRpRepRun StatryRptRunStatus
ReportingYear I_StRpTaskDetails ReportingYear
StatryRptTaskPeriod I_StRpTaskDetails StatryRptTaskPeriod 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: {private: true, viewType: #COMPOSITE}
define view entity P_SG_STRPRUNLOG2
  as select from I_StRpRepRun          as _StRpRepRun      
    inner join   I_StRpTaskDetails     as _StRpTaskDetails on(
      _StRpRepRun.StatryRptTaskUUID = _StRpTaskDetails.StatryRptTaskUUID
    )

{
  key _StRpTaskDetails.StatryRptgEntity   as StatryRptgEntity,
  key _StRpTaskDetails.StatryRptCategory  as StatryRptCategory,
  key max(_StRpRepRun.StatryRptRunID)     as StatryRptRunID,
      _StRpRepRun.StatryRptRunStatus,
      _StRpTaskDetails.ReportingYear,
      _StRpTaskDetails.StatryRptTaskPeriod
}
where _StRpRepRun.StatryRptRunStatus = 'SOK'
group by _StRpTaskDetails.StatryRptgEntity , _StRpTaskDetails.StatryRptCategory, _StRpRepRun.StatryRptRunStatus, _StRpTaskDetails.ReportingYear, _StRpTaskDetails.StatryRptTaskPeriod

Learn More