C_MaintenanceJobPackageTP

DDL: C_MAINTENANCEJOBPACKAGETP Type: view_entity CONSUMPTION
129 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Maintenance Job Pack

C_MaintenanceJobPackageTP is a Consumption CDS View that provides data about "Maintenance Job Pack" in SAP S/4HANA. It reads from 1 data source (R_MaintenanceJobPackageTP) and exposes 129 fields with key field MaintenanceJobPackageUUID. 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_MaintenanceJobPackageTP R_MaintenanceJobPackageTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Maintenance Job Pack view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey MaintenanceJobPackageUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL 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 (129)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceJobPackageUUID MaintenanceJobPackageUUID Job Package UUID
MaintenanceJobPackageBuildUUID MaintenanceJobPackageBuildUUID Package Build UUID
MaintenanceJobPackage MaintenanceJobPackage Maintenance Job Pckg
MaintenanceJobPackageName MaintenanceJobPackageName Job Pack Name
MaintenanceOrder MaintenanceOrder Order
MaintenanceOrderDesc _MaintenanceOrder MaintenanceOrderDesc Description
MaintenanceOrderType MaintenanceOrderType Order Type
OrderTypeNamelocalized
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenancePlannerGroupName _MaintenancePlannerGroup MaintenancePlannerGroupName Planner Group Name
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlanningPlantName _MaintenancePlanningPlant PlantName Plant Name
MaintenancePlant MaintenancePlant Plant
MaintenancePlantName _MaintenancePlant PlantName Plant Name
PlantSection PlantSection Plant Section
ABCIndicator ABCIndicator ABC Indicator
ABCIndicatorDesclocalized
Equipment Equipment Equipment check
EquipmentNamelocalized
EquipmentCategory EquipmentCategory EquipCategory
EquipmentCategoryDesclocalized
FunctionalLocation FunctionalLocation Object ID
FunctionalLocationLabelName
FunctionalLocationNamelocalized
FunctionalLocationCategory FunctionalLocationCategory FunctLocCat.
FunctionalLocationCategoryDesclocalized
MainWorkCenterInternalID MainWorkCenterInternalID Work Center
MainWorkCenter _MainWorkCenter WorkCenter Work Center
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
MainWorkCenterPlantName _MainWorkCenterPlant PlantName Plant Name
Assembly Assembly Pegged Reqmt
MaterialNameasAssemblyNamelocalized
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID _WBSElementBasicData WBSElementExternalID WBS Element External ID
WBSDescription _WBSElementBasicData WBSDescription WBS Element Name
ProjectInternalID ProjectInternalID Project Def.
Project
ProjectDescription _Project ProjectDescription Project Name
MaintenanceRevision MaintenanceRevision Revision
MaintenanceRevisionDesc _MaintenanceRevision MaintenanceRevisionDesc
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
MaintOrdPersonResponsible MaintOrdPersonResponsible Person Resp. ID
EmployeeFullName _MaintOrdPersonResponsible EmployeeFullName
MaintenanceActivityType MaintenanceActivityType MaintActivType
MaintenanceActivityTypeNamelocalized
OrderSystemCondition OrderSystemCondition SystemCondition
MaintPriority MaintPriority Priority
MaintPriorityColorCode _MaintenancePriority MaintPriorityColorCode
MaintOrdBasicStartDate MaintOrdBasicStartDate Bas. Start Date
MaintOrdBasicEndDate MaintOrdBasicEndDate Basic fin. date
LatestAcceptableCompletionDate LatestAcceptableCompletionDate Final Due Date
MaintenancePlan MaintenancePlan MaintenancePlan
MaintenancePlanDesc _MaintenancePlan MaintenancePlanDesc
MaintenanceItem MaintenanceItem MaintItem
MaintenanceItemDescription _MaintenanceItem MaintenanceItemDescription MaintItem text
MaintOrdProcessPhaseCode MaintOrdProcessPhaseCode Process Phase
MaintOrdProcessSubPhaseCode MaintOrdProcessSubPhaseCode Process Subphase
BusinessArea BusinessArea Business Area
BusinessAreaNamelocalized
OperationWorkCenterInternalID OperationWorkCenterInternalID Object ID
OperationWorkCenter _OperationWorkCenter WorkCenter Work Center
WorkCenterTextlocalized
OperationControlKey OperationControlKey Control Key
OperationControlProfileNamelocalized
CostCtrActivityType CostCtrActivityType Activity Type
CostCtrActivityTypeNamelocalized
OperationPersonResponsible OperationPersonResponsible Personnel no.
OperationPersonRespName _MaintOrdOpPersonResponsible PersonFullName Full Name
OperationSystemCondition OperationSystemCondition SystemCondition
OperationSystemConditionTextlocalized
OperationPurgInfoRecdSearchTxt OperationPurgInfoRecdSearchTxt Sort Term
MaintOperationExecStageCode MaintOperationExecStageCode Execution Stage
MaintOpExecutionStageNamelocalized
MaintOpExecStageShortTextlocalized
MaintOrdOpProcessPhaseCode MaintOrdOpProcessPhaseCode Process Phase
MaintOrdOpProcessSubPhaseCode MaintOrdOpProcessSubPhaseCode Process Subphase
OpErlstSchedldExecStrtDte OpErlstSchedldExecStrtDte Earl.start date
OpErlstSchedldExecEndDte OpErlstSchedldExecEndDte EarliestEndDate
OpLtstSchedldExecStrtDte OpLtstSchedldExecStrtDte Latest start
OpLtstSchedldExecEndDte OpLtstSchedldExecEndDte Lat.finish date
OpActualExecutionStartDate OpActualExecutionStartDate Execution Start Date
OpActualExecutionEndDate OpActualExecutionEndDate Execution End Date
OperationEquipment OperationEquipment Equipment (Operation)
MaintJobPckgOpsEquipCategory MaintJobPckgOpsEquipCategory Operation Equip. Cat
OperationFunctionalLocation OperationFunctionalLocation Functional Location (Operation)
OpFunctionalLocationLabelName
MaintJobPckgOpsFuncLocCategory MaintJobPckgOpsFuncLocCategory Operation Func. Loc. Category
OperationMaintenanceNotif OperationMaintenanceNotif Notification
OperationMaintNotificationText _OperationNotification NotificationText Description
MaintOperationalChecklistType MaintOperationalChecklistType Checklist Type
MaintenanceChecklistTypeText _ChecklistType MaintenanceChecklistTypeText
MaintJobPckgOutputStatus _MaintJobPackageStatus MaintJobPckgOutputStatus Output Status
MaintJobPckgOutputStatusTextlocalized
NumberOfMaintJobPackageOps _MaintenanceJobPackageTotals NumberOfMaintJobPackageOps
NmbrOfMaintJobPckgOutputItems _MaintenanceJobPackageTotals NmbrOfMaintJobPckgOutputItems
MaintJobPckgPlannedWork _MaintenanceJobPackageTotals MaintJobPckgPlannedWork
MaintJobPckgPlannedWorkUnit _MaintenanceJobPackageTotals MaintJobPckgPlannedWorkUnit
CreatedByUser CreatedByUser User Name
CreatedByUserName CreatedByUserName Person Resp.
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName LastChangedByUserName User Name
LastChangeDateTime LastChangeDateTime Timestamp
virtualUICT_MaintenanceOrderboole_d
virtualUICT_MaintenanceOrderTypeboole_d
virtualUICT_MaintenancePlantboole_d
virtualUICT_PlantSectionboole_d
virtualUICT_ABCIndicatorboole_d
virtualUICT_Equipmentboole_d
virtualUICT_EquipmentCategoryboole_d
virtualUICT_FunctionalLocationboole_d
virtualUICT_MainWorkCenterboole_d
virtualUICT_MainWorkCenterPlantboole_d
virtualUICT_Assemblyboole_d
virtualUICT_WBSElementInternalIDboole_d
virtualUICT_ProjectInternalIDboole_d
virtualUICT_MaintenanceRevisionboole_d
virtualUICT_ResponsibleCostCenterboole_d
virtualUICT_OrderSystemConditionboole_d
virtualUICT_MaintPriorityboole_d
virtualUICT_MaintOrdBasicEndDateboole_d
virtualUICT_MaintenancePlanboole_d
virtualUICT_MaintenanceItemboole_d
virtualUICT_BusinessAreaboole_d
virtualUICT_OperationControlKeyboole_d
virtualUICT_OperationEquipmentboole_d
virtualUICT_CostCtrActivityTypeboole_d
_MaintJobPackageStatus _MaintJobPackageStatus
_MaintenanceJobPackageTotals _MaintenanceJobPackageTotals

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_MaintenanceJobPackageTP.
-- 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_MaintenanceJobPackageTP AS
SELECT
  MaintenanceJobPackageUUID,
  MaintenanceJobPackageBuildUUID,
  MaintenanceJobPackage,
  MaintenanceJobPackageName,
  MaintenanceOrder,
  _MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  MaintenanceOrderType,
  _MaintenanceOrderType._Text.OrderTypeName : localized AS OrderTypeNamelocalized,
  MaintenancePlannerGroup,
  _MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  MaintenancePlanningPlant,
  _MaintenancePlanningPlant.PlantName AS MaintenancePlanningPlantName,
  MaintenancePlant,
  _MaintenancePlant.PlantName AS MaintenancePlantName,
  PlantSection,
  ABCIndicator,
  _ABCIndicator._Text.ABCIndicatorDesc : localized AS ABCIndicatorDesclocalized,
  Equipment,
  _MaintOrderEquipment._EquipmentText.EquipmentName : localized AS EquipmentNamelocalized,
  EquipmentCategory,
  _MaintOrderEquipmentCategory._Text.EquipmentCategoryDesc : localized AS EquipmentCategoryDesclocalized,
  FunctionalLocation,
  _MaintOrdFunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _MaintOrdFunctionalLocation._FunctionalLocationText.FunctionalLocationName : localized AS FunctionalLocationNamelocalized,
  FunctionalLocationCategory,
  _MaintOrdFuncLocationCategory._Text.FunctionalLocationCategoryDesc : localized AS FunctionalLocationCategoryDesclocalized,
  MainWorkCenterInternalID,
  _MainWorkCenter.WorkCenter AS MainWorkCenter,
  MainWorkCenterPlant,
  _MainWorkCenterPlant.PlantName AS MainWorkCenterPlantName,
  Assembly,
  _Assembly._Text.MaterialName as AssemblyName : localized AS MaterialNameasAssemblyNamelocalized,
  WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  ProjectInternalID,
  cast ( _Project.Project as ps_s4_ps_pspid preserving type ) AS Project,
  _Project.ProjectDescription AS ProjectDescription,
  MaintenanceRevision,
  _MaintenanceRevision.MaintenanceRevisionDesc AS MaintenanceRevisionDesc,
  ResponsibleCostCenter,
  MaintOrdPersonResponsible,
  _MaintOrdPersonResponsible.EmployeeFullName AS EmployeeFullName,
  MaintenanceActivityType,
  _MaintenanceActivityType._Text.MaintenanceActivityTypeName : localized AS MaintenanceActivityTypeNamelocalized,
  OrderSystemCondition,
  MaintPriority,
  _MaintenancePriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  MaintOrdBasicStartDate,
  MaintOrdBasicEndDate,
  LatestAcceptableCompletionDate,
  MaintenancePlan,
  _MaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
  MaintenanceItem,
  _MaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
  MaintOrdProcessPhaseCode,
  MaintOrdProcessSubPhaseCode,
  BusinessArea,
  _BusinessArea._Text.BusinessAreaName : localized AS BusinessAreaNamelocalized,
  OperationWorkCenterInternalID,
  _OperationWorkCenter.WorkCenter AS OperationWorkCenter,
  _OperationWorkCenter._Text.WorkCenterText : localized AS WorkCenterTextlocalized,
  OperationControlKey,
  _OperationControlKey._Text.OperationControlProfileName : localized AS OperationControlProfileNamelocalized,
  CostCtrActivityType,
  _OpCostCenterActivityType._Text.CostCtrActivityTypeName : localized AS CostCtrActivityTypeNamelocalized,
  OperationPersonResponsible,
  _MaintOrdOpPersonResponsible.PersonFullName AS OperationPersonRespName,
  OperationSystemCondition,
  _OperationSystemCondition._Text.OperationSystemConditionText : localized AS OperationSystemConditionTextlocalized,
  OperationPurgInfoRecdSearchTxt,
  MaintOperationExecStageCode,
  _MaintOperationExecStageCode._MaintOpExecStageCodeText.MaintOpExecutionStageName : localized AS MaintOpExecutionStageNamelocalized,
  _MaintOperationExecStageCode._MaintOpExecStageCodeText.MaintOpExecStageShortText : localized AS MaintOpExecStageShortTextlocalized,
  MaintOrdOpProcessPhaseCode,
  MaintOrdOpProcessSubPhaseCode,
  OpErlstSchedldExecStrtDte,
  OpErlstSchedldExecEndDte,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecEndDte,
  OpActualExecutionStartDate,
  OpActualExecutionEndDate,
  OperationEquipment,
  MaintJobPckgOpsEquipCategory,
  OperationFunctionalLocation,
  _MaintOrdOpFunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS OpFunctionalLocationLabelName,
  MaintJobPckgOpsFuncLocCategory,
  OperationMaintenanceNotif,
  _OperationNotification.NotificationText AS OperationMaintNotificationText,
  MaintOperationalChecklistType,
  _ChecklistType.MaintenanceChecklistTypeText AS MaintenanceChecklistTypeText,
  _MaintJobPackageStatus.MaintJobPckgOutputStatus AS MaintJobPckgOutputStatus,
  _MaintJobPackageStatus._MaintJobPckgOutputStatus._Text.MaintJobPckgOutputStatusText : localized AS MaintJobPckgOutputStatusTextlocalized,
  _MaintenanceJobPackageTotals.NumberOfMaintJobPackageOps AS NumberOfMaintJobPackageOps,
  _MaintenanceJobPackageTotals.NmbrOfMaintJobPckgOutputItems AS NmbrOfMaintJobPckgOutputItems,
  _MaintenanceJobPackageTotals.MaintJobPckgPlannedWork AS MaintJobPckgPlannedWork,
  _MaintenanceJobPackageTotals.MaintJobPckgPlannedWorkUnit AS MaintJobPckgPlannedWorkUnit,
  CreatedByUser,
  CreatedByUserName,
  CreationDateTime,
  LastChangedByUser,
  LastChangedByUserName,
  LastChangeDateTime,
  virtual UICT_MaintenanceOrder : boole_d AS virtualUICT_MaintenanceOrderboole_d,
  virtual UICT_MaintenanceOrderType : boole_d AS virtualUICT_MaintenanceOrderTypeboole_d,
  virtual UICT_MaintenancePlant : boole_d AS virtualUICT_MaintenancePlantboole_d,
  virtual UICT_PlantSection : boole_d AS virtualUICT_PlantSectionboole_d,
  virtual UICT_ABCIndicator : boole_d AS virtualUICT_ABCIndicatorboole_d,
  virtual UICT_Equipment : boole_d AS virtualUICT_Equipmentboole_d,
  virtual UICT_EquipmentCategory : boole_d AS virtualUICT_EquipmentCategoryboole_d,
  virtual UICT_FunctionalLocation : boole_d AS virtualUICT_FunctionalLocationboole_d,
  virtual UICT_MainWorkCenter : boole_d AS virtualUICT_MainWorkCenterboole_d,
  virtual UICT_MainWorkCenterPlant : boole_d AS virtualUICT_MainWorkCenterPlantboole_d,
  virtual UICT_Assembly : boole_d AS virtualUICT_Assemblyboole_d,
  virtual UICT_WBSElementInternalID : boole_d AS virtualUICT_WBSElementInternalIDboole_d,
  virtual UICT_ProjectInternalID : boole_d AS virtualUICT_ProjectInternalIDboole_d,
  virtual UICT_MaintenanceRevision : boole_d AS virtualUICT_MaintenanceRevisionboole_d,
  virtual UICT_ResponsibleCostCenter : boole_d AS virtualUICT_ResponsibleCostCenterboole_d,
  virtual UICT_OrderSystemCondition : boole_d AS virtualUICT_OrderSystemConditionboole_d,
  virtual UICT_MaintPriority : boole_d AS virtualUICT_MaintPriorityboole_d,
  virtual UICT_MaintOrdBasicEndDate : boole_d AS virtualUICT_MaintOrdBasicEndDateboole_d,
  virtual UICT_MaintenancePlan : boole_d AS virtualUICT_MaintenancePlanboole_d,
  virtual UICT_MaintenanceItem : boole_d AS virtualUICT_MaintenanceItemboole_d,
  virtual UICT_BusinessArea : boole_d AS virtualUICT_BusinessAreaboole_d,
  virtual UICT_OperationControlKey : boole_d AS virtualUICT_OperationControlKeyboole_d,
  virtual UICT_OperationEquipment : boole_d AS virtualUICT_OperationEquipmentboole_d,
  virtual UICT_CostCtrActivityType : boole_d AS virtualUICT_CostCtrActivityTypeboole_d
FROM R_MaintenanceJobPackageTP
;

Learn More