R_MaintOrderOpPhaseControlTP

DDL: R_MAINTORDEROPPHASECONTROLTP Type: view_entity TRANSACTIONAL
26 Fields 1 Data Sources 3 Associations

Maintenance Ord Op Phase Control TP

R_MaintOrderOpPhaseControlTP is a Transactional CDS View that provides data about "Maintenance Ord Op Phase Control TP" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderOpPhaseControl) and exposes 26 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintenancePhaseControl. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderOpPhaseControl MaintOrderOpPhaseControl from

Associations (3)

CardinalityTargetAliasCondition
[1..1] R_MaintenanceOrderTP _MaintenanceOrder $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
[0..*] I_EAMProcessPhaseText _EAMProcessPhaseText _EAMProcessPhaseText.EAMProcessPhaseCode = $projection.EAMProcessPhaseCode
[0..*] I_EAMProcessSubPhaseText _EAMProcessSubPhaseText _EAMProcessSubPhaseText.EAMProcessSubPhaseCode = $projection.EAMProcessSubPhaseCode

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Ord Op Phase Control TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder I_MaintOrderOpPhaseControl MaintenanceOrder Order
KEY MaintenanceOrderOperation I_MaintOrderOpPhaseControl MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation I_MaintOrderOpPhaseControl MaintenanceOrderSubOperation Suboperation
KEY MaintenancePhaseControl I_MaintOrderOpPhaseControl MaintenancePhaseControl Phase Control
MaintenancePhaseControlName I_MaintOrderOpPhaseControl MaintenancePhaseControlName Phase Control
MaintenancePhaseControlText I_MaintOrderOpPhaseControl MaintenancePhaseControlText Description
MaintPhseCtrlIsSetAutomly I_MaintOrderOpPhaseControl MaintPhseCtrlIsSetAutomly Set Automatically
MaintPhaseControlAuthorityCode I_MaintOrderOpPhaseControl MaintPhaseControlAuthorityCode Authorization Key
MaintProcgPhseCtrlActvtnCode I_MaintOrderOpPhaseControl MaintProcgPhseCtrlActvtnCode Phase Control Key
EAMProcessPhaseCode I_MaintOrderOpPhaseControl EAMProcessPhaseCode Process Phase
EAMProcessSubPhaseCode I_MaintOrderOpPhaseControl EAMProcessSubPhaseCode Process Subphase
MaintObjPhseCtrlStatusIsActive I_MaintOrderOpPhaseControl MaintObjPhseCtrlStatusIsActive
StatusObject I_MaintOrderOpPhaseControl StatusObject Status Object
MaintenanceUserStatusCode I_MaintOrderOpPhaseControl MaintenanceUserStatusCode User status
EAMOverallStatusProfile I_MaintOrderOpPhaseControl EAMOverallStatusProfile Ovrl Sts Profile
MaintUserStatusProfileCode I_MaintOrderOpPhaseControl MaintUserStatusProfileCode Status Profile
MaintenanceOrderType I_MaintOrderOpPhaseControl MaintenanceOrderType Order Type
MaintenancePlanningPlant I_MaintOrderOpPhaseControl MaintenancePlanningPlant Planning Plant
EAMBlockerCodeEntityType EAMBlockerCodeEntityType Entity
_MaintenanceOrderOperation _MaintenanceOrderOperation
_MaintenanceOrder _MaintenanceOrder
_MaintObjPhseCtrlCodeChgSet I_MaintOrderOpPhaseControl _MaintObjPhseCtrlCodeChgSet
_MaintObjPhseCtrlCodeChgReset I_MaintOrderOpPhaseControl _MaintObjPhseCtrlCodeChgReset
_MaintPhseCtrlActivationCode _MaintPhseCtrlActivationCode
_EAMProcessPhaseText _EAMProcessPhaseText
_EAMProcessSubPhaseText _EAMProcessSubPhaseText

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 R_MaintOrderOpPhaseControlTP.
-- 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 R_MaintOrderOpPhaseControlTP AS
SELECT
  MaintOrderOpPhaseControl.MaintenanceOrder AS MaintenanceOrder,
  MaintOrderOpPhaseControl.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  MaintOrderOpPhaseControl.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  MaintOrderOpPhaseControl.MaintenancePhaseControl AS MaintenancePhaseControl,
  MaintOrderOpPhaseControl.MaintenancePhaseControlName AS MaintenancePhaseControlName,
  MaintOrderOpPhaseControl.MaintenancePhaseControlText AS MaintenancePhaseControlText,
  MaintOrderOpPhaseControl.MaintPhseCtrlIsSetAutomly AS MaintPhseCtrlIsSetAutomly,
  MaintOrderOpPhaseControl.MaintPhaseControlAuthorityCode AS MaintPhaseControlAuthorityCode,
  MaintOrderOpPhaseControl.MaintProcgPhseCtrlActvtnCode AS MaintProcgPhseCtrlActvtnCode,
  MaintOrderOpPhaseControl.EAMProcessPhaseCode AS EAMProcessPhaseCode,
  MaintOrderOpPhaseControl.EAMProcessSubPhaseCode AS EAMProcessSubPhaseCode,
  MaintOrderOpPhaseControl.MaintObjPhseCtrlStatusIsActive AS MaintObjPhseCtrlStatusIsActive,
  MaintOrderOpPhaseControl.StatusObject AS StatusObject,
  MaintOrderOpPhaseControl.MaintenanceUserStatusCode AS MaintenanceUserStatusCode,
  MaintOrderOpPhaseControl.EAMOverallStatusProfile AS EAMOverallStatusProfile,
  MaintOrderOpPhaseControl.MaintUserStatusProfileCode AS MaintUserStatusProfileCode,
  MaintOrderOpPhaseControl.MaintenanceOrderType AS MaintenanceOrderType,
  MaintOrderOpPhaseControl.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  EAMBlockerCodeEntityType,
  MaintOrderOpPhaseControl._MaintObjPhseCtrlCodeChgSet AS _MaintObjPhseCtrlCodeChgSet,
  MaintOrderOpPhaseControl._MaintObjPhseCtrlCodeChgReset AS _MaintObjPhseCtrlCodeChgReset
FROM I_MaintOrderOpPhaseControl AS MaintOrderOpPhaseControl
LEFT OUTER JOIN R_MaintenanceOrderTP AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_EAMProcessPhaseText AS _EAMProcessPhaseText ON _EAMProcessPhaseText.EAMProcessPhaseCode = EAMProcessPhaseCode  -- association [0..*]
LEFT OUTER JOIN I_EAMProcessSubPhaseText AS _EAMProcessSubPhaseText ON _EAMProcessSubPhaseText.EAMProcessSubPhaseCode = EAMProcessSubPhaseCode  -- association [0..*]
;

Learn More