R_MaintOrderPhaseControlTP

DDL: R_MAINTORDERPHASECONTROLTP Type: view_entity TRANSACTIONAL
23 Fields 1 Data Sources 2 Associations

Maintenance Order Phase Control TP

R_MaintOrderPhaseControlTP is a Transactional CDS View that provides data about "Maintenance Order Phase Control TP" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderPhaseControl) and exposes 23 fields with key fields MaintenanceOrder, MaintenancePhaseControl. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrderPhaseControl MaintOrderPhaseControl from

Associations (2)

CardinalityTargetAliasCondition
[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 Order 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 (23)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder I_MaintenanceOrderPhaseControl MaintenanceOrder Order
KEY MaintenancePhaseControl I_MaintenanceOrderPhaseControl MaintenancePhaseControl Phase Control
MaintenancePhaseControlName I_MaintenanceOrderPhaseControl MaintenancePhaseControlName Phase Control
MaintenancePhaseControlText I_MaintenanceOrderPhaseControl MaintenancePhaseControlText Description
MaintPhseCtrlIsSetAutomly I_MaintenanceOrderPhaseControl MaintPhseCtrlIsSetAutomly Set Automatically
MaintPhaseControlAuthorityCode I_MaintenanceOrderPhaseControl MaintPhaseControlAuthorityCode Authorization Key
MaintProcgPhseCtrlActvtnCode I_MaintenanceOrderPhaseControl MaintProcgPhseCtrlActvtnCode Phase Control Key
EAMProcessPhaseCode I_MaintenanceOrderPhaseControl EAMProcessPhaseCode Process Phase
EAMProcessSubPhaseCode I_MaintenanceOrderPhaseControl EAMProcessSubPhaseCode Process Subphase
MaintObjPhseCtrlStatusIsActive I_MaintenanceOrderPhaseControl MaintObjPhseCtrlStatusIsActive
StatusObject I_MaintenanceOrderPhaseControl StatusObject Status Object
MaintenanceUserStatusCode I_MaintenanceOrderPhaseControl MaintenanceUserStatusCode User status
EAMOverallStatusProfile I_MaintenanceOrderPhaseControl EAMOverallStatusProfile Ovrl Sts Profile
MaintUserStatusProfileCode I_MaintenanceOrderPhaseControl MaintUserStatusProfileCode Status Profile
MaintenanceOrderType I_MaintenanceOrderPhaseControl MaintenanceOrderType Order Type
MaintenancePlanningPlant I_MaintenanceOrderPhaseControl MaintenancePlanningPlant Planning Plant
EAMBlockerCodeEntityType EAMBlockerCodeEntityType Entity
_MaintenanceOrder _MaintenanceOrder
_MaintObjPhseCtrlCodeChgSet I_MaintenanceOrderPhaseControl _MaintObjPhseCtrlCodeChgSet
_MaintObjPhseCtrlCodeChgReset I_MaintenanceOrderPhaseControl _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_MaintOrderPhaseControlTP.
-- 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_MaintOrderPhaseControlTP AS
SELECT
  MaintOrderPhaseControl.MaintenanceOrder AS MaintenanceOrder,
  MaintOrderPhaseControl.MaintenancePhaseControl AS MaintenancePhaseControl,
  MaintOrderPhaseControl.MaintenancePhaseControlName AS MaintenancePhaseControlName,
  MaintOrderPhaseControl.MaintenancePhaseControlText AS MaintenancePhaseControlText,
  MaintOrderPhaseControl.MaintPhseCtrlIsSetAutomly AS MaintPhseCtrlIsSetAutomly,
  MaintOrderPhaseControl.MaintPhaseControlAuthorityCode AS MaintPhaseControlAuthorityCode,
  MaintOrderPhaseControl.MaintProcgPhseCtrlActvtnCode AS MaintProcgPhseCtrlActvtnCode,
  MaintOrderPhaseControl.EAMProcessPhaseCode AS EAMProcessPhaseCode,
  MaintOrderPhaseControl.EAMProcessSubPhaseCode AS EAMProcessSubPhaseCode,
  MaintOrderPhaseControl.MaintObjPhseCtrlStatusIsActive AS MaintObjPhseCtrlStatusIsActive,
  MaintOrderPhaseControl.StatusObject AS StatusObject,
  MaintOrderPhaseControl.MaintenanceUserStatusCode AS MaintenanceUserStatusCode,
  MaintOrderPhaseControl.EAMOverallStatusProfile AS EAMOverallStatusProfile,
  MaintOrderPhaseControl.MaintUserStatusProfileCode AS MaintUserStatusProfileCode,
  MaintOrderPhaseControl.MaintenanceOrderType AS MaintenanceOrderType,
  MaintOrderPhaseControl.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  EAMBlockerCodeEntityType,
  MaintOrderPhaseControl._MaintObjPhseCtrlCodeChgSet AS _MaintObjPhseCtrlCodeChgSet,
  MaintOrderPhaseControl._MaintObjPhseCtrlCodeChgReset AS _MaintObjPhseCtrlCodeChgReset
FROM I_MaintenanceOrderPhaseControl AS MaintOrderPhaseControl
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