_MAINTENANCEORDER

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,
    _BUSINESSAREA,
    _EAMPROCESSPHASE,
    _EAMPROCESSSUBPHASE,
    _EQUIPMENT,
    _LOCATIONACCOUNTASSIGNMENT,
    _MAINTENANCEACTIVITYTYPE,
    _MAINTENANCENOTIFICATION,
    _MAINTENANCEORDERPHASE,
    _MAINTENANCEORDERTYPE,
    _MAINTENANCEPLAN,
    _MAINTENANCEPLANNERGROUP,
    _MAINTENANCEPLANNINGPLANT,
    _MAINTENANCEPRIORITY,
    _MAINTENANCEPRIORITYTYPE,
    _MAINTENANCEREVISION,
    _MAINTORDMAINWORKCENTER,
    _MAINTORDMAINWORKCENTERPLANT,
    _MAINTORDPERSONRESPONSIBLE,
    _MAINWORKCENTER,
    _ORDERHASLONGTEXT,
    _STATUSOBJECT,
    _TECHOBJISEQUIPORFUNCNLLOC,
    ASSEMBLY,
    AUTHORIZATIONGROUP,
    BUSINESSAREA,
    CONTROLLINGAREA,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    FUNCTIONALLOCATIONLABELNAME,
    LASTCHANGEDATETIME,
    LATESTACCEPTABLECOMPLETIONDATE,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEITEM,
    MAINTENANCENOTIFICATION,
    MAINTENANCEORDERCATEGORY,
    MAINTENANCEORDERDESC,
    MAINTENANCEORDERINTERNALID,
    MAINTENANCEORDERPLANNINGCODE,
    MAINTENANCEORDERTYPE,
    MAINTENANCEPLAN,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEPLANT,
    MAINTENANCEPROCESSINGPHASE,
    MAINTENANCEREVISION,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MAINTORDBASICENDDATE,
    MAINTORDBASICENDTIME,
    MAINTORDBASICSTARTDATE,
    MAINTORDBASICSTARTTIME,
    MAINTORDERPROCESSINGCONTEXT,
    MAINTORDERREFERENCEDATE,
    MAINTORDERREFERENCETIME,
    MAINTORDERROUTINGNUMBER,
    MAINTORDMAINWORKCENTER,
    MAINTORDMAINWORKCENTERPLANT,
    MAINTORDPERSONRESPONSIBLE,
    MAINTORDPROCESSPHASECODE,
    MAINTORDPROCESSSUBPHASECODE,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    MAINWORKCENTER,
    MAINWORKCENTERPLANT,
    OPERATIONSYSTEMCONDITION,
    ORDERDESCRIPTION,
    ORDERHASLONGTEXT,
    ORDERTYPE,
    PREVLTSTACCPTBLCOMPLETIONDATE,
    RESPONSIBLECOSTCENTER,
    SCHEDULEDBASICENDDATE,
    SCHEDULEDBASICENDTIME,
    SCHEDULEDBASICSTARTDATE,
    SCHEDULEDBASICSTARTTIME,
    SERIALNUMBER,
    TASKLISTGROUP,
    TASKLISTGROUPCOUNTER,
    TASKLISTTYPE,
    TECHOBJISEQUIPORFUNCNLLOC,
    WBSELEMENTINTERNALID,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (MAINTENANCEORDER)
);