R_MaintenanceJobPackageTP

DDL: R_MAINTENANCEJOBPACKAGETP Type: view_entity TRANSACTIONAL Package: RAP_EAM_MAINTJOBPACKAGE
112 Fields 1 Data Sources 1 Associations

Maintenance Job Pack - TP

R_MaintenanceJobPackageTP is a Transactional CDS View that provides data about "Maintenance Job Pack - TP" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceJobPackage) and exposes 112 fields with key field MaintenanceJobPackageUUID. It has 1 association to related views. Part of development package RAP_EAM_MAINTJOBPACKAGE.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceJobPackage I_MaintenanceJobPackage from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_MaintJobPackageOperationTP _MaintJobPackageOperationTP

Annotations (8)

NameValueLevelField
EndUserText.label Maintenance Job Pack - TP view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey MaintenanceJobPackageUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (112)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceJobPackageUUID MaintenanceJobPackageUUID Job Package UUID
MaintenanceJobPackageBuildUUID MaintenanceJobPackageBuildUUID Package Build UUID
MaintenanceJobPackage MaintenanceJobPackage Maintenance Job Pckg
MaintenanceJobPackageName MaintenanceJobPackageName Job Pack Name
MaintJobPckgOutputStatus _MaintJobPackageStatus MaintJobPckgOutputStatus Output Status
MaintenanceOrder MaintenanceOrder Order
MaintenanceOrderType MaintenanceOrderType Order Type
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlant MaintenancePlant Plant
PlantSection PlantSection Plant Section
ABCIndicator ABCIndicator ABC Indicator
Equipment Equipment Equipment check
EquipmentCategory EquipmentCategory EquipCategory
FunctionalLocation FunctionalLocation Object ID
FunctionalLocationCategory FunctionalLocationCategory FunctLocCat.
MainWorkCenterInternalID MainWorkCenterInternalID Work Center
MainWorkCenter MainWorkCenter Work Center
MainWorkCenterTypeCode MainWorkCenterTypeCode Object Type
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
Assembly Assembly Pegged Reqmt
WBSElementInternalID WBSElementInternalID WBS Internal ID
ProjectInternalID ProjectInternalID Project Def.
MaintenanceRevision MaintenanceRevision Revision
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
ControllingArea ControllingArea Controlling Area
MaintOrdPersonResponsible MaintOrdPersonResponsible Person Resp. ID
MaintenanceActivityType MaintenanceActivityType MaintActivType
OrderSystemCondition OrderSystemCondition SystemCondition
MaintPriority MaintPriority Priority
MaintPriorityType MaintPriorityType PriorityType
MaintOrdBasicStartDate MaintOrdBasicStartDate Bas. Start Date
MaintOrdBasicEndDate MaintOrdBasicEndDate Basic fin. date
LatestAcceptableCompletionDate LatestAcceptableCompletionDate Final Due Date
MaintenancePlan MaintenancePlan MaintenancePlan
MaintenanceItem MaintenanceItem MaintItem
MaintOrdProcessPhaseCode MaintOrdProcessPhaseCode Process Phase
MaintOrdProcessSubPhaseCode MaintOrdProcessSubPhaseCode Process Subphase
BusinessArea BusinessArea Business Area
OperationWorkCenterInternalID OperationWorkCenterInternalID Object ID
OperationControlKey OperationControlKey Control Key
CostCtrActivityType CostCtrActivityType Activity Type
OperationPersonResponsible OperationPersonResponsible Personnel no.
OperationPersonRespName
OperationSystemCondition OperationSystemCondition SystemCondition
OperationPurgInfoRecdSearchTxt OperationPurgInfoRecdSearchTxt Sort Term
MaintOperationExecStageCode MaintOperationExecStageCode Execution Stage
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)
MaintJobPckgOpsFuncLocCategory MaintJobPckgOpsFuncLocCategory Operation Func. Loc. Category
OperationMaintenanceNotif OperationMaintenanceNotif Notification
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreatedByUserName
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName
_MaintJobPackageOperationTP _MaintJobPackageOperationTP
_MaintenanceJobPackageBuildTP _MaintenanceJobPackageBuildTP
_MaintJobPackageOperation _MaintJobPackageOperation
_MaintJobPackageStatus _MaintJobPackageStatus
_MaintenanceJobPackageTotals _MaintenanceJobPackageTotals
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_MaintenanceOrder _MaintenanceOrder
_MaintenanceOrderType _MaintenanceOrderType
_MaintOrdProcessPhase _MaintOrdProcessPhase
_MaintOrdProcessSubPhase _MaintOrdProcessSubPhase
_Project _Project
_WBSElementBasicData _WBSElementBasicData
_MaintenancePlan _MaintenancePlan
_MaintenancePlanningPlant _MaintenancePlanningPlant
_MaintenancePlant _MaintenancePlant
_ABCIndicator _ABCIndicator
_Assembly _Assembly
_MaintOrderEquipment _MaintOrderEquipment
_MaintOrderEquipmentCategory _MaintOrderEquipmentCategory
_MaintOrdFunctionalLocation _MaintOrdFunctionalLocation
_MaintOrdFuncLocationCategory _MaintOrdFuncLocationCategory
_MaintenanceRevision _MaintenanceRevision
_MaintenanceActivityType _MaintenanceActivityType
_BusinessArea _BusinessArea
_MaintenancePriority _MaintenancePriority
_MaintenancePlannerGroup _MaintenancePlannerGroup
_MaintenanceItem _MaintenanceItem
_MaintOrdPersonResponsible _MaintOrdPersonResponsible
_MaintOrderOpSystemCondition _MaintOrderOpSystemCondition
_MainWorkCenter _MainWorkCenter
_MainWorkCenterPlant _MainWorkCenterPlant
_ResponsibleCostCenter _ResponsibleCostCenter
_OperationWorkCenter _OperationWorkCenter
_OperationControlKey _OperationControlKey
_MaintOperationExecStageCode _MaintOperationExecStageCode
_MaintOrdOpProcessPhase _MaintOrdOpProcessPhase
_MaintOrdOpProcessSubPhase _MaintOrdOpProcessSubPhase
_MaintOrdOpPersonResponsible _MaintOrdOpPersonResponsible
_OperationSystemCondition _OperationSystemCondition
_MaintOrdOpEquipment _MaintOrdOpEquipment
_MaintOrderOpEquipmentCategory _MaintOrderOpEquipmentCategory
_MaintOrdOpFunctionalLocation _MaintOrdOpFunctionalLocation
_MaintOrdOpFuncLocCategory _MaintOrdOpFuncLocCategory
_OpCostCenterActivityType _OpCostCenterActivityType
_OperationNotification _OperationNotification

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 R_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 R_MaintenanceJobPackageTP AS
SELECT
  MaintenanceJobPackageUUID,
  MaintenanceJobPackageBuildUUID,
  MaintenanceJobPackage,
  MaintenanceJobPackageName,
  _MaintJobPackageStatus.MaintJobPckgOutputStatus AS MaintJobPckgOutputStatus,
  MaintenanceOrder,
  MaintenanceOrderType,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  MaintenancePlant,
  PlantSection,
  ABCIndicator,
  Equipment,
  EquipmentCategory,
  FunctionalLocation,
  FunctionalLocationCategory,
  MainWorkCenterInternalID,
  MainWorkCenter,
  MainWorkCenterTypeCode,
  MainWorkCenterPlant,
  Assembly,
  WBSElementInternalID,
  ProjectInternalID,
  MaintenanceRevision,
  ResponsibleCostCenter,
  ControllingArea,
  MaintOrdPersonResponsible,
  MaintenanceActivityType,
  OrderSystemCondition,
  MaintPriority,
  MaintPriorityType,
  MaintOrdBasicStartDate,
  MaintOrdBasicEndDate,
  LatestAcceptableCompletionDate,
  MaintenancePlan,
  MaintenanceItem,
  MaintOrdProcessPhaseCode,
  MaintOrdProcessSubPhaseCode,
  BusinessArea,
  OperationWorkCenterInternalID,
  OperationControlKey,
  CostCtrActivityType,
  OperationPersonResponsible,
  cast('' as eams_person_responsible_name) AS OperationPersonRespName,
  OperationSystemCondition,
  OperationPurgInfoRecdSearchTxt,
  MaintOperationExecStageCode,
  MaintOrdOpProcessPhaseCode,
  MaintOrdOpProcessSubPhaseCode,
  OpErlstSchedldExecStrtDte,
  OpErlstSchedldExecEndDte,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecEndDte,
  OpActualExecutionStartDate,
  OpActualExecutionEndDate,
  OperationEquipment,
  MaintJobPckgOpsEquipCategory,
  OperationFunctionalLocation,
  MaintJobPckgOpsFuncLocCategory,
  OperationMaintenanceNotif,
  CreationDateTime,
  CreatedByUser,
  cast('' as eams_person_responsible_name ) AS CreatedByUserName,
  LastChangeDateTime,
  LastChangedByUser,
  cast('' as eams_person_responsible_name ) AS LastChangedByUserName
FROM I_MaintenanceJobPackage
LEFT OUTER JOIN R_MaintJobPackageOperationTP AS _MaintJobPackageOperationTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More