Which CDS Views use I_MAINTENANCEORDER?

I_MAINTENANCEORDER is used by 71 CDS view(s), including: C_MaintOrderForSafetyInsights, C_MaintOrderOutputParamDetn, C_RSHOrderActiveUserStatus, C_RSHOrderDetails, C_RSHOrdersKPI, C_RunOverheadMaintenanceOrder, C_RunSettlmtActlMaintOrder, C_TechObjMaintenanceOrder, C_TechObjMaintenanceOrder, C_WorkPermitOrderValueHelp.

How many fields does I_MAINTENANCEORDER have?

I_MAINTENANCEORDER has 97 fields. Key fields: MaintenanceOrder, MaintenanceOrderInternalID, MaintOrderRoutingNumber.

I_MAINTENANCEORDER

CDS View

97 Fields 71 CDS Views

Maintenance Order

I_MAINTENANCEORDER is a CDS View in S/4HANA. Maintenance Order. It contains 97 fields. 71 CDS views read from this table.

CDS Views using this table (71)

View	Type	Join	VDM	Description
C_MaintOrderForSafetyInsights	view	from	CONSUMPTION	Maintenance Orders for Safety Insights
C_MaintOrderOutputParamDetn	view	from	CONSUMPTION	Maintenance Order Output Management Parameter Determination
C_RSHOrderActiveUserStatus	view	inner	CONSUMPTION	Maintenance order active status
C_RSHOrderDetails	view	from	CONSUMPTION	Maintenance order long text details
C_RSHOrdersKPI	view	from	CONSUMPTION	Maintenance Orders KPIs
C_RunOverheadMaintenanceOrder	view	from	CONSUMPTION	Overhead Calculation Maintenance Order
C_RunSettlmtActlMaintOrder	view	from	CONSUMPTION	Actual Settlement Maintenance Order
C_TechObjMaintenanceOrder	view	from	CONSUMPTION	Maintenance Orders for Technical Object
C_TechObjMaintenanceOrder	view	union_all	CONSUMPTION	Maintenance Orders for Technical Object
C_WorkPermitOrderValueHelp	view	from	CONSUMPTION	Maintenance Orders in Work Permit
CRMS4_IU_I_UMO	view_entity	from		Utilities Maintenance Order
FINOC_RULE_ORD_DEFAULT	view	inner		Orgl Change-Rule: Order Default Implmt.
FSM_I_MaintenanceOrder	view_entity	from	TRANSACTIONAL	FSM Maintenance Order
I_DFS_MaintenanceOrderTechSts	view	from	COMPOSITE	Interface view for Tech Status of Order
I_FldLogsMaintenanceOrderVH	view	from	COMPOSITE	List of Maintenance Order for Field Logistics
I_MaintenanceOrderDEX	view_entity	from	COMPOSITE	Maintenance Order Data
I_MaintenanceOrderPartner	view	from	COMPOSITE	Maintenance Order Partners
I_MaintenanceOrderPhaseControl	view	from	COMPOSITE	Maintenance Order Phase Controls
I_MaintenanceOrderStdVH	view	from	COMPOSITE	Maintenance Order
I_MaintOrdChangeDocumentDEX	view_entity	inner	COMPOSITE	Maintenance Order Change Document
I_MaintOrderEmailParameter	view	from	COMPOSITE	Email Parameters for Maintenance Order
I_MaintOrderInspectionLot	view	from	COMPOSITE	Maintenance Order Inspection Lot
I_MaintOrderOpPhaseControl	view	inner	COMPOSITE	Maintenance Order Op Phase Controls
I_MaintOrderPhseCtrlChgHist	view	from	COMPOSITE	Order Phase Control last change history
I_MaintOrderTechObj	view	from	COMPOSITE	Maintenance Order w/ Technical Object
I_MaintOrderTechObjCube	view	from	COMPOSITE	Maintenance Order With Tech Object - Cube
I_MaintOrdToNotifAssignmentVH	view_entity	from	COMPOSITE	Maintenance Order
I_OpenMaintOrderForTechObject	view	from	COMPOSITE	Open Maintainance Orders for Technical Object
I_OpenMaintOrderForTechObject	view	inner	COMPOSITE	Open Maintainance Orders for Technical Object
I_ProjectAssignedOrderVH	view	from	COMPOSITE	Maintenance and Production Orders
I_RSHOrder	view	from	COMPOSITE	Maintenance Orders
P_EBRRSrvDocMonMaintOrd	view_entity	from	COMPOSITE
P_EventBasedOverheadOrderVH	view	union	COMPOSITE	Order details
P_InhReprItmNrOfOpnMaintOrd	view	inner	COMPOSITE
P_MaintBacklogNonStkCompUnion	view	union_all	CONSUMPTION	Maintenance Backlog Non Stock Component Union
P_MaintBacklogServiceUnion	view	union_all	CONSUMPTION
P_MaintenanceJobAndWorkItem	view	union_all	COMPOSITE
P_MaintOrdConfOrderStatus	view	from	CONSUMPTION
P_MaintOrdEnhcdObjectListItem	view_entity	union_all	COMPOSITE
P_MAINTORDERBASICDATA	view	from	COMPOSITE
P_MaintOrderCompletionStatus	view	from	CONSUMPTION
P_MaintOrderForComplPreAggr	view	from	CONSUMPTION
P_MaintOrderSearch	view	from	BASIC
P_MaintOrdersForPlanningC	view	from	COMPOSITE
P_MaintOrdNonStkCompFromPurOrd	view	inner	CONSUMPTION
P_MaintOrdNoOfCheckList	view_entity	from	CONSUMPTION	Number of Checklists Assigned to Order
P_MaintPlngBcktOrder	view	from	CONSUMPTION
P_MaintPlngBucketMaintOrdBasic	view	from	CONSUMPTION
P_OverdueMaintenanceOrderC	view	from	COMPOSITE
P_PROJCMTMTBUDGETLINEITMS	view	inner	COMPOSITE	Project Budget Commitment
P_ProjectObject	view	union	COMPOSITE
P_ProjectObject_2	view	union_all	COMPOSITE	Project Object
P_ProjPlnBudgetLineItms	view	inner	COMPOSITE
P_RSHDueOperForKPIDetails	view	from	CONSUMPTION	Past Order Operation KPI Details
P_RSHExOpsForScheduling	view	inner	CONSUMPTION
P_RSHMaintAssetBoard	view	from	CONSUMPTION	Maintenance Asset Board
P_RSHMaintAssetBoardShapes	view	from	CONSUMPTION	Maintenance asset board shapes
P_RSHMaintAssetBoardShapes	view	inner	CONSUMPTION	Maintenance asset board shapes
P_RSHMaintCallOrderProcStatus	view	from	CONSUMPTION	Processing Status for Maint. Call Orders
P_RSHOperationsForKPI	view	inner	CONSUMPTION	Operations and Sub Operations for overview page
P_RSHOperationsForKPIDetails	view	from	CONSUMPTION	Order KPI Details
P_RSHOperationsForUtilization	view	inner	CONSUMPTION	Operations and Sub Operations for utilization
P_RSHOrderProcessingStatus	view	from	CONSUMPTION	Processing Status for Orders
P_RSHPastOperForKPIDetails	view	from	CONSUMPTION	Past Order Operation KPI Details
P_RunOverheadOrder	view	from	COMPOSITE
P_RunSettlementActualOrder	view	from	COMPOSITE
P_SettlementSender	view	union_all	CONSUMPTION
P_WBSOrders	view	union_all	COMPOSITE
R_InhRepairItmNrOfOpnMaintOrds	view_entity	inner	COMPOSITE	Number of open Maintenance Orders
R_MaintenanceJobTP	view_entity	from	COMPOSITE	Maintenance Order TP
R_MaintenanceOrderTP	view_entity	from	COMPOSITE	Maintenance Order TP

Fields (97)

Key	Field	CDS Fields	Used in Views
KEY	MaintenanceOrder	MaintenanceOrder	25
KEY	MaintenanceOrderInternalID	MaintAssetBoardRowObjID,MaintAssetBoardShapeID,MaintenanceOrderInternalID,objnr,StatusObject	11
KEY	MaintOrderRoutingNumber	MaintOrderRoutingNumber	6
	_Assembly	_Assembly	2
	_BusinessArea	_BusinessArea	1
	_CompanyCode	_CompanyCode	1
	_ControllingArea	_ControllingArea	1
	_CreatedByUser	_CreatedByUser	1
	_Equipment	_Equipment	4
	_LocationAccountAssignment	_LocationAccountAssignment	5
	_MaintenanceActivityType	_MaintenanceActivityType	2
	_MaintenanceItem	_MaintenanceItem	2
	_MaintenanceNotification	_MaintenanceNotification	2
	_MaintenanceOrderCategory	_MaintenanceOrderCategory	2
	_MaintenanceOrderComponent	_MaintenanceOrderComponent	1
	_MaintenanceOrderPhase	_MaintenanceOrderPhase	1
	_MaintenanceOrderType	_MaintenanceOrderType	3
	_MaintenancePlan	_MaintenancePlan	2
	_MaintenancePlannerGroup	_MaintenancePlannerGroup	2
	_MaintenancePlanningPlant	_MaintenancePlanningPlant	2
	_MaintenancePlanPlant	_MaintenancePlanPlant	1
	_MaintenancePriority	_MaintenancePriority	1
	_MaintenancePriorityType	_MaintenancePriorityType	1
	_MaintenanceRevision	_MaintenanceRevision	1
	_MaintenanceTaskList	_MaintenanceTaskList	1
	_MaintOrderHasOpenMainWork	_MaintOrderHasOpenMainWork	1
	_MaintOrdPlngDegreeCode	_MaintOrdPlngDegreeCode	1
	_MainWorkCenter	_MainWorkCenter	2
	_OperationSystemCondition	_OperationSystemCondition	1
	_Order	_Order	1
	_OrderHasLongText	_OrderHasLongText	1
	_OrderItem	_OrderItem	1
	_ResponsibleCostCenter	_ResponsibleCostCenter	1
	_StatusObject	_StatusObject	1
	_StatusObjectStatus	_StatusObjectStatus	1
	AdditionalDeviceData	AdditionalDeviceData	1
	Assembly	Assembly	2
	BasicSchedulingType	BasicSchedulingType	1
	BusinessArea	BusinessArea	1
	CompanyCode	CompanyCode	2
	ControllingArea	ControllingArea	3
	CreatedByUser	CreatedByUser	1
	CreationDate	CreationDate	2
	CreationTime	CreationTime	2
	Currency	Currency	1
	DfsMaintOrderObjectNmbr	DfsMaintOrderObjectNmbr	1
	DfsMaintSuperordinateEquipNmbr	DfsMaintSuperordinateEquipNmbr	1
	Equipment	Equipment	14
	FunctionalArea	FunctionalArea	1
	LastChangeDateTime	LastChangeDateTime	1
	LatestAcceptableCompletionDate	LatestAcceptableCompletionDate	5
	MaintenanceActivityType	MaintenanceActivityType	6
	MaintenanceItem	MaintenanceItem	2
	MaintenanceNotification	MaintenanceNotification	3
	MaintenanceOrderCategory	autyp,MaintenanceOrderCategory	6
	MaintenanceOrderDesc	MaintenanceOrderDesc	11
	MaintenanceOrderPlanningCode	MaintenanceOrderPlanningCode	2
	MaintenanceOrderType	MaintenanceOrderType	20
	MaintenancePlan	MaintenancePlan	2
	MaintenancePlannerGroup	MaintenancePlannerGroup	15
	MaintenancePlanningPlant	MaintenancePlanningPlant	16
	MaintenancePlant	MaintenancePlant	3
	MaintenanceProcessingPhase	MaintenanceProcessingPhase	7
	MaintenanceRevision	MaintenanceEvent,MaintenanceRevision	7
	MaintObjectLocAcctAssgmtNmbr	MaintObjectLocAcctAssgmtNmbr	14
	MaintOrdBasicEndDate	EndDate,MaintOrdBasicEndDate	6
	MaintOrdBasicEndTime	MaintOrdBasicEndTime	4
	MaintOrdBasicStartDate	MaintOrdBasicStartDate,StartDate	6
	MaintOrdBasicStartTime	MaintOrdBasicStartTime	4
	MaintOrderProcessingContext	MaintOrderProcessingContext	1
	MaintOrderReferenceDate	MaintOrderReferenceDate	2
	MaintOrderReferenceTime	MaintOrderReferenceTime	1
	MaintOrdPersonResponsible	MaintOrdPersonResponsible,PersonResponsible	2
	MaintOrdProcessPhaseCode	MaintOrdProcessPhaseCode	4
	MaintOrdProcessSubPhaseCode	MaintOrdProcessSubPhaseCode	1
	MaintPriority	MaintPriority	9
	MaintPriorityType	MaintPriorityType	7
	MainWorkCenter	MaintOrdMainWorkCenter,MainWorkCenter	6
	MainWorkCenterPlant	MaintOrdMainWorkCenterPlant,MainWorkCenterPlant	3
	Material	Material	1
	OperationSystemCondition	OperationSystemCondition	3
	OrderHasLongText	OrderHasLongText	1
	OrdIsNotSchedldAutomatically	OrdIsNotSchedldAutomatically	1
	PrevLtstAccptblCompletionDate	PrevLtstAccptblCompletionDate	1
	ReferenceElement	ReferenceElement	2
	ResponsibleCostCenter	ResponsibleCostCenter,srce_kostl	2
	ScheduledBasicEndDate	ScheduledBasicEndDate	4
	ScheduledBasicEndTime	ScheduledBasicEndTime	4
	ScheduledBasicStartDate	ScheduledBasicStartDate	4
	ScheduledBasicStartTime	ScheduledBasicStartTime	4
	SerialNumber	SerialNumber	3
	TaskListGroup	TaskListGroup	1
	TaskListGroupCounter	TaskListGroupCounter	1
	TaskListType	TaskListType	1
	WBSElementInternalID	WBSElementInternalID	1
	WorkCenterInternalID	MainWorkCenterInternalID,WorkCenterInternalID	6
	WorkCenterTypeCode	WorkCenterTypeCode	4

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Maintenance Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTENANCEORDER (
    MAINTENANCEORDER,
    MAINTENANCEORDERINTERNALID,
    MAINTORDERROUTINGNUMBER,
    _ASSEMBLY,
    _BUSINESSAREA,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _CREATEDBYUSER,
    _EQUIPMENT,
    _LOCATIONACCOUNTASSIGNMENT,
    _MAINTENANCEACTIVITYTYPE,
    _MAINTENANCEITEM,
    _MAINTENANCENOTIFICATION,
    _MAINTENANCEORDERCATEGORY,
    _MAINTENANCEORDERCOMPONENT,
    _MAINTENANCEORDERPHASE,
    _MAINTENANCEORDERTYPE,
    _MAINTENANCEPLAN,
    _MAINTENANCEPLANNERGROUP,
    _MAINTENANCEPLANNINGPLANT,
    _MAINTENANCEPLANPLANT,
    _MAINTENANCEPRIORITY,
    _MAINTENANCEPRIORITYTYPE,
    _MAINTENANCEREVISION,
    _MAINTENANCETASKLIST,
    _MAINTORDERHASOPENMAINWORK,
    _MAINTORDPLNGDEGREECODE,
    _MAINWORKCENTER,
    _OPERATIONSYSTEMCONDITION,
    _ORDER,
    _ORDERHASLONGTEXT,
    _ORDERITEM,
    _RESPONSIBLECOSTCENTER,
    _STATUSOBJECT,
    _STATUSOBJECTSTATUS,
    ADDITIONALDEVICEDATA,
    ASSEMBLY,
    BASICSCHEDULINGTYPE,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CURRENCY,
    DFSMAINTORDEROBJECTNMBR,
    DFSMAINTSUPERORDINATEEQUIPNMBR,
    EQUIPMENT,
    FUNCTIONALAREA,
    LASTCHANGEDATETIME,
    LATESTACCEPTABLECOMPLETIONDATE,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEITEM,
    MAINTENANCENOTIFICATION,
    MAINTENANCEORDERCATEGORY,
    MAINTENANCEORDERDESC,
    MAINTENANCEORDERPLANNINGCODE,
    MAINTENANCEORDERTYPE,
    MAINTENANCEPLAN,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEPLANT,
    MAINTENANCEPROCESSINGPHASE,
    MAINTENANCEREVISION,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MAINTORDBASICENDDATE,
    MAINTORDBASICENDTIME,
    MAINTORDBASICSTARTDATE,
    MAINTORDBASICSTARTTIME,
    MAINTORDERPROCESSINGCONTEXT,
    MAINTORDERREFERENCEDATE,
    MAINTORDERREFERENCETIME,
    MAINTORDPERSONRESPONSIBLE,
    MAINTORDPROCESSPHASECODE,
    MAINTORDPROCESSSUBPHASECODE,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    MAINWORKCENTER,
    MAINWORKCENTERPLANT,
    MATERIAL,
    OPERATIONSYSTEMCONDITION,
    ORDERHASLONGTEXT,
    ORDISNOTSCHEDLDAUTOMATICALLY,
    PREVLTSTACCPTBLCOMPLETIONDATE,
    REFERENCEELEMENT,
    RESPONSIBLECOSTCENTER,
    SCHEDULEDBASICENDDATE,
    SCHEDULEDBASICENDTIME,
    SCHEDULEDBASICSTARTDATE,
    SCHEDULEDBASICSTARTTIME,
    SERIALNUMBER,
    TASKLISTGROUP,
    TASKLISTGROUPCOUNTER,
    TASKLISTTYPE,
    WBSELEMENTINTERNALID,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (MAINTENANCEORDER, MAINTENANCEORDERINTERNALID, MAINTORDERROUTINGNUMBER)
);

Depth:

I_MAINTENANCEORDER

CDS Views using this table (71)

Fields (97)

Learn More