I_MaintOrdProcSuborddPhase

DDL: I_MAINTORDPROCSUBORDDPHASE Type: view_entity BASIC Package: IWO1
4 Fields 1 Data Sources

Maintenance Order Processing Sub Phase

I_MaintOrdProcSuborddPhase (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

MaintOrdProcessSubphase · Asset Management

I_MaintOrdProcSuborddPhase is a Basic CDS View that provides data about "Maintenance Order Processing Sub Phase" in SAP S/4HANA. It reads from 1 data source (eam_ostat_ph_sph) and exposes 4 fields with key fields MaintenanceProcessingPhase, MaintOrdProcessSubPhaseCode, EAMOverallStatusEntity. Part of development package IWO1.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAsset Management
Application ComponentPM-WOC-MO-2CL
CapabilitiesAssociation Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source for Search,Data Source in SQL Select,Data Provider for Value Help
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAsset Management for SAP S/4HANA Cloud Public Edition
Description This CDS view serves as a value help provider for maintenance order processing sub-phases. The values are as follows: <p>Process Sub-phase</p> <p>Sub-phase Description</p> <p>0005</p> <p>Submitted (Request)</p> <p>0010</p> <p>Accepted (Request)</p> <p>0015</p> <p>Rejected (Request)</p> <p>0020</p> <p>Action Required (Request)</p> <p>0025</p> <p>Resubmitted (Request)</p> <p>0030</p> <p>Order Assigned (Request)</p> <p>0035</p> <p>In Planning (Order)</p> <p>0040</p> <p>Submitted for Approval (Order)</p> <p>0045</p> <p>Approved (Order)</p> <p>0050</p> <p>Rejected (Order)</p> <p>0055</p> <p>In Preparation (Order)</p> <p>0060</p> <p>Ready to Schedule (Order)</p> <p>0065</p> <p>Ready for Execution (Order)</p> <p>0070</p> <p>Main Work Started (Order)</p> <p>0075</p> <p>Main Work Completed (Order)</p> <p>0080</p> <p>Work Done (Order)</p> <p>0085</p> <p>Technically Complete (Order)</p> <p>0090</p> <p>Completed (Request)</p> <p>0092</p> <p>Work Not Performed (Order)</p> <p>0095</p> <p>Closed (Order)</p> <p>0100</p> <p>Deletion Flag (Request)</p> <p>0105</p> <p>Deletion Flag (Order)</p> <p>0110</p> <p>In Planning</p> <p>0115</p> <p>In Preparation</p> <p>0120</p> <p>Ready to Schedule</p> <p>0125</p> <p>Ready for Execution</p> <p>0130</p> <p>Work in Execution</p> <p>0135</p> <p>Work Paused</p> <p>0140</p> <p>Work Finished</p> <p>0145</p> <p>Technically Complete</p> <p>0150</p> <p>Closed</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the available sub-phases within each maintenance order processing phase for tracking detailed work progress?</p></li> <li><p>Which processing sub-phases are applicable for specific maintenance order entity types in the system?</p></li> <li><p>What is the hierarchical relationship between maintenance processing phases and their corresponding sub-phases?</p></li> <li><p>Which sub-phases are available for selection when updating the status of maintenance orders beyond the initial processing stages?</p></li> <li><p>What are the valid sub-phase codes and their descriptions that can be assigned to maintenance orders during different stages of work execution?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
eam_ostat_ph_sph eam_ostat_ph_sph from

Annotations (14)

NameValueLevelField
EndUserText.label Maintenance Order Processing Sub Phase view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
Consumption.ranked true view
ObjectModel.dataCategory #VALUE_HELP view
Analytics.technicalName IMAINTORDPROCSUBORDDPHASE view
ObjectModel.representativeKey MaintenanceProcessingPhase view
ObjectModel.resultSet.sizeCategory #XS view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceProcessingPhase Maintenance Processing Phase
KEY MaintOrdProcessSubPhaseCode eamovrlprocsubphase Process Subphase
KEY EAMOverallStatusEntity entity_type Entity Type
_MaintenanceProcessingPhase _MaintenanceProcessingPhase

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 I_MaintOrdProcSuborddPhase.
-- 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.

CREATE VIEW I_MaintOrdProcSuborddPhase AS
SELECT
  cast( eamovrlprocphase as pm_phase ) AS MaintenanceProcessingPhase,
  eamovrlprocsubphase AS MaintOrdProcessSubPhaseCode,
  entity_type AS EAMOverallStatusEntity
FROM eam_ostat_ph_sph
;

Learn More