_MAINTENANCEORDER

68 Fields

_MAINTENANCEORDER is an SAP database table in S/4HANA. It contains 68 fields.

Fields (68)

KeyField CDS FieldsUsed in Views
KEY MaintenanceOrder MaintenanceOrder 7
_EAMProcessPhase _MaintOrdProcessPhase 1
_EAMProcessSubPhase _MaintOrdProcessSubPhase 1
_Equipment _Equipment 4
_LocationAccountAssignment _LocationAccountAssignment 4
_MaintenanceOrderPhase _MaintenanceOrderPhase 1
_MaintenanceOrderType _MaintenanceOrderType 2
_MaintenancePlannerGroup _MaintenancePlannerGroup 1
_MaintenancePlanningPlant _MaintenancePlanningPlant 2
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc 1
Assembly Assembly 4
BusinessArea BusinessArea 1
ControllingArea ControllingArea 7
CreatedByUser CreatedByUser 4
CreationDate CreationDate 4
DfsMaintOrderObjectNmbr DfsMaintOrderObjectNmbr 1
Equipment Equipment 15
FunctionalLocation FunctionalLocation 1
LastChangeDateTime LastChangeDateTime 4
LatestAcceptableCompletionDate LatestAcceptableCompletionDate 3
MaintenanceActivityType ActivityType,MaintenanceActivityType 6
MaintenanceItem MaintenanceItem 3
MaintenanceNotification MaintenanceNotification 2
MaintenanceOrderCategory OrderCategory 1
MaintenanceOrderDesc MaintenanceOrderDesc 19
MaintenanceOrderInternalID MaintenanceOrderInternalID 4
MaintenanceOrderType MaintenanceOrderType,OrderType 27
MaintenancePlan MaintenancePlan 5
MaintenancePlannerGroup MaintenancePlannerGroup 20
MaintenancePlanningPlant MaintenancePlanningPlant 20
MaintenancePlant MaintenancePlant 10
MaintenanceProcessingPhase MaintenanceProcessingPhase 7
MaintenanceRevision MaintenanceRevision 8
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr 9
MaintOrdBasicEndDate BasicEndDate,MaintOrdBasicEndDate,OrderPlannedEndDate 10
MaintOrdBasicEndTime MaintOrdBasicEndTime 4
MaintOrdBasicStartDate BasicStartDate,MaintOrdBasicStartDate,PlannedStartDate 11
MaintOrdBasicStartTime MaintOrdBasicStartTime 4
MaintOrderProcessingContext MaintOrderProcessingContext 2
MaintOrderRoutingNumber MaintOrderRoutingNumber 2
MaintOrdPersonResponsible MaintOrdPersonResponsible 1
MaintOrdProcessPhaseCode MaintOrdProcessPhaseCode 10
MaintOrdProcessSubPhaseCode MaintOrdProcessSubPhaseCode 7
MaintPriority FldLogsSuplrItemPriorityCode,MaintPriority,MaintPriorityType,Priority,PriorityCode 9
MaintPriorityType MaintPriorityType 5
MainWorkCenter MainWorkCenter 11
MainWorkCenterPlant MainWorkCenterPlant 7
MatlCompIsMarkedForDeletion IsDeleted 1
OperationSystemCondition OrderSystemCondition 1
OrderDescription OrderDescription 1
OrderType OrderType 1
PrevLtstAccptblCompletionDate PrevLtstAccptblCompletionDate 2
ResponsibleCostCenter ResponsibleCostCenter 4
ScheduledBasicEndDate ScheduledBasicEndDate 7
ScheduledBasicEndTime ScheduledBasicEndTime 4
ScheduledBasicStartDate ScheduledBasicStartDate 5
ScheduledBasicStartTime ScheduledBasicStartTime 4
SerialNumber SerialNumber 1
ServiceDocument ServiceDocument 1
ServiceDocumentItem ServiceDocumentItem 1
ServiceDocumentType ServiceDocumentType 1
TaskListGroup TaskListGroup 1
TaskListGroupCounter TaskListGroupCounter 1
TaskListType TaskListType 1
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc 2
WBSElementInternalID WBSElementInternalID 3
WorkCenterInternalID MainWorkCenterInternalID,WorkCenterInternalID 7
WorkCenterTypeCode MainWorkCenterTypeCode,WorkCenterTypeCode 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _MAINTENANCEORDER (
    MAINTENANCEORDER,
    _EAMPROCESSPHASE,
    _EAMPROCESSSUBPHASE,
    _EQUIPMENT,
    _LOCATIONACCOUNTASSIGNMENT,
    _MAINTENANCEORDERPHASE,
    _MAINTENANCEORDERTYPE,
    _MAINTENANCEPLANNERGROUP,
    _MAINTENANCEPLANNINGPLANT,
    _TECHOBJISEQUIPORFUNCNLLOC,
    ASSEMBLY,
    BUSINESSAREA,
    CONTROLLINGAREA,
    CREATEDBYUSER,
    CREATIONDATE,
    DFSMAINTORDEROBJECTNMBR,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    LASTCHANGEDATETIME,
    LATESTACCEPTABLECOMPLETIONDATE,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEITEM,
    MAINTENANCENOTIFICATION,
    MAINTENANCEORDERCATEGORY,
    MAINTENANCEORDERDESC,
    MAINTENANCEORDERINTERNALID,
    MAINTENANCEORDERTYPE,
    MAINTENANCEPLAN,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEPLANT,
    MAINTENANCEPROCESSINGPHASE,
    MAINTENANCEREVISION,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MAINTORDBASICENDDATE,
    MAINTORDBASICENDTIME,
    MAINTORDBASICSTARTDATE,
    MAINTORDBASICSTARTTIME,
    MAINTORDERPROCESSINGCONTEXT,
    MAINTORDERROUTINGNUMBER,
    MAINTORDPERSONRESPONSIBLE,
    MAINTORDPROCESSPHASECODE,
    MAINTORDPROCESSSUBPHASECODE,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    MAINWORKCENTER,
    MAINWORKCENTERPLANT,
    MATLCOMPISMARKEDFORDELETION,
    OPERATIONSYSTEMCONDITION,
    ORDERDESCRIPTION,
    ORDERTYPE,
    PREVLTSTACCPTBLCOMPLETIONDATE,
    RESPONSIBLECOSTCENTER,
    SCHEDULEDBASICENDDATE,
    SCHEDULEDBASICENDTIME,
    SCHEDULEDBASICSTARTDATE,
    SCHEDULEDBASICSTARTTIME,
    SERIALNUMBER,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    TASKLISTGROUP,
    TASKLISTGROUPCOUNTER,
    TASKLISTTYPE,
    TECHOBJISEQUIPORFUNCNLLOC,
    WBSELEMENTINTERNALID,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (MAINTENANCEORDER)
);

Learn More