P_MaintWorkItemProcessingLog

DDL: P_MAINTWORKITEMPROCESSINGLOG SQL: PMTWKITMPRCLG Type: view COMPOSITE Package: IOCF

Maintenance Work Item Processing Log

P_MaintWorkItemProcessingLog is a Composite CDS View that provides data about "Maintenance Work Item Processing Log" in SAP S/4HANA. It reads from 4 data sources (I_EAMOverallStatusEvent, I_EAMObjectOverallStatusLg, I_EAMOverallStatusSequence, I_EAMObjectOverallStatusLg) and exposes 3 fields with key fields StatusObject, EAMOverallObjectStatusLgEntry. Part of development package IOCF.

4 data source(s) 3 fields

Data Sources (4)

SourceAliasJoin Type
I_EAMOverallStatusEvent _InProcessUsage inner
I_EAMObjectOverallStatusLg _NextLogEntry left_outer
I_EAMOverallStatusSequence _Sequence left_outer
I_EAMObjectOverallStatusLg I_EAMObjectOverallStatusLg from

Annotations (4)

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

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY StatusObject I_EAMObjectOverallStatusLg StatusObject
KEY EAMOverallObjectStatusLgEntry I_EAMObjectOverallStatusLg EAMOverallObjectStatusLgEntry
EAMOvrlStsObjIntrrptgLgEntry 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PMTWKITMPRCLG'
define view P_MaintWorkItemProcessingLog
  as select from    I_EAMObjectOverallStatusLg
    inner join      I_EAMOverallStatusEvent    as _InProcessUsage on  _InProcessUsage.EAMOverallStatusProfile      = I_EAMObjectOverallStatusLg.EAMOverallObjectStatusProfile
                                                                  and _InProcessUsage.EAMOverallStatus             = I_EAMObjectOverallStatusLg.EAMOverallObjectStatus
                                                                  and _InProcessUsage.EAMOverallStatusEvent        = 'F2023'
                                                                  and _InProcessUsage.EAMOvrlStsEventConfiguration = 'INPROC'
    left outer join I_EAMObjectOverallStatusLg as _NextLogEntry   on  _NextLogEntry.StatusObject                  =  I_EAMObjectOverallStatusLg.StatusObject
                                                                  and _NextLogEntry.EAMOverallObjectStatusProfile =  I_EAMObjectOverallStatusLg.EAMOverallObjectStatusProfile
                                                                  and _NextLogEntry.EAMOverallObjectStatusLgEntry >= I_EAMObjectOverallStatusLg.EAMOverallObjectStatusLgEntry
    left outer join I_EAMOverallStatusSequence as _Sequence       on  _Sequence.EAMOverallStatusProfile = I_EAMObjectOverallStatusLg.EAMOverallObjectStatusProfile
                                                                  and _Sequence.EAMOverallStatus        = I_EAMObjectOverallStatusLg.EAMOverallObjectStatus
                                                                  and _Sequence.EAMNextOverallStatus    = _NextLogEntry.EAMOverallObjectStatus
{
  key I_EAMObjectOverallStatusLg.StatusObject,
  key I_EAMObjectOverallStatusLg.EAMOverallObjectStatusLgEntry,
      min( _NextLogEntry.EAMOverallObjectStatusLgEntry ) as EAMOvrlStsObjIntrrptgLgEntry
}
where
          _NextLogEntry.StatusObject                                 is not null
  and(
    (
          _NextLogEntry._InProcessUsage.EAMOvrlStsEventConfiguration is null
      and _Sequence.EAMOverallStatusProfile                          is not null
    )
    or    I_EAMObjectOverallStatusLg.EAMOvrlObjStsOriglRsetDateTime  = 0
  ) 
group by
  I_EAMObjectOverallStatusLg.StatusObject,
  I_EAMObjectOverallStatusLg.EAMOverallObjectStatusLgEntry

Learn More