Which tables does P_MaintJobPckgOperations read from?

P_MaintJobPckgOperations reads data from: I_MaintOrderOperAndSubOper.

What VDM layer is P_MaintJobPckgOperations?

P_MaintJobPckgOperations is classified as a Composite view that combines data from multiple basic views.

P_MaintJobPckgOperations

Q: What is P_MaintJobPckgOperations in SAP S/4HANA?

P_MaintJobPckgOperations is a composite CDS view in SAP S/4HANA. It contains 78 fields.

DDL: P_MAINTJOBPCKGOPERATIONS SQL: PMJOBPCKGOPS Type: view COMPOSITE

78 Fields 1 Data Sources 4 Associations

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

Data Sources (1)

Source	Alias	Join Type
I_MaintOrderOperAndSubOper	I_MaintenanceOrderOperation	from

Parameters (1)

Name	Type	Default
P_MaintenanceJobPackageUUID	eam_mjp_uuid

Associations (4)

Cardinality	Target	Alias	Condition
[0..1]	I_MaintOrderOperTechObj	_MaintOrderOperTechObj	`$projection.MaintenanceOrder = _MaintOrderOperTechObj.MaintenanceOrder and $projection.MaintenanceOrderOperation = _MaintOrderOperTechObj.MaintenanceOrderOperation`
[0..1]	I_EAMProcessPhase	_MaintOrdProcessPhase	`$projection.MaintOrdProcessPhaseCode = _MaintOrdProcessPhase.EAMProcessPhaseCode`
[0..1]	I_FunctionalLocation	_MaintOrdOpFunctionalLocation	`$projection.OperationFunctionalLocation = _MaintOrdOpFunctionalLocation.FunctionalLocation`
[0..1]	I_MaintenanceChecklistType	_ChecklistType	`$projection.MaintOperationalChecklistType = _ChecklistType.MaintOperationalChecklistType`

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	PMJOBPCKGOPS	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 (78)

Key	Field	Source Table	Source Field	Description
KEY	MaintenanceOrder	I_MaintOrderOperAndSubOper	MaintenanceOrder	Order
KEY	MaintenanceOrderOperation	I_MaintOrderOperAndSubOper	MaintenanceOrderOperation	Suboperation
KEY	MaintenanceOrderSubOperation	I_MaintOrderOperAndSubOper	MaintenanceOrderSubOperation	Suboperation
	MaintenanceOrderDesc
	OperationDescription	I_MaintOrderOperAndSubOper	OperationDescription	Op. Short Text
	MaintenanceOrderType
	MaintenancePlannerGroup
	MaintenancePlanningPlant
	MaintenancePlant
	MaintOperationExecStageCode	I_MaintOrderOperAndSubOper	MaintOperationExecStageCode	Execution Stage
	MaintOpExecutionStageName
	MaintOpExecStageShortText
	PlantSection
	ABCIndicator
	Equipment
	EquipmentCategory
	FunctionalLocation
	FunctionalLocationCategory
	MainWorkCenter
	MainWorkCenterPlant
	Assembly
	WBSElementInternalID
	ProjectInternalID
	MaintenanceRevision
	ResponsibleCostCenter
	MaintOrdPersonResponsible
	MaintenanceActivityType
	OrderSystemCondition
	MaintOrdBasicStartDate
	MaintOrdBasicEndDate
	LatestAcceptableCompletionDate
	MaintenancePlan
	MaintenanceItem
	MaintOrdProcessPhaseCode
	MaintOrdProcessSubPhaseCode
	MaintPriority
	MaintPriorityColorCode
	MaintPriorityDesc
	MaintenanceOrderInternalID
	OperationWorkCenterInternalID	I_MaintOrderOperAndSubOper	OperationWorkCenterInternalID	Object ID
	OperationWorkCenter
	WorkCenterText
	OperationControlKey	I_MaintOrderOperAndSubOper	OperationControlKey	Control Key
	OperationControlProfileName
	OperationSystemCondition	I_MaintOrderOperAndSubOper	OperationSystemCondition	SystemCondition
	OperationSystemConditionText
	OperationPurgInfoRecdSearchTxt	I_MaintOrderOperAndSubOper	OperationPurgInfoRecdSearchTxt	Sort Term
	MaintOrdOpProcessPhaseCode	I_MaintOrderOperAndSubOper	MaintOrdOpProcessPhaseCode	Process Phase
	EAMProcessPhaseCodeDesc
	MaintOrdOpProcessSubPhaseCode	I_MaintOrderOperAndSubOper	MaintOrdOpProcessSubPhaseCode	Process Subphase
	EAMProcessSubPhaseCodeDesc
	OpActualExecutionStartDate
	OpActualExecutionEndDate
	OpErlstSchedldExecStrtDte
	OpErlstSchedldExecEndDte
	OpLtstSchedldExecStrtDte
	OpLtstSchedldExecEndDte
	OperationPlannedWork
	OperationPlannedWorkUnit
	OperationEquipment	I_MaintOrderOperAndSubOper	Equipment	Equipment check
	MaintJobPckgOpsEquipCategory
	EquipmentName
	OperationFunctionalLocation
	OpFunctionalLocationLabelName
	MaintJobPckgOpsFuncLocCategory
	FunctionalLocationName
	CostCtrActivityType	I_MaintOrderOperAndSubOper	CostCtrActivityType	Activity Type
	CostCtrActivityTypeName
	OperationPersonResponsible	I_MaintOrderOperAndSubOper	OperationPersonResponsible	Personnel no.
	PersonFullName
	OperationMaintenanceNotif
	NotificationText
	MaintOperationalChecklistType	I_MaintOrderOperAndSubOper	MaintOperationalChecklistType	Checklist Type
	MaintOrderOperationInternalID	I_MaintOrderOperAndSubOper	MaintOrderOperationInternalID	Object number
	MaintenanceChecklistTypeText	_ChecklistType	MaintenanceChecklistTypeText
	MaintOrdTypeHasActvPhaseModel
	_MaintOrderOperTechObj		_MaintOrderOperTechObj
	_MaintOrdProcessPhase		_MaintOrdProcessPhase

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_MaintJobPckgOperations.
-- 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: PMJOBPCKGOPS
-- Parameters: P_MaintenanceJobPackageUUID : eam_mjp_uuid

CREATE VIEW P_MaintJobPckgOperations AS
SELECT
  I_MaintenanceOrderOperation.MaintenanceOrder AS MaintenanceOrder,
  I_MaintenanceOrderOperation.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  I_MaintenanceOrderOperation.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  I_MaintenanceOrderOperation.OperationDescription AS OperationDescription,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintenancePlant AS MaintenancePlant,
  I_MaintenanceOrderOperation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  I_MaintenanceOrderOperation._MaintOperationExecStageCode._MaintOpExecStageCodeText[ 1:LanguageCode = $session.system_language ].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  I_MaintenanceOrderOperation._MaintOperationExecStageCode._MaintOpExecStageCodeText[ 1:LanguageCode = $session.system_language ].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  I_MaintenanceOrderOperation._MaintenanceOrder._LocationAccountAssignment.PlantSection AS PlantSection,
  I_MaintenanceOrderOperation._MaintenanceOrder._LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  I_MaintenanceOrderOperation._MaintenanceOrder.Equipment AS Equipment,
  I_MaintenanceOrderOperation._MaintenanceOrder._Equipment.EquipmentCategory AS EquipmentCategory,
  cast ( I_MaintenanceOrderOperation._MaintenanceOrder._LocationAccountAssignment.FunctionalLocation as vdm_eam_tplnr preserving type ) AS FunctionalLocation,
  I_MaintenanceOrderOperation._MaintenanceOrder._LocationAccountAssignment._FunctionalLocation.FunctionalLocationCategory AS FunctionalLocationCategory,
  I_MaintenanceOrderOperation._MaintenanceOrder.MainWorkCenter AS MainWorkCenter,
  I_MaintenanceOrderOperation._MaintenanceOrder.MainWorkCenterPlant AS MainWorkCenterPlant,
  I_MaintenanceOrderOperation._MaintenanceOrder.Assembly AS Assembly,
  I_MaintenanceOrderOperation._MaintenanceOrder.WBSElementInternalID AS WBSElementInternalID,
  cast ( I_MaintenanceOrderOperation._MaintenanceOrder.ProjectInternalID as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintenanceRevision AS MaintenanceRevision,
  I_MaintenanceOrderOperation._MaintenanceOrder.ResponsibleCostCenter AS ResponsibleCostCenter,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintOrdPersonResponsible AS MaintOrdPersonResponsible,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintenanceActivityType AS MaintenanceActivityType,
  I_MaintenanceOrderOperation._MaintenanceOrder.OperationSystemCondition AS OrderSystemCondition,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintOrdBasicEndDate AS MaintOrdBasicEndDate,
  I_MaintenanceOrderOperation._MaintenanceOrder.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintenancePlan AS MaintenancePlan,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintenanceItem AS MaintenanceItem,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintOrdProcessSubPhaseCode AS MaintOrdProcessSubPhaseCode,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintPriority AS MaintPriority,
  I_MaintenanceOrderOperation._MaintenanceOrder._MaintenancePriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  I_MaintenanceOrderOperation._MaintenanceOrder._MaintenancePriority._Text[ 1:Language = $session.system_language ].MaintPriorityDesc AS MaintPriorityDesc,
  I_MaintenanceOrderOperation._MaintenanceOrder.MaintenanceOrderInternalID AS MaintenanceOrderInternalID,
  I_MaintenanceOrderOperation.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  I_MaintenanceOrderOperation._WorkCenter.WorkCenter AS OperationWorkCenter,
  I_MaintenanceOrderOperation._WorkCenter._Text[ 1:Language = $session.system_language ].WorkCenterText AS WorkCenterText,
  I_MaintenanceOrderOperation.OperationControlKey AS OperationControlKey,
  I_MaintenanceOrderOperation._OperationControlKey._Text[ 1:Language = $session.system_language ].OperationControlProfileName AS OperationControlProfileName,
  I_MaintenanceOrderOperation.OperationSystemCondition AS OperationSystemCondition,
  I_MaintenanceOrderOperation._OperationSystemCondition._Text[ 1:Language = $session.system_language ].OperationSystemConditionText AS OperationSystemConditionText,
  I_MaintenanceOrderOperation.OperationPurgInfoRecdSearchTxt AS OperationPurgInfoRecdSearchTxt,
  I_MaintenanceOrderOperation.MaintOrdOpProcessPhaseCode AS MaintOrdOpProcessPhaseCode,
  I_MaintenanceOrderOperation._EAMProcessPhase._EAMProcessPhaseText[ 1:Language = $session.system_language ].EAMProcessPhaseCodeDesc AS EAMProcessPhaseCodeDesc,
  I_MaintenanceOrderOperation.MaintOrdOpProcessSubPhaseCode AS MaintOrdOpProcessSubPhaseCode,
  I_MaintenanceOrderOperation._EAMProcessSubPhase._EAMProcessSubPhaseText[ 1:Language = $session.system_language ].EAMProcessSubPhaseCodeDesc AS EAMProcessSubPhaseCodeDesc,
  I_MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  I_MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  I_MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  I_MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  I_MaintenanceOrderOperation._OperationPlanningValues.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  I_MaintenanceOrderOperation._OperationPlanningValues.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  I_MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  I_MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  I_MaintenanceOrderOperation.Equipment AS OperationEquipment,
  I_MaintenanceOrderOperation._Equipment.EquipmentCategory AS MaintJobPckgOpsEquipCategory,
  I_MaintenanceOrderOperation._Equipment._EquipmentText[ 1:Language = $session.system_language ].EquipmentName AS EquipmentName,
  cast( I_MaintenanceOrderOperation.FunctionalLocation as vdm_eam_tplnr preserving type ) AS OperationFunctionalLocation,
  _MaintOrdOpFunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS OpFunctionalLocationLabelName,
  I_MaintenanceOrderOperation._FunctionalLocation.FunctionalLocationCategory AS MaintJobPckgOpsFuncLocCategory,
  I_MaintenanceOrderOperation._FunctionalLocation._FunctionalLocationText[ 1:Language = $session.system_language ].FunctionalLocationName AS FunctionalLocationName,
  I_MaintenanceOrderOperation.CostCtrActivityType AS CostCtrActivityType,
  I_MaintenanceOrderOperation._CostCenterActivityTypeText[ 1: ValidityEndDate = '99991231' and Language = $session.system_language ].CostCtrActivityTypeName AS CostCtrActivityTypeName,
  I_MaintenanceOrderOperation.OperationPersonResponsible AS OperationPersonResponsible,
  I_MaintenanceOrderOperation._PersonResponsible.PersonFullName AS PersonFullName,
  _MaintOrderOperTechObj._MaintOrderOperObjectListLink._MaintenanceItemObject.MaintenanceNotification AS OperationMaintenanceNotif,
  _MaintOrderOperTechObj._MaintOrderOperObjectListLink._MaintenanceItemObject._MaintenanceNotification.NotificationText AS NotificationText,
  I_MaintenanceOrderOperation.MaintOperationalChecklistType AS MaintOperationalChecklistType,
  I_MaintenanceOrderOperation.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  _ChecklistType.MaintenanceChecklistTypeText AS MaintenanceChecklistTypeText,
  I_MaintenanceOrderOperation._MaintenanceOrder._MaintOrderTypeControlParam.MaintOrdTypeHasActvPhaseModel AS MaintOrdTypeHasActvPhaseModel
FROM I_MaintOrderOperAndSubOper AS I_MaintenanceOrderOperation
LEFT OUTER JOIN I_MaintOrderOperTechObj AS _MaintOrderOperTechObj ON MaintenanceOrder = _MaintOrderOperTechObj.MaintenanceOrder AND MaintenanceOrderOperation = _MaintOrderOperTechObj.MaintenanceOrderOperation  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessPhase AS _MaintOrdProcessPhase ON MaintOrdProcessPhaseCode = _MaintOrdProcessPhase.EAMProcessPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _MaintOrdOpFunctionalLocation ON OperationFunctionalLocation = _MaintOrdOpFunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceChecklistType AS _ChecklistType ON MaintOperationalChecklistType = _ChecklistType.MaintOperationalChecklistType  -- association [0..1]
;

Depth:

P_MaintJobPckgOperations view

I_MaintOrderOperAndSubOper view