I_MAINTENANCEORDERHISTORY

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 History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTENANCEORDERHISTORY (
    MAINTENANCEORDER,
    _ASSEMBLY,
    _BUSINESSAREA,
    _EQUIPMENT,
    _LOCATIONACCOUNTASSIGNMENT,
    _MAINTENANCEACTIVITYTYPE,
    _MAINTENANCEITEM,
    _MAINTENANCENOTIFICATION,
    _MAINTENANCEORDERCATEGORY,
    _MAINTENANCEORDERCOMPONENT,
    _MAINTENANCEORDERPHASE,
    _MAINTENANCEORDERTYPE,
    _MAINTENANCEPLAN,
    _MAINTENANCEPLANNERGROUP,
    _MAINTENANCEPLANNINGPLANT,
    _MAINTENANCEPRIORITY,
    _MAINTENANCEPRIORITYTYPE,
    _OPERATIONSYSTEMCONDITION,
    _STATUSOBJECT,
    _STATUSOBJECTSTATUS,
    ACTUALSTARTDATE,
    ASSEMBLY,
    AUTHORIZATIONGROUP,
    BILLOFOPERATIONS,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BUSINESSAREA,
    CONFIRMEDENDDATE,
    CONTROLLINGAREA,
    CREATEDBYUSER,
    CREATIONDATE,
    EQUIPMENT,
    ISMARKEDFORDELETION,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LEADINGORDER,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEITEM,
    MAINTENANCENOTIFICATION,
    MAINTENANCEORDERCATEGORY,
    MAINTENANCEORDERDESC,
    MAINTENANCEORDERINTERNALID,
    MAINTENANCEORDERPLANNINGCODE,
    MAINTENANCEORDERTYPE,
    MAINTENANCEPLAN,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEPLANT,
    MAINTENANCEPROCESSINGPHASE,
    MAINTENANCEREVISION,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MAINTORDBASICENDDATE,
    MAINTORDBASICSTARTDATE,
    MAINTORDERREFERENCEDATE,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    OPERATIONSYSTEMCONDITION,
    PLANT,
    SERIALNUMBER,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (MAINTENANCEORDER)
);