I_MAINTORDEROPERANDSUBOPER

CDS View
27 Fields 21 CDS Views

Maintenance Order Operation and Suboperation

I_MAINTORDEROPERANDSUBOPER is a CDS View in S/4HANA. Maintenance Order Operation and Suboperation. It contains 27 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
C_MaintenanceJobWorkItem view from CONSUMPTION Maintenance Job
C_MaintJobPckgBuildOperations view from CONSUMPTION Operation to Assign to Work Pack
C_MaintOrdOperationQuickVw view from CONSUMPTION
C_MalfunctionReportMyWorkItems view from CONSUMPTION Repair Malfunction: My work items
C_RSHOperationDetails view from CONSUMPTION maintenance order operation long text
C_RSHOperationValidation view from CONSUMPTION Message for operation list
I_MaintOrderOperationData view from COMPOSITE Maintenance Order Operation Data
I_MaintOrderOperationLongText view inner BASIC Maintenance Order Operation Long Text
I_MaintOrderOpPhaseControl view from COMPOSITE Maintenance Order Op Phase Controls
I_MaintOrderOpPhseCtrlChgHist view from COMPOSITE Order Operation Phase Control last change history
I_MaintOrderOpRqmtAssgmt view_entity inner BASIC Maint Order Op Requirement Assignment
I_MaintOrdOpNotification view_entity from COMPOSITE Maintenance Order operation notifications
P_MaintJobPckgOperations view from COMPOSITE
P_MaintJobPckgOrdOpDataForGrpg view from COMPOSITE
P_RSHExOpsForScheduling view from CONSUMPTION
P_RSHOperationDurationInSecond view from CONSUMPTION Maintenance Operations with Durations in Seconds
P_RSHOperationsForKPI view from CONSUMPTION Operations and Sub Operations for overview page
P_RSHOperationsForUtilization view from CONSUMPTION Operations and Sub Operations for utilization
P_RSHOperationsPerWorkcenter view inner CONSUMPTION Operations on Workcenters for certain time frame
P_RSHSmltdOpInSeconds view inner CONSUMPTION
R_MaintenanceOrderOperationTP view_entity from TRANSACTIONAL Maintenance Order Operation TP

Fields (27)

KeyField CDS FieldsUsed in Views
KEY MaintenanceOrder MaintenanceOrder 14
KEY MaintenanceOrderOperation MaintenanceOrderOperation 9
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation 8
KEY MaintOrderOperationCounter MaintOrderOperationCounter 5
KEY MaintOrderRoutingNumber MaintOrderRoutingNumber 4
_MaintenanceOrder _MaintenanceOrder 3
_PersonResponsible _PersonResponsible 2
_Supplier _Supplier 1
_WorkCenter _WorkCenter 1
CapacityRequirement CapacityRequirement 1
CostCtrActivityType CostCtrActivityType 2
Equipment Equipment,OperationEquipment 2
MaintOperationalChecklistType MaintOperationalChecklistType 1
MaintOperationExecStageCode MaintOperationExecStageCode 5
MaintOrderOperationInternalID MaintOrderOperationInternalID 3
MaintOrdOpProcessPhaseCode MaintOrdOpProcessPhaseCode 2
MaintOrdOpProcessSubPhaseCode MaintOrdOpProcessSubPhaseCode 4
NumberOfCapacities NumberOfCapacities 2
OperationControlKey OperationControlKey 5
OperationDescription OperationDescription 3
OperationPersonResponsible OperationPersonResponsible 7
OperationPurgInfoRecdSearchTxt OperationPurgInfoRecdSearchTxt 1
OperationSupplier OperationSupplier 1
OperationSystemCondition OperationSystemCondition 1
OperationWorkCenterInternalID OperationWorkCenterInternalID,WorkCenterInternalID 6
OperationWorkCenterTypeCode OperationWorkCenterTypeCode,WorkCenterTypeCode 4
Plant Plant 6

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 Operation and Suboperation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTORDEROPERANDSUBOPER (
    MAINTENANCEORDER,
    MAINTENANCEORDEROPERATION,
    MAINTENANCEORDERSUBOPERATION,
    MAINTORDEROPERATIONCOUNTER,
    MAINTORDERROUTINGNUMBER,
    _MAINTENANCEORDER,
    _PERSONRESPONSIBLE,
    _SUPPLIER,
    _WORKCENTER,
    CAPACITYREQUIREMENT,
    COSTCTRACTIVITYTYPE,
    EQUIPMENT,
    MAINTOPERATIONALCHECKLISTTYPE,
    MAINTOPERATIONEXECSTAGECODE,
    MAINTORDEROPERATIONINTERNALID,
    MAINTORDOPPROCESSPHASECODE,
    MAINTORDOPPROCESSSUBPHASECODE,
    NUMBEROFCAPACITIES,
    OPERATIONCONTROLKEY,
    OPERATIONDESCRIPTION,
    OPERATIONPERSONRESPONSIBLE,
    OPERATIONPURGINFORECDSEARCHTXT,
    OPERATIONSUPPLIER,
    OPERATIONSYSTEMCONDITION,
    OPERATIONWORKCENTERINTERNALID,
    OPERATIONWORKCENTERTYPECODE,
    PLANT,
    PRIMARY KEY (MAINTENANCEORDER, MAINTENANCEORDEROPERATION, MAINTENANCEORDERSUBOPERATION, MAINTORDEROPERATIONCOUNTER, MAINTORDERROUTINGNUMBER)
);

Learn More