What is C_MaintWrkReqAndOrdForPlanning in SAP S/4HANA?

C_MaintWrkReqAndOrdForPlanning is a consumption CDS view in SAP S/4HANA. Maintenance Notification and Order View It contains 159 fields.

Which tables does C_MaintWrkReqAndOrdForPlanning read from?

C_MaintWrkReqAndOrdForPlanning reads data from: R_MaintWorkRequestAndOrderTP.

What VDM layer is C_MaintWrkReqAndOrdForPlanning?

C_MaintWrkReqAndOrdForPlanning is classified as a Consumption view optimized for specific business scenarios and reporting.

C_MaintWrkReqAndOrdForPlanning

DDL: C_MAINTWRKREQANDORDFORPLANNING Type: view_entity CONSUMPTION

159 Fields 1 Data Sources 6 Associations 1 OData Services 1 Fiori Apps

Maintenance Notification and Order View

C_MaintWrkReqAndOrdForPlanning is a Consumption CDS View that provides data about "Maintenance Notification and Order View" in SAP S/4HANA. It reads from 1 data source (R_MaintWorkRequestAndOrderTP) and exposes 159 fields with key fields MaintExecutionObject, MaintExecutionObjectType. It has 6 associations to related views. It is exposed through 1 OData service (UI_MAINTWRKREQ_ORD_MANAGE). It is used in 1 Fiori application: Manage Maintenance Notifications and Orders.

Data Sources (1)

Source	Alias	Join Type
R_MaintWorkRequestAndOrderTP	R_MaintWorkRequestAndOrderTP	projection

Associations (6)

Cardinality	Target	Alias	Condition
[0..1]	I_MaintExecutionObjectType	_MaintExecutionObjectType	`_MaintExecutionObjectType.MaintExecutionObjectType = $projection.MaintExecutionObjectType`
[0..*]	C_MaintOrdSettlementRule_F4604	_MaintOrdSettlementRule	`_MaintOrdSettlementRule.ControllingObject = $projection.MaintenanceOrderInternalID`
[0..*]	C_MaintOrdSettlementRule_F4604	_MaintOrdSettlementRuleOrder	`_MaintOrdSettlementRuleOrder.ControllingObject = $projection.MaintenanceOrderInternalID and _MaintOrdSettlementRuleOrder.AccountAssignmentType = 'OR'`
[0..*]	C_MaintOrdSettlementRule_F4604	_MaintOrdSettlementRuleAsset	`_MaintOrdSettlementRuleAsset.ControllingObject = $projection.MaintenanceOrderInternalID and _MaintOrdSettlementRuleAsset.AccountAssignmentType = 'AN'`
[0..*]	C_MaintOrdSettlementRule_F4604	_MaintOrdSettlementRuleCost	`_MaintOrdSettlementRuleCost.ControllingObject = $projection.MaintenanceOrderInternalID and _MaintOrdSettlementRuleCost.AccountAssignmentType = 'KS'`
[0..*]	C_MaintOrdSettlementRule_F4604	_MaintOrdSettlementRuleWBS	`_MaintOrdSettlementRuleWBS.ControllingObject = $projection.MaintenanceOrderInternalID and _MaintOrdSettlementRuleWBS.AccountAssignmentType = 'PR'`

Annotations (13)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Maintenance Notification and Order View	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XXL	view
Search.searchable	true	view
ObjectModel.representativeKey	MaintExecutionObject	view
Metadata.ignorePropagatedAnnotations	true	view
UI.headerInfo.typeName	Maintenance Notification and Order	view
UI.headerInfo.typeNamePlural	Maintenance Notifications and Orders	view
UI.headerInfo.title.value	MaintExecutionObject	view
UI.headerInfo.title.type	#STANDARD	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_MAINTWRKREQ_ORD_MANAGE	UI_MAINTWRKREQ_ORD_MANAGE	V2	C1	NOT_RELEASED

Fiori Apps (1)

App ID	App Name	Type	Description
F4604	Manage Maintenance Notifications and Orders	Transactional	An app to manage accepted maintenance notifications and orders. Using this app, you can create maintenance orders for notifications, submit the orders for approval, and release the orders.

Manage Maintenance Notifications and Orders

Business Role: Maintenance Planner

With this app, you can manage maintenance notifications and orders that are processed by phases. You can use different filter parameters to display maintenance notifications or orders with specific attributes and perform different actions on them.

Fields (159)

Key	Field	Source Table	Source Field	Description
KEY	MaintExecutionObject		MaintExecutionObject	Exec. Object
KEY	MaintExecutionObjectType		MaintExecutionObjectType	Execution Object Type
	MaintExecutionObjectTypeDesc		MaintExecutionObjectTypeDesc	Execution Object Type
	DocumentText		DocumentText	Text ID
	NotificationType		NotificationType	Notifictn Type
	NotificationTypeNamelocalized
	MaintPriority		MaintPriority	Priority
	MaintPriorityType		MaintPriorityType	PriorityType
	MaintPriorityColorCode	_MaintenancePriority	MaintPriorityColorCode
	MaintPriorityDesclocalized
	TechObjIsEquipOrFuncnlLoc		TechObjIsEquipOrFuncnlLoc	Technical Object Type
	FunctionalLocationName		FunctionalLocationName	Functional Location
	FunctionalLocationLabelName		FunctionalLocationLabelName	Functional Loc.
	FunctionalLocation		FunctionalLocation	Object ID
	SuperiorTechnicalObjectName		SuperiorTechnicalObjectName
	TechnicalObject		TechnicalObject	Technical Object
	TechnicalObjectLabel		TechnicalObjectLabel	Tech. Object
	TechnicalObjectDescription		TechnicalObjectDescription	Technical Object Description
	MaintenanceItem		MaintenanceItem	MaintItem
	MaintenanceItemDescription		MaintenanceItemDescription	MaintItem text
	MainWorkCenter		MainWorkCenter	Work Center
	ProductionResourceTextlocalized
	MaintenancePlanningPlant		MaintenancePlanningPlant	Planning Plant
	MaintenancePlanningPlantName		MaintenancePlanningPlantName	Plant Name
	MainWorkCenterPlant		MaintenanceWorkCenterPlant	Work Ctr Plant
	MaintenancePlannerGroup		MaintenancePlannerGroup	Planner Group
	MaintenancePlannerGroupName		MaintenancePlannerGroupName	Planner Group Name
	MaintNotificationCode		MaintNotificationCode	Failure Mode
	InspectionCodeText		InspectionCodeText
	MaintNotificationCodeGroup		MaintNotificationCodeGroup	Failure Mode Group
	InspSpecAddlCodeGroupText		InspSpecAddlCodeGroupText
	MaintNotificationCatalog		MaintNotificationCatalog	Catalog Type
	AssetLocation		AssetLocation	Location
	LocationName		LocationName	Location Name
	AdditionalDeviceData		AdditionalDeviceData	Additional Device Data
	AssetRoom		AssetRoom	Room
	BasicSchedulingType		BasicSchedulingType	Basic Scheduling Type
	SchedulingTypeNamelocalized
	BusinessArea		BusinessArea	Business Area
	BusinessAreaName	_BusinessAreaText	BusinessAreaName	Business Area Name
	CompanyCode		CompanyCode	Company Code
	CompanyCodeName	_CompanyCodeStdVH	CompanyCodeName	Company Name
	CostCenter		CostCenter	Cost Center (Settlement Rule)
	MasterFixedAsset		MasterFixedAsset	Asset (Settlement Rule)
	FunctionalArea		FunctionalArea	Functional Area
	FunctionalAreaName	_FunctionalAreaText	FunctionalAreaName	Long Text
	LocAcctAssgmtCostCenter		LocAcctAssgmtCostCenter	Cost Center (Account Assgmt.)
	MaintenanceRevision		MaintenanceRevision	Maintenance Event/Revision
	MaintenanceRevisionDesc		MaintenanceRevisionDesc
	MaintOrdHasSettlementRules		MaintOrdHasSettlementRules	Has Settlement Rules
	OrdSettlmtWBSElementExternalID		OrdSettlmtWBSElementExternalID	WBS Element (Settlement Rule)
	ProfitCenter		ProfitCenter	Profit Center
	ProfitCenterLongName	_ProfitCenterText	ProfitCenterLongName	Profit Center Description
	ReferenceElement		ReferenceElement	Reference Element
	SettlementOrder		SettlementOrder	Settlement Order (Settlement Rule)
	LocAcctAssgmtWBSElementExtID		LocAcctAssgmtWBSElementExtID	WBS Element (Account Assgmt.)
	CreationDate		CreationDate	Time Stamp
	CreationTime		CreationTime	Time of Change
	CreationDateTime		CreationDateTime	Timestamp
	CreatedByUser		CreatedByUser	Created By
	CreatedByUserName		CreatedByUserName	Person Resp.
	MaintExecObjRequiredStartDate		MaintExecObjRequiredStartDate	Bas. Start Date
	MaintExecObjRequiredStartTime		MaintExecObjRequiredStartTime	Start time
	MaintExecObjRqdStartDateTime		MaintExecObjRqdStartDateTime	Required Start
	MaintExecObjectRequiredEndDate		MaintExecObjectRequiredEndDate	Basic fin. date
	MaintExecObjectRequiredEndTime		MaintExecObjectRequiredEndTime	Basic Fin. Time
	MaintExecObjRqdEndDateTime		MaintExecObjRqdEndDateTime	Required Finish
	LatestAcceptableCompletionDate		LatestAcceptableCompletionDate	Final Due Date
	PersonResponsible		PersonResponsible	Person Responsible
	MaintenanceOrder		MaintenanceOrder	Associated With
	MaintenanceActivityType		MaintenanceActivityType	MaintActivType
	MaintenanceActivityTypeNamelocalized
	SerialNumber		SerialNumber	Serial Number
	ResponsibleCostCenter		ResponsibleCostCenter	Responsible Cost Center
	CostCenterName	_CostCenterText	CostCenterName	Name
	OperationSystemCondition		OperationSystemCondition	SystemCondition
	OperationSystemConditionTextlocalized
	ScheduledBasicStartDate		ScheduledBasicStartDate	Scheduled Start Date
	ScheduledBasicStartTime		ScheduledBasicStartTime	Scheduled Start Time
	MaintOrdSchedBscStartDateTime		MaintOrdSchedBscStartDateTime
	MaintOrdSchedldBscEndDateTime		MaintOrdSchedldBscEndDateTime	Time Stamp
	ABCIndicator		ABCIndicator	ABC Indicator
	ABCIndicatorDesclocalized
	MaintenanceOrderType		MaintenanceOrderType	Order Type
	OrderTypeNamelocalized
	StatusProfile		StatusProfile	Status Profile
	Material		Material	Vehicle Model
	Assembly		Assembly	Pegged Reqmt
	MaterialType		MaterialType	Material Type
	Currency		Currency	Valuation Crcy
	MaintenancePlant		MaintenancePlant	Plant
	PlantName		PlantName	Plant Name
	MaintenanceProcessingPhase		MaintenanceProcessingPhase	Phase
	PlantSection		PlantSection	Plant Section
	NumberOfOrders		NumberOfOrders	Open Orders
	NmbrOfOpenMaintNotifications		NmbrOfOpenMaintNotifications	Open Notifications
	MalfunctionEffect		MalfunctionEffect	Effect
	MalfunctionEffectText		MalfunctionEffectText
	MalfunctionStartDate		MalfunctionStartDate	Malfunct. Start
	MalfunctionStartTime		MalfunctionStartTime	Mal. Start (T.)
	MalfunctionStartDateTime		MalfunctionStartDateTime	Malfunction Start
	MalfunctionEndDate		MalfunctionEndDate	Malfunct. End
	MalfunctionEndTime		MalfunctionEndTime	Malfunction End
	MalfunctionEndDateTime		MalfunctionEndDateTime	Malfunction End
	EquipmentCategory		EquipmentCategory	Equipment Category
	FunctionalLocationCategory		FunctionalLocationCategory	Functional Location Category
	SuperiorFunctionalLocation		SuperiorFunctionalLocation	Superior Functional Location
	ReportedByUser		ReportedByUser	Reported By
	ReporterFullName		ReporterFullName	Full Name
	MaintenanceObjectIsDown		MaintenanceObjectIsDown	Breakdown Flag
	Equipment		Equipment	Equipment check
	MaintObjectLocAcctAssgmtNmbr		MaintObjectLocAcctAssgmtNmbr	Loc/AccAssmt
	MaintOrdProcessPhaseCode		MaintOrdProcessPhaseCode	Phase
	MaintOrdProcessSubPhaseCode		MaintOrdProcessSubPhaseCode	Subphase
	MaintOrderProcessingContext		MaintOrderProcessingContext	Order Processing Context
	MaintOrdProcessingContextTextlocalized
	MaintNotifProcessingContext		MaintNotifProcessingContext	Notification Processing Context
	MaintNotifProcgContextTextlocalized
	EAMProcessSubPhaseCodeDesclocalized
	EAMProcessPhaseCodeDesclocalized
	curr152			Actual Cost
	curr152			Planned Cost
	curr152			Estimated Cost
	int13
	MaintPlanningBucketUUID		MaintPlanningBucketUUID	UUID
	MaintPlngBucketLabel		MaintPlngBucketLabel	Planning Bucket
	MaintenanceOrderObjectList		MaintenanceOrderObjectList	Object list
	MaintenanceNotification		MaintenanceNotification	Notification
	MaintenanceOrderInternalID		MaintenanceOrderInternalID	Object number
	WorkCenterInternalID		WorkCenterInternalID	Work Center
	WorkCenterTypeCode		WorkCenterTypeCode	Object Type
	MaintOrderRoutingNumber		MaintOrderRoutingNumber	Plan No.f.Oper.
	MaintOrdBasicStartDate		MaintOrdBasicStartDate	Bas. Start Date
	MaintOrdBasicStartTime		MaintOrdBasicStartTime
	MaintOrdBasicEndDate		MaintOrdBasicEndDate	Basic fin. date
	MaintOrdBasicEndTime		MaintOrdBasicEndTime
	ScheduledBasicEndDate		ScheduledBasicEndDate	Sched. finish
	ScheduledBasicEndTime		ScheduledBasicEndTime
	MaintExecObjectReferenceDate		MaintExecObjectReferenceDate
	MaintExecObjectReferenceTime		MaintExecObjectReferenceTime
	MaintExecObjReferenceDateTime		MaintExecObjReferenceDateTime
	NumberOfMaintenanceChecklists	_MaintOrdNrOfChecklist	NumberOfMaintenanceChecklists	Number of Checklists
	MaintenanceOrderHasChecklist		MaintenanceOrderHasChecklist
	InspectionLot		InspectionLot	Inspection Lot
	MaintChecklistTechnicalObject		MaintChecklistTechnicalObject
	_Equipment		_Equipment
	_MaintenancePriority		_MaintenancePriority
	_MaintenanceOrderType		_MaintenanceOrderType
	_MaintNotifPersonResponsible		_MaintNotifPersonResponsible
	_MaintOrdPersonResponsible		_MaintOrdPersonResponsible
	_PMNotifMaintenanceData		_PMNotifMaintenanceData
	_MaintExecutionObjectType		_MaintExecutionObjectType
	_LocationAccountAssignment		_LocationAccountAssignment
	_MaintOrdSettlementRule		_MaintOrdSettlementRule
	_MaintOrdSettlementRuleOrder		_MaintOrdSettlementRuleOrder
	_MaintOrdSettlementRuleAsset		_MaintOrdSettlementRuleAsset
	_MaintOrdSettlementRuleCost		_MaintOrdSettlementRuleCost
	_MaintOrdSettlementRuleWBS		_MaintOrdSettlementRuleWBS
	_MaintOrdChecklist		_MaintOrdChecklist

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_MaintWrkReqAndOrdForPlanning.
-- 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_MaintWrkReqAndOrdForPlanning AS
SELECT
  MaintExecutionObject,
  MaintExecutionObjectType,
  MaintExecutionObjectTypeDesc,
  DocumentText,
  NotificationType,
  _NotificationTypeName.NotificationTypeName : localized AS NotificationTypeNamelocalized,
  MaintPriority,
  MaintPriorityType,
  _MaintenancePriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  _PMNotificationPriorityText.MaintPriorityDesc : localized AS MaintPriorityDesclocalized,
  TechObjIsEquipOrFuncnlLoc,
  FunctionalLocationName,
  FunctionalLocationLabelName,
  FunctionalLocation,
  SuperiorTechnicalObjectName,
  TechnicalObject,
  TechnicalObjectLabel,
  TechnicalObjectDescription,
  MaintenanceItem,
  MaintenanceItemDescription,
  MainWorkCenter,
  _MainWorkCenterText.ProductionResourceText : localized AS ProductionResourceTextlocalized,
  MaintenancePlanningPlant,
  MaintenancePlanningPlantName,
  MaintenanceWorkCenterPlant AS MainWorkCenterPlant,
  MaintenancePlannerGroup,
  MaintenancePlannerGroupName,
  MaintNotificationCode,
  InspectionCodeText,
  MaintNotificationCodeGroup,
  InspSpecAddlCodeGroupText,
  MaintNotificationCatalog,
  AssetLocation,
  LocationName,
  AdditionalDeviceData,
  AssetRoom,
  BasicSchedulingType,
  _SchedulingTypeName.SchedulingTypeName : localized AS SchedulingTypeNamelocalized,
  BusinessArea,
  _BusinessAreaText.BusinessAreaName AS BusinessAreaName,
  CompanyCode,
  _CompanyCodeStdVH.CompanyCodeName AS CompanyCodeName,
  CostCenter,
  MasterFixedAsset,
  FunctionalArea,
  _FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  LocAcctAssgmtCostCenter,
  MaintenanceRevision,
  MaintenanceRevisionDesc,
  MaintOrdHasSettlementRules,
  OrdSettlmtWBSElementExternalID,
  ProfitCenter,
  _ProfitCenterText.ProfitCenterLongName AS ProfitCenterLongName,
  ReferenceElement,
  SettlementOrder,
  LocAcctAssgmtWBSElementExtID,
  CreationDate,
  CreationTime,
  CreationDateTime,
  CreatedByUser,
  CreatedByUserName,
  MaintExecObjRequiredStartDate,
  MaintExecObjRequiredStartTime,
  MaintExecObjRqdStartDateTime,
  MaintExecObjectRequiredEndDate,
  MaintExecObjectRequiredEndTime,
  MaintExecObjRqdEndDateTime,
  LatestAcceptableCompletionDate,
  PersonResponsible,
  MaintenanceOrder,
  MaintenanceActivityType,
  _MaintenanceActivityTypeText.MaintenanceActivityTypeName : localized AS MaintenanceActivityTypeNamelocalized,
  SerialNumber,
  ResponsibleCostCenter,
  _CostCenterText.CostCenterName AS CostCenterName,
  OperationSystemCondition,
  _OperationSystemConditionText.OperationSystemConditionText : localized AS OperationSystemConditionTextlocalized,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  MaintOrdSchedBscStartDateTime,
  MaintOrdSchedldBscEndDateTime,
  ABCIndicator,
  _ABCIndicatorText.ABCIndicatorDesc : localized AS ABCIndicatorDesclocalized,
  MaintenanceOrderType,
  _OrderTypeText.OrderTypeName : localized AS OrderTypeNamelocalized,
  StatusProfile,
  Material,
  Assembly,
  MaterialType,
  Currency,
  MaintenancePlant,
  PlantName,
  MaintenanceProcessingPhase,
  PlantSection,
  NumberOfOrders,
  NmbrOfOpenMaintNotifications,
  MalfunctionEffect,
  MalfunctionEffectText,
  MalfunctionStartDate,
  MalfunctionStartTime,
  MalfunctionStartDateTime,
  MalfunctionEndDate,
  MalfunctionEndTime,
  MalfunctionEndDateTime,
  EquipmentCategory,
  FunctionalLocationCategory,
  SuperiorFunctionalLocation,
  ReportedByUser,
  ReporterFullName,
  MaintenanceObjectIsDown,
  Equipment,
  MaintObjectLocAcctAssgmtNmbr,
  MaintOrdProcessPhaseCode,
  MaintOrdProcessSubPhaseCode,
  MaintOrderProcessingContext,
  _MaintOrdProcessingContextT.MaintOrdProcessingContextText : localized AS MaintOrdProcessingContextTextlocalized,
  MaintNotifProcessingContext,
  _MaintNotifProcgContextText.MaintNotifProcgContextText : localized AS MaintNotifProcgContextTextlocalized,
  _SubPhase._EAMProcessSubPhaseText.EAMProcessSubPhaseCodeDesc : localized AS EAMProcessSubPhaseCodeDesclocalized,
  _Phase._EAMProcessPhaseText.EAMProcessPhaseCodeDesc : localized AS EAMProcessPhaseCodeDesclocalized,
  virtual MaintOrderTotalActualCost : abap.curr( 15, 2 ) AS curr152,
  virtual NumberOfSubObjects : abap.int1(3) AS int13,
  MaintPlanningBucketUUID,
  MaintPlngBucketLabel,
  MaintenanceOrderObjectList,
  MaintenanceNotification,
  MaintenanceOrderInternalID,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  MaintOrderRoutingNumber,
  MaintOrdBasicStartDate,
  MaintOrdBasicStartTime,
  MaintOrdBasicEndDate,
  MaintOrdBasicEndTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  MaintExecObjectReferenceDate,
  MaintExecObjectReferenceTime,
  MaintExecObjReferenceDateTime,
  _MaintOrdNrOfChecklist.NumberOfMaintenanceChecklists AS NumberOfMaintenanceChecklists,
  MaintenanceOrderHasChecklist,
  InspectionLot,
  MaintChecklistTechnicalObject
FROM R_MaintWorkRequestAndOrderTP
LEFT OUTER JOIN I_MaintExecutionObjectType AS _MaintExecutionObjectType ON _MaintExecutionObjectType.MaintExecutionObjectType = MaintExecutionObjectType  -- association [0..1]
LEFT OUTER JOIN C_MaintOrdSettlementRule_F4604 AS _MaintOrdSettlementRule ON _MaintOrdSettlementRule.ControllingObject = MaintenanceOrderInternalID  -- association [0..*]
LEFT OUTER JOIN C_MaintOrdSettlementRule_F4604 AS _MaintOrdSettlementRuleOrder ON _MaintOrdSettlementRuleOrder.ControllingObject = MaintenanceOrderInternalID AND _MaintOrdSettlementRuleOrder.AccountAssignmentType = 'OR'  -- association [0..*]
LEFT OUTER JOIN C_MaintOrdSettlementRule_F4604 AS _MaintOrdSettlementRuleAsset ON _MaintOrdSettlementRuleAsset.ControllingObject = MaintenanceOrderInternalID AND _MaintOrdSettlementRuleAsset.AccountAssignmentType = 'AN'  -- association [0..*]
LEFT OUTER JOIN C_MaintOrdSettlementRule_F4604 AS _MaintOrdSettlementRuleCost ON _MaintOrdSettlementRuleCost.ControllingObject = MaintenanceOrderInternalID AND _MaintOrdSettlementRuleCost.AccountAssignmentType = 'KS'  -- association [0..*]
LEFT OUTER JOIN C_MaintOrdSettlementRule_F4604 AS _MaintOrdSettlementRuleWBS ON _MaintOrdSettlementRuleWBS.ControllingObject = MaintenanceOrderInternalID AND _MaintOrdSettlementRuleWBS.AccountAssignmentType = 'PR'  -- association [0..*]
;

Depth:

C_MaintWrkReqAndOrdForPlanning view_entity

R_MaintWorkRequestAndOrderTP view_entity