P_MaintJobPckgOrdOpDataForGrpg

DDL: P_MAINTJOBPCKGORDOPDATAFORGRPG SQL: PMJPOPDTAFORGRPG Type: view COMPOSITE
65 Fields 1 Data Sources 1 Associations

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

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 (65)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder Order
KEY MaintenanceOrderOperation MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation Suboperation
MaintenanceOrderType _MaintenanceOrder MaintenanceOrderType Order Type
MaintenancePlannerGroup _MaintenanceOrder MaintenancePlannerGroup Planner Group
MaintenancePlanningPlant _MaintenanceOrder MaintenancePlanningPlant Planning Plant
MaintenancePlant _MaintenanceOrder MaintenancePlant Plant
PlantSection
ABCIndicator
Equipment _MaintenanceOrder Equipment Equipment check
EquipmentCategory
FunctionalLocation
FunctionalLocationCategory
MainWorkCenterInternalID _MaintenanceOrder WorkCenterInternalID Work Center
MainWorkCenter _MaintenanceOrder MainWorkCenter Work Center
MainWorkCenterTypeCode _MaintenanceOrder WorkCenterTypeCode Object Type
MainWorkCenterPlant _MaintenanceOrder MainWorkCenterPlant Plnt WorkCenter
Assembly _MaintenanceOrder Assembly Pegged Reqmt
WBSElementInternalID _MaintenanceOrder WBSElementInternalID WBS Internal ID
ProjectInternalID
MaintenanceRevision _MaintenanceOrder MaintenanceRevision Revision
ResponsibleCostCenter _MaintenanceOrder ResponsibleCostCenter Responsible Cost Center
ControllingArea _MaintenanceOrder ControllingArea Controlling Area
MaintOrdPersonResponsible _MaintenanceOrder MaintOrdPersonResponsible Person Resp. ID
MaintenanceActivityType _MaintenanceOrder MaintenanceActivityType MaintActivType
OrderSystemCondition _MaintenanceOrder OperationSystemCondition SystemCondition
MaintPriority _MaintenanceOrder MaintPriority Priority
MaintPriorityType _MaintenanceOrder MaintPriorityType PriorityType
MaintOrdBasicStartDate _MaintenanceOrder MaintOrdBasicStartDate Bas. Start Date
MaintOrdBasicEndDate _MaintenanceOrder MaintOrdBasicEndDate Basic fin. date
LatestAcceptableCompletionDate _MaintenanceOrder LatestAcceptableCompletionDate Final Due Date
MaintenancePlan _MaintenanceOrder MaintenancePlan MaintenancePlan
MaintenanceItem _MaintenanceOrder MaintenanceItem MaintItem
MaintOrdProcessPhaseCode _MaintenanceOrder MaintOrdProcessPhaseCode Process Phase
MaintOrdProcessSubPhaseCode _MaintenanceOrder MaintOrdProcessSubPhaseCode Process Subphase
BusinessArea _MaintenanceOrder BusinessArea Business Area
OperationWorkCenterInternalID OperationWorkCenterInternalID Object ID
OperationControlKey OperationControlKey Control Key
CostCtrActivityType CostCtrActivityType Activity Type
OperationPersonResponsible OperationPersonResponsible Personnel no.
OperationSystemCondition OperationSystemCondition SystemCondition
OperationPurgInfoRecdSearchTxt OperationPurgInfoRecdSearchTxt Sort Term
MaintOperationExecStageCode MaintOperationExecStageCode Execution Stage
MaintOrdOpProcessPhaseCode MaintOrdOpProcessPhaseCode Process Phase
MaintOrdOpProcessSubPhaseCode MaintOrdOpProcessSubPhaseCode Process Subphase
OpErlstSchedldExecStrtDte _OperationPlanningValues OpErlstSchedldExecStrtDte Earl.start date
OpErlstSchedldExecEndDte _OperationPlanningValues OpErlstSchedldExecEndDte EarliestEndDate
OpLtstSchedldExecStrtDte _OperationPlanningValues OpLtstSchedldExecStrtDte Latest start
OpLtstSchedldExecEndDte _OperationPlanningValues OpLtstSchedldExecEndDte Lat.finish date
OpActualExecutionStartDate _OperationPlanningValues OpActualExecutionStartDate Execution Start Date
OpActualExecutionEndDate _OperationPlanningValues OpActualExecutionEndDate Execution End Date
OperationEquipment Equipment Equipment check
MaintJobPckgOpsEquipCategory _Equipment EquipmentCategory EquipCategory
OperationFunctionalLocation Object ID
MaintJobPckgOpsFuncLocCategory _FunctionalLocation FunctionalLocationCategory FunctLocCat.
OperationMaintenanceNotif
MaintOperationalChecklistType _MaintOrderOperTechObj MaintOperationalChecklistType Checklist Type
_EAMProcessPhase _EAMProcessPhase
_EAMProcessSubPhase _EAMProcessSubPhase
_MaintenanceOrder _MaintenanceOrder
_MaintOperationExecStageCode _MaintOperationExecStageCode
_OperationControlKey _OperationControlKey
_PersonResponsible _PersonResponsible
_PMContactEmployee _PMContactEmployee
_MaintOrderOperTechObj _MaintOrderOperTechObj

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 P_MaintJobPckgOrdOpDataForGrpg.
-- 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.
-- SQL view name: PMJPOPDTAFORGRPG

CREATE VIEW P_MaintJobPckgOrdOpDataForGrpg AS
SELECT
  MaintenanceOrder,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  _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,
  OperationWorkCenterInternalID,
  OperationControlKey,
  CostCtrActivityType,
  OperationPersonResponsible,
  OperationSystemCondition,
  OperationPurgInfoRecdSearchTxt,
  MaintOperationExecStageCode,
  MaintOrdOpProcessPhaseCode,
  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,
  _MaintOrderOperTechObj.MaintOperationalChecklistType AS MaintOperationalChecklistType
FROM I_MaintOrderOperAndSubOper
LEFT OUTER JOIN I_MaintOrderOperTechObj AS _MaintOrderOperTechObj ON MaintenanceOrder = _MaintOrderOperTechObj.MaintenanceOrder AND MaintenanceOrderOperation = _MaintOrderOperTechObj.MaintenanceOrderOperation  -- association [0..1]
;

Learn More