C_MaintJobPackageOperationTP

DDL: C_MAINTJOBPACKAGEOPERATIONTP Type: view_entity CONSUMPTION

Maintenance Job Pack Operation

C_MaintJobPackageOperationTP is a Consumption CDS View that provides data about "Maintenance Job Pack Operation" in SAP S/4HANA. It reads from 1 data source (R_MaintJobPackageOperationTP) and exposes 48 fields with key field MaintJobPackageOperationUUID. It is exposed through 1 OData service (UI_MAINTJOBPCKGBUILD_MNG). It is used in 1 Fiori application: Manage Work Packs.

Data Sources (1)

SourceAliasJoin Type
R_MaintJobPackageOperationTP R_MaintJobPackageOperationTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Maintenance Job Pack Operation view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MAINTJOBPCKGBUILD_MNG UI_MAINTJOBPCKGBUILD_MNG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6065 Manage Work Packs Transactional Manage Work Packs.

Manage Work Packs

Business Role: Maintenance Planner

With this app, you can find existing work packs, select work packs, job packs, and included items and send them to the output immediately or schedule them to be eligible for the mass output. A work pack consists of a list of job packs in which the system can output together and the work order operations (jobs) belonging to the corresponding job packs (the set of jobs in a job pack are work order operations that you can create one output request for). Work packs allow you to include multiple output types and leverage support for print and email channels for the output.

Key Features: You can use this app to do the following: Search for and display created work packs See detailed information about selected work packs, such as type, grouping criteria, output status Select work packs, job packs, and job pack items and send them to the output immediately or prepare them for mass output Select multiple attachments, add them to a single output item, and trigger a single printout or email.Attachments for notifications are retrieved from: Notification header Equipment in the notification header Functional location in the notification header Attachments from an order are retrieved from: Order header Equipment in the order header Functional location in the order header Operations of the order Equipment in the operation of the order Functional location in the operation of the order Object list of the order Equipment in the object list of the order Functional location in the object list of the order Notification from the order header Notification from operations of the order Note Only PDF type documents can be added to output items to create a single document. All other document types are considered separate documents. Retry output or set the status of the output to completed manually in case of any errors

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY MaintJobPackageOperationUUID MaintJobPackageOperationUUID Operation UUID
MaintenanceJobPackageUUID MaintenanceJobPackageUUID Job Package UUID
MaintenanceJobPackageBuildUUID MaintenanceJobPackageBuildUUID Package Build UUID
MaintenanceOrder MaintenanceOrder Order
MaintenanceOrderDesc
MaintenanceOrderOperation MaintenanceOrderOperation Suboperation
MaintenanceOrderSubOperation MaintenanceOrderSubOperation Suboperation
OperationDescription _MaintenanceOrderOperation OperationDescription Op. Short Text
Equipment _MaintenanceOrderOperation Equipment Equipment check
EquipmentNamelocalized
MaintOperationExecStageCode _MaintenanceOrderOperation MaintOperationExecStageCode Execution Stage
MaintOpExecutionStageNamelocalized
MaintOpExecStageShortTextlocalized
OpActualExecutionStartDate
OpActualExecutionEndDate
OperationPlannedWork
OperationPlannedWorkUnit
UnitOfMeasureNamelocalized
MaintOrdOpProcessPhaseCode _MaintenanceOrderOperation MaintOrdOpProcessPhaseCode Process Phase
EAMProcessPhaseCodeDesclocalized
MaintOrdOpProcessSubPhaseCode _MaintenanceOrderOperation MaintOrdOpProcessSubPhaseCode Process Subphase
EAMProcessSubPhaseCodeDesclocalized
OpErlstSchedldExecStrtDte
OpErlstSchedldExecEndDte
OpLtstSchedldExecStrtDte
OpLtstSchedldExecEndDte
MaintPriority
MaintPriorityColorCode
OperationWorkCenterInternalID _MaintenanceOrderOperation OperationWorkCenterInternalID Object ID
WorkCenter
WorkCenterTextlocalized
OperationControlKey _MaintenanceOrderOperation OperationControlKey Control Key
OperationControlProfileNamelocalized
ActivityType _MaintenanceOrderOperation ActivityType Activity Type
CostCtrActivityTypeName
OperationPersonResponsible _MaintenanceOrderOperation OperationPersonResponsible Personnel no.
OperationPersonRespName
OperationSystemCondition _MaintenanceOrderOperation OperationSystemCondition SystemCondition
OperationSystemConditionTextlocalized
FunctionalLocation
FunctionalLocationLabelName
FunctionalLocationNamelocalized
OperationPurgInfoRecdSearchTxt _MaintenanceOrderOperation OperationPurgInfoRecdSearchTxt Sort Term
OperationMaintenanceNotif
OperationMaintNotificationText
_MaintenanceOrderOperation _MaintenanceOrderOperation
_MaintOrderOperTechObj _MaintOrderOperTechObj
_MaintJobPckgOpValidity _MaintJobPckgOpValidity

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 C_MaintJobPackageOperationTP.
-- 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 C_MaintJobPackageOperationTP AS
SELECT
  MaintJobPackageOperationUUID,
  MaintenanceJobPackageUUID,
  MaintenanceJobPackageBuildUUID,
  MaintenanceOrder,
  _MaintenanceOrderOperation._MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  _MaintenanceOrderOperation.OperationDescription AS OperationDescription,
  _MaintenanceOrderOperation.Equipment AS Equipment,
  _MaintenanceOrderOperation._Equipment._EquipmentText.EquipmentName : localized AS EquipmentNamelocalized,
  _MaintenanceOrderOperation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  _MaintenanceOrderOperation._MaintOperationExecStageCode._MaintOpExecStageCodeText.MaintOpExecutionStageName : localized AS MaintOpExecutionStageNamelocalized,
  _MaintenanceOrderOperation._MaintOperationExecStageCode._MaintOpExecStageCodeText.MaintOpExecStageShortText : localized AS MaintOpExecStageShortTextlocalized,
  _MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  _MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  _MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  _MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  _MaintenanceOrderOperation._OperationPlanningValues._PlannedWorkUnitOfMeasure._Text.UnitOfMeasureName : localized AS UnitOfMeasureNamelocalized,
  _MaintenanceOrderOperation.MaintOrdOpProcessPhaseCode AS MaintOrdOpProcessPhaseCode,
  _MaintenanceOrderOperation._EAMProcessPhase._EAMProcessPhaseText.EAMProcessPhaseCodeDesc : localized AS EAMProcessPhaseCodeDesclocalized,
  _MaintenanceOrderOperation.MaintOrdOpProcessSubPhaseCode AS MaintOrdOpProcessSubPhaseCode,
  _MaintenanceOrderOperation._EAMProcessSubPhase._EAMProcessSubPhaseText.EAMProcessSubPhaseCodeDesc : localized AS EAMProcessSubPhaseCodeDesclocalized,
  _MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  _MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  _MaintenanceOrderOperation._OperationPlanningValues.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  _MaintenanceOrderOperation._OperationPlanningValues.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  _MaintenanceOrderOperation._MaintenanceOrder.MaintPriority AS MaintPriority,
  _MaintenanceOrderOperation._MaintenanceOrder._MaintenancePriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  _MaintenanceOrderOperation.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  _MaintenanceOrderOperation._WorkCenter.WorkCenter AS WorkCenter,
  _MaintenanceOrderOperation._WorkCenter._Text.WorkCenterText : localized AS WorkCenterTextlocalized,
  _MaintenanceOrderOperation.OperationControlKey AS OperationControlKey,
  _MaintenanceOrderOperation._OperationControlKey._Text.OperationControlProfileName : localized AS OperationControlProfileNamelocalized,
  _MaintenanceOrderOperation.ActivityType AS ActivityType,
  _MaintenanceOrderOperation._CostCenterActivityTypeText[ 1: ValidityEndDate = '99991231' and Language = $session.system_language ].CostCtrActivityTypeName AS CostCtrActivityTypeName,
  _MaintenanceOrderOperation.OperationPersonResponsible AS OperationPersonResponsible,
  _MaintenanceOrderOperation._PersonResponsible.PersonFullName AS OperationPersonRespName,
  _MaintenanceOrderOperation.OperationSystemCondition AS OperationSystemCondition,
  _MaintenanceOrderOperation._OperationSystemCondition._Text.OperationSystemConditionText : localized AS OperationSystemConditionTextlocalized,
  cast( _MaintenanceOrderOperation.FunctionalLocation as tplnr_unconverted preserving type ) AS FunctionalLocation,
  _MaintenanceOrderOperation._FunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _MaintenanceOrderOperation._FunctionalLocation._FunctionalLocationText.FunctionalLocationName : localized AS FunctionalLocationNamelocalized,
  _MaintenanceOrderOperation.OperationPurgInfoRecdSearchTxt AS OperationPurgInfoRecdSearchTxt,
  _MaintOrderOperTechObj._MaintOrderOperObjectListLink._MaintenanceItemObject.MaintenanceNotification AS OperationMaintenanceNotif,
  _MaintOrderOperTechObj._MaintOrderOperObjectListLink._MaintenanceItemObject._MaintenanceNotification.NotificationText AS OperationMaintNotificationText
FROM R_MaintJobPackageOperationTP
;