P_MaintWorkItemProcessingLog

DDL: P_MAINTWORKITEMPROCESSINGLOG SQL: PMTWKITMPRCLG Type: view COMPOSITE Package: IOCF
3 Fields 4 Data Sources

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.

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 Status Object
KEY EAMOverallObjectStatusLgEntry I_EAMObjectOverallStatusLg EAMOverallObjectStatusLgEntry Version
EAMOvrlStsObjIntrrptgLgEntry

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_MaintWorkItemProcessingLog.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PMTWKITMPRCLG

CREATE VIEW P_MaintWorkItemProcessingLog AS
SELECT
  I_EAMObjectOverallStatusLg.StatusObject AS StatusObject,
  I_EAMObjectOverallStatusLg.EAMOverallObjectStatusLgEntry AS EAMOverallObjectStatusLgEntry,
  min( _NextLogEntry.EAMOverallObjectStatusLgEntry ) AS EAMOvrlStsObjIntrrptgLgEntry
FROM I_EAMObjectOverallStatusLg
INNER JOIN I_EAMOverallStatusEvent AS _InProcessUsage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EAMObjectOverallStatusLg AS _NextLogEntry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EAMOverallStatusSequence AS _Sequence ON /* join condition not captured in parsed metadata */
;

Learn More