I_MAINTORDERTP

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 w/ Technical Object
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTORDERTP (
    MAINTENANCEORDER,
    _ASSEMBLY,
    _EAMPROCESSPHASE,
    _EAMPROCESSSUBPHASE,
    _EQUIPMENT,
    _FUNCTIONALLOCATION,
    _LOCATIONACCOUNTASSIGNMENT,
    _MAINTENANCEACTIVITYTYPE,
    _MAINTENANCENOTIFICATION,
    _MAINTENANCEORDERCATEGORY,
    _MAINTENANCEORDERPHASE,
    _MAINTENANCEORDERTYPE,
    _MAINTENANCEPLAN,
    _MAINTENANCEPLANNERGROUP,
    _MAINTENANCEPLANNINGPLANT,
    _MAINTENANCEPRIORITY,
    _MAINTENANCEPRIORITYTYPE,
    _MAINTENANCEREVISION,
    _MAINTORDPERSONRESPONSIBLE,
    _MAINTORDPLNGDEGREECODE,
    _OPERATIONSYSTEMCONDITION,
    _ORDER,
    _ORDERHASLONGTEXT,
    _RESPONSIBLECOSTCENTER,
    _STATUSOBJECT,
    _STATUSOBJECTSTATUS,
    _TECHNICALOBJECT,
    _TECHOBJISEQUIPORFUNCNLLOC,
    ASSEMBLY,
    AUTHORIZATIONGROUP,
    BASICSCHEDULINGTYPE,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    CONTROLLINGOBJECTCLASS,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CURRENCY,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    LATESTACCEPTABLECOMPLETIONDATE,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEITEM,
    MAINTENANCENOTIFICATION,
    MAINTENANCEORDERCATEGORY,
    MAINTENANCEORDERDESC,
    MAINTENANCEORDERFOREDIT,
    MAINTENANCEORDERINTERNALID,
    MAINTENANCEORDERPLANNINGCODE,
    MAINTENANCEORDERTYPE,
    MAINTENANCEPLAN,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEPLANT,
    MAINTENANCEPROCESSINGPHASE,
    MAINTENANCEREVISION,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MAINTORDBASICENDDATE,
    MAINTORDBASICSTARTDATE,
    MAINTORDERPROCESSINGCONTEXT,
    MAINTORDERREFERENCEDATE,
    MAINTORDERREFERENCETIME,
    MAINTORDERROUTINGNUMBER,
    MAINTORDERSOURCEAPPLICATION,
    MAINTORDPERSONRESPONSIBLE,
    MAINTORDPROCESSPHASECODE,
    MAINTORDPROCESSSUBPHASECODE,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    OPERATIONSYSTEMCONDITION,
    ORDERHASLONGTEXT,
    RESPONSIBLECOSTCENTER,
    SCHEDULEDBASICENDDATE,
    SCHEDULEDBASICENDTIME,
    SCHEDULEDBASICSTARTDATE,
    SCHEDULEDBASICSTARTTIME,
    SERIALNUMBER,
    TASKLISTGROUP,
    TASKLISTGROUPCOUNTER,
    TASKLISTTYPE,
    TECHNICALOBJECT,
    TECHOBJISEQUIPORFUNCNLLOC,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    WORKPERMITRELEVANCE,
    PRIMARY KEY (MAINTENANCEORDER)
);