R_MaintOrderOpPhaseControlTP

DDL: R_MAINTORDEROPPHASECONTROLTP Type: view_entity TRANSACTIONAL

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
KEY MaintenanceOrderOperation I_MaintOrderOpPhaseControl MaintenanceOrderOperation
KEY MaintenanceOrderSubOperation I_MaintOrderOpPhaseControl MaintenanceOrderSubOperation
KEY MaintenancePhaseControl I_MaintOrderOpPhaseControl MaintenancePhaseControl
MaintenancePhaseControlName I_MaintOrderOpPhaseControl MaintenancePhaseControlName
MaintenancePhaseControlText I_MaintOrderOpPhaseControl MaintenancePhaseControlText
MaintPhseCtrlIsSetAutomly I_MaintOrderOpPhaseControl MaintPhseCtrlIsSetAutomly
MaintPhaseControlAuthorityCode I_MaintOrderOpPhaseControl MaintPhaseControlAuthorityCode
MaintProcgPhseCtrlActvtnCode I_MaintOrderOpPhaseControl MaintProcgPhseCtrlActvtnCode
EAMProcessPhaseCode I_MaintOrderOpPhaseControl EAMProcessPhaseCode
EAMProcessSubPhaseCode I_MaintOrderOpPhaseControl EAMProcessSubPhaseCode
MaintObjPhseCtrlStatusIsActive I_MaintOrderOpPhaseControl MaintObjPhseCtrlStatusIsActive
StatusObject I_MaintOrderOpPhaseControl StatusObject
MaintenanceUserStatusCode I_MaintOrderOpPhaseControl MaintenanceUserStatusCode
EAMOverallStatusProfile I_MaintOrderOpPhaseControl EAMOverallStatusProfile
MaintUserStatusProfileCode I_MaintOrderOpPhaseControl MaintUserStatusProfileCode
MaintenanceOrderType I_MaintOrderOpPhaseControl MaintenanceOrderType
MaintenancePlanningPlant I_MaintOrderOpPhaseControl MaintenancePlanningPlant
EAMBlockerCodeEntityType EAMBlockerCodeEntityType
_MaintenanceOrderOperation _MaintenanceOrderOperation
_MaintenanceOrder _MaintenanceOrder
_MaintObjPhseCtrlCodeChgSet I_MaintOrderOpPhaseControl _MaintObjPhseCtrlCodeChgSet
_MaintObjPhseCtrlCodeChgReset I_MaintOrderOpPhaseControl _MaintObjPhseCtrlCodeChgReset
_MaintPhseCtrlActivationCode _MaintPhseCtrlActivationCode
_EAMProcessPhaseText _EAMProcessPhaseText
_EAMProcessSubPhaseText _EAMProcessSubPhaseText
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Ord Op Phase Control TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}

define view entity R_MaintOrderOpPhaseControlTP
  as select from I_MaintOrderOpPhaseControl as MaintOrderOpPhaseControl
  association        to parent R_MaintenanceOrderOperationTP as _MaintenanceOrderOperation on (
     $projection.MaintenanceOrder                 = _MaintenanceOrderOperation.MaintenanceOrder
     and $projection.MaintenanceOrderOperation    = _MaintenanceOrderOperation.MaintenanceOrderOperation
     and $projection.MaintenanceOrderSubOperation = _MaintenanceOrderOperation.MaintenanceOrderSubOperation
   )
  association [1..1] to R_MaintenanceOrderTP                 as _MaintenanceOrder          on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder

  association [0..*] to I_EAMProcessPhaseText                as _EAMProcessPhaseText       on _EAMProcessPhaseText.EAMProcessPhaseCode = $projection.EAMProcessPhaseCode
  association [0..*] to I_EAMProcessSubPhaseText             as _EAMProcessSubPhaseText    on _EAMProcessSubPhaseText.EAMProcessSubPhaseCode = $projection.EAMProcessSubPhaseCode
{


  key MaintOrderOpPhaseControl.MaintenanceOrder,
  key MaintOrderOpPhaseControl.MaintenanceOrderOperation,
  key MaintOrderOpPhaseControl.MaintenanceOrderSubOperation,
  key MaintOrderOpPhaseControl.MaintenancePhaseControl,
      MaintOrderOpPhaseControl.MaintenancePhaseControlName,
      MaintOrderOpPhaseControl.MaintenancePhaseControlText,
      MaintOrderOpPhaseControl.MaintPhseCtrlIsSetAutomly,
      MaintOrderOpPhaseControl.MaintPhaseControlAuthorityCode,
      MaintOrderOpPhaseControl.MaintProcgPhseCtrlActvtnCode,
      MaintOrderOpPhaseControl.EAMProcessPhaseCode,
      MaintOrderOpPhaseControl.EAMProcessSubPhaseCode,
      @Semantics.booleanIndicator:true
      MaintOrderOpPhaseControl.MaintObjPhseCtrlStatusIsActive,

      MaintOrderOpPhaseControl.StatusObject,
      MaintOrderOpPhaseControl.MaintenanceUserStatusCode,
      MaintOrderOpPhaseControl.EAMOverallStatusProfile,
      MaintOrderOpPhaseControl.MaintUserStatusProfileCode,

      MaintOrderOpPhaseControl.MaintenanceOrderType,
      MaintOrderOpPhaseControl.MaintenancePlanningPlant,
      EAMBlockerCodeEntityType,

      //assoc"

      _MaintenanceOrderOperation,
      _MaintenanceOrder,
      MaintOrderOpPhaseControl._MaintObjPhseCtrlCodeChgSet,
      MaintOrderOpPhaseControl._MaintObjPhseCtrlCodeChgReset,
      _MaintPhseCtrlActivationCode,
      _EAMProcessPhaseText,
      _EAMProcessSubPhaseText
}
where
  StatusObject is not initial;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTORDEROPPHASECONTROL"
],
"ASSOCIATED":
[
"I_EAMPROCESSPHASETEXT",
"I_EAMPROCESSSUBPHASETEXT",
"I_MAINTORDEROPPHSECTRLCHGHIST",
"I_MAINTPHSECTRLACTIVATIONCODE",
"R_MAINTENANCEORDEROPERATIONTP",
"R_MAINTENANCEORDERTP"
],
"BASE":
[
"I_MAINTORDEROPPHASECONTROL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/