P_MaintJobPckgOrdOpDataForGrpg

DDL: P_MAINTJOBPCKGORDOPDATAFORGRPG SQL: PMJPOPDTAFORGRPG Type: view COMPOSITE

P_MaintJobPckgOrdOpDataForGrpg is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MaintOrderOperAndSubOper) and exposes 64 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation. It has 1 association to related views.

1 data source(s) 64 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderOperAndSubOper I_MaintOrderOperAndSubOper from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaintOrderOperTechObj _MaintOrderOperTechObj $projection.MaintenanceOrder = _MaintOrderOperTechObj.MaintenanceOrder and $projection.MaintenanceOrderOperation = _MaintOrderOperTechObj.MaintenanceOrderOperation

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMJPOPDTAFORGRPG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
Metadata.allowExtensions false view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder
KEY MaintenanceOrderOperation MaintenanceOrderOperation
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation
MaintenanceOrderType _MaintenanceOrder MaintenanceOrderType
MaintenancePlannerGroup _MaintenanceOrder MaintenancePlannerGroup
MaintenancePlanningPlant _MaintenanceOrder MaintenancePlanningPlant
MaintenancePlant _MaintenanceOrder MaintenancePlant
PlantSection
ABCIndicator
Equipment _MaintenanceOrder Equipment
EquipmentCategory
FunctionalLocation
FunctionalLocationCategory
MainWorkCenterInternalID _MaintenanceOrder WorkCenterInternalID
MainWorkCenter _MaintenanceOrder MainWorkCenter
MainWorkCenterTypeCode _MaintenanceOrder WorkCenterTypeCode
MainWorkCenterPlant _MaintenanceOrder MainWorkCenterPlant
Assembly _MaintenanceOrder Assembly
WBSElementInternalID _MaintenanceOrder WBSElementInternalID
ProjectInternalID
MaintenanceRevision _MaintenanceOrder MaintenanceRevision
ResponsibleCostCenter _MaintenanceOrder ResponsibleCostCenter
ControllingArea _MaintenanceOrder ControllingArea
MaintOrdPersonResponsible _MaintenanceOrder MaintOrdPersonResponsible
MaintenanceActivityType _MaintenanceOrder MaintenanceActivityType
OrderSystemCondition _MaintenanceOrder OperationSystemCondition
MaintPriority _MaintenanceOrder MaintPriority
MaintPriorityType _MaintenanceOrder MaintPriorityType
MaintOrdBasicStartDate _MaintenanceOrder MaintOrdBasicStartDate
MaintOrdBasicEndDate _MaintenanceOrder MaintOrdBasicEndDate
LatestAcceptableCompletionDate _MaintenanceOrder LatestAcceptableCompletionDate
MaintenancePlan _MaintenanceOrder MaintenancePlan
MaintenanceItem _MaintenanceOrder MaintenanceItem
MaintOrdProcessPhaseCode _MaintenanceOrder MaintOrdProcessPhaseCode
MaintOrdProcessSubPhaseCode _MaintenanceOrder MaintOrdProcessSubPhaseCode
BusinessArea _MaintenanceOrder BusinessArea
OperationWorkCenterInternalID OperationWorkCenterInternalID
OperationControlKey OperationControlKey
CostCtrActivityType CostCtrActivityType
OperationPersonResponsible OperationPersonResponsible
OperationSystemCondition OperationSystemCondition
OperationPurgInfoRecdSearchTxt OperationPurgInfoRecdSearchTxt
MaintOperationExecStageCode MaintOperationExecStageCode
MaintOrdOpProcessPhaseCode MaintOrdOpProcessPhaseCode
MaintOrdOpProcessSubPhaseCode MaintOrdOpProcessSubPhaseCode
OpErlstSchedldExecStrtDte _OperationPlanningValues OpErlstSchedldExecStrtDte
OpErlstSchedldExecEndDte _OperationPlanningValues OpErlstSchedldExecEndDte
OpLtstSchedldExecStrtDte _OperationPlanningValues OpLtstSchedldExecStrtDte
OpLtstSchedldExecEndDte _OperationPlanningValues OpLtstSchedldExecEndDte
OpActualExecutionStartDate _OperationPlanningValues OpActualExecutionStartDate
OpActualExecutionEndDate _OperationPlanningValues OpActualExecutionEndDate
OperationEquipment Equipment
MaintJobPckgOpsEquipCategory _Equipment EquipmentCategory
OperationFunctionalLocation
MaintJobPckgOpsFuncLocCategory _FunctionalLocation FunctionalLocationCategory
OperationMaintenanceNotif
_EAMProcessPhase _EAMProcessPhase
_EAMProcessSubPhase _EAMProcessSubPhase
_MaintenanceOrder _MaintenanceOrder
_MaintOperationExecStageCode _MaintOperationExecStageCode
_OperationControlKey _OperationControlKey
_PersonResponsible _PersonResponsible
_PMContactEmployee _PMContactEmployee
_MaintOrderOperTechObj _MaintOrderOperTechObj 
@AbapCatalog.sqlViewName: 'PMJPOPDTAFORGRPG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK

@VDM.private: true
@VDM.viewType: #COMPOSITE

@Metadata.allowExtensions: false

define view P_MaintJobPckgOrdOpDataForGrpg
  //as select from I_MaintenanceOrderOperation

  as select from I_MaintOrderOperAndSubOper
  

  association [0..1] to I_MaintOrderOperTechObj as _MaintOrderOperTechObj on  $projection.MaintenanceOrder          = _MaintOrderOperTechObj.MaintenanceOrder
                                                                          and $projection.MaintenanceOrderOperation = _MaintOrderOperTechObj.MaintenanceOrderOperation
                                                                       

{

  key MaintenanceOrder,
  key MaintenanceOrderOperation,
  key MaintenanceOrderSubOperation,

      // Order Attributes

      _MaintenanceOrder.MaintenanceOrderType                                                                    as MaintenanceOrderType,
      _MaintenanceOrder.MaintenancePlannerGroup                                                                 as MaintenancePlannerGroup,
      _MaintenanceOrder.MaintenancePlanningPlant                                                                as MaintenancePlanningPlant,
      _MaintenanceOrder.MaintenancePlant                                                                        as MaintenancePlant,
      _MaintenanceOrder._LocationAccountAssignment.PlantSection                                                 as PlantSection,
      _MaintenanceOrder._LocationAccountAssignment.ABCIndicator                                                 as ABCIndicator,
      _MaintenanceOrder.Equipment                                                                               as Equipment,
      _MaintenanceOrder._Equipment.EquipmentCategory                                                            as EquipmentCategory,
      cast ( _MaintenanceOrder._LocationAccountAssignment.FunctionalLocation as vdm_eam_tplnr preserving type ) as FunctionalLocation,
      _MaintenanceOrder._LocationAccountAssignment._FunctionalLocation.FunctionalLocationCategory               as FunctionalLocationCategory,
      _MaintenanceOrder.WorkCenterInternalID                                                                    as MainWorkCenterInternalID,
      _MaintenanceOrder.MainWorkCenter                                                                          as MainWorkCenter,
      _MaintenanceOrder.WorkCenterTypeCode                                                                      as MainWorkCenterTypeCode,
      _MaintenanceOrder.MainWorkCenterPlant                                                                     as MainWorkCenterPlant,
      _MaintenanceOrder.Assembly                                                                                as Assembly,
      _MaintenanceOrder.WBSElementInternalID                                                                    as WBSElementInternalID,
      cast ( _MaintenanceOrder.ProjectInternalID as ps_s4_proj_pspnr preserving type )                          as ProjectInternalID,
      _MaintenanceOrder.MaintenanceRevision                                                                     as MaintenanceRevision,
      _MaintenanceOrder.ResponsibleCostCenter                                                                   as ResponsibleCostCenter,
      _MaintenanceOrder.ControllingArea                                                                         as ControllingArea,
      _MaintenanceOrder.MaintOrdPersonResponsible                                                               as MaintOrdPersonResponsible,
      _MaintenanceOrder.MaintenanceActivityType                                                                 as MaintenanceActivityType,
      _MaintenanceOrder.OperationSystemCondition                                                                as OrderSystemCondition,
      _MaintenanceOrder.MaintPriority                                                                           as MaintPriority,
      _MaintenanceOrder.MaintPriorityType                                                                       as MaintPriorityType,
      _MaintenanceOrder.MaintOrdBasicStartDate                                                                  as MaintOrdBasicStartDate,
      _MaintenanceOrder.MaintOrdBasicEndDate                                                                    as MaintOrdBasicEndDate,
      _MaintenanceOrder.LatestAcceptableCompletionDate                                                          as LatestAcceptableCompletionDate,
      _MaintenanceOrder.MaintenancePlan                                                                         as MaintenancePlan,
      _MaintenanceOrder.MaintenanceItem                                                                         as MaintenanceItem,
      _MaintenanceOrder.MaintOrdProcessPhaseCode                                                                as MaintOrdProcessPhaseCode,
      _MaintenanceOrder.MaintOrdProcessSubPhaseCode                                                             as MaintOrdProcessSubPhaseCode,
      _MaintenanceOrder.BusinessArea                                                                            as BusinessArea,

      // Order Operation Attributes

      OperationWorkCenterInternalID                                                                             as OperationWorkCenterInternalID,
      OperationControlKey                                                                                       as OperationControlKey,
      CostCtrActivityType                                                                                       as CostCtrActivityType,
      OperationPersonResponsible                                                                                as OperationPersonResponsible,
      OperationSystemCondition                                                                                  as OperationSystemCondition,
      OperationPurgInfoRecdSearchTxt                                                                            as OperationPurgInfoRecdSearchTxt,
      MaintOperationExecStageCode                                                                               as MaintOperationExecStageCode,
      MaintOrdOpProcessPhaseCode                                                                                as MaintOrdOpProcessPhaseCode,
      MaintOrdOpProcessSubPhaseCode                                                                             as MaintOrdOpProcessSubPhaseCode,
      _OperationPlanningValues.OpErlstSchedldExecStrtDte                                                        as OpErlstSchedldExecStrtDte,
      _OperationPlanningValues.OpErlstSchedldExecEndDte                                                         as OpErlstSchedldExecEndDte,
      _OperationPlanningValues.OpLtstSchedldExecStrtDte                                                         as OpLtstSchedldExecStrtDte,
      _OperationPlanningValues.OpLtstSchedldExecEndDte                                                          as OpLtstSchedldExecEndDte,
      _OperationPlanningValues.OpActualExecutionStartDate                                                       as OpActualExecutionStartDate,
      _OperationPlanningValues.OpActualExecutionEndDate                                                         as OpActualExecutionEndDate,
      Equipment                                                                                                 as OperationEquipment,
      _Equipment.EquipmentCategory                                                                              as MaintJobPckgOpsEquipCategory,
      cast( FunctionalLocation as vdm_eam_tplnr preserving type )                                               as OperationFunctionalLocation,
      _FunctionalLocation.FunctionalLocationCategory                                                            as MaintJobPckgOpsFuncLocCategory,
      _MaintOrderOperTechObj._MaintOrderOperObjectListLink._MaintenanceItemObject.MaintenanceNotification       as OperationMaintenanceNotif,

      /* Associations */
      _EAMProcessPhase,
      _EAMProcessSubPhase,
      _MaintenanceOrder,
     // _MaintenanceOrderSubOperation,

      _MaintOperationExecStageCode,
      _OperationControlKey,
      _PersonResponsible,
      _PMContactEmployee,
      _MaintOrderOperTechObj

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EQUIPMENT",
"I_FUNCTIONALLOCATION",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEITEMOBJECT",
"I_MAINTENANCEORDER",
"I_MAINTORDEROPERANDSUBOPER",
"I_MAINTORDEROPEROBJECTLISTLINK",
"I_MAINTORDEROPERPLANNINGVALUES",
"I_MAINTORDEROPERTECHOBJ"
],
"ASSOCIATED":
[
"I_EAMPROCESSPHASE",
"I_EAMPROCESSSUBPHASE",
"I_MAINTENANCEORDER",
"I_MAINTOPERATIONEXECSTAGECODE",
"I_MAINTORDEROPERTECHOBJ",
"I_OPERATIONCONTROLPROFILE",
"I_PMCONTACTCARDEMPLOYEE",
"I_WORKFORCEPERSON"
],
"BASE":
[
"I_MAINTORDEROPERANDSUBOPER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More