MAINTENANCENOTIF

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 MAINTENANCENOTIF (
    MAINTENANCENOTIFICATION,
    _CREATEDBYUSER,
    _MAINTENANCEORDER,
    _MAINTENANCEWORKCENTERPLANT,
    _MAINTNOTIFDETECTCODEGROUPTXT,
    _MAINTNOTIFDETECTCODETXT,
    _MAINTNOTIFICATIONCODE,
    _MAINTNOTIFICATIONCODEGROUP,
    _MAINTNOTIFREJECTIONREASONTXT,
    _MAINTPLANT,
    _MAINTPLANTGROUP,
    _MAINWORKCENTER,
    _PHASE,
    _PMNOTIFICATIONPHASE,
    _PMNOTIFICATIONPRIORITY,
    _PMNOTIFICATIONTYPE,
    _SUBPHASE,
    _SUPFUNCTIONALLOCATIONTEXT,
    _TASKLISTDESC,
    _TECHNICALOBJECT,
    _TECHNICALOBJECTTEXT,
    _TECHNICALOBJQUICKVW,
    _TECHOBJISEQUIPORFUNCNLLOC,
    _TECHOBJISEQUIPORFUNCNLLOCDESC,
    _TEXTOBJECTPLAINLONGTEXT,
    ABCINDICATOR,
    ACTIVETECHNICALOBJECT,
    ASSETLOCATION,
    ASSETMANUFACTURERNAME,
    ASSETROOM,
    CATALOGPROFILE,
    COMPLETIONTIME,
    CONCATENATEDACTIVESYSTSTSNAME,
    CONCATENATEDACTIVEUSERSTSNAME,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONDATETIME,
    CREATIONTIME,
    FUNCTIONALLOCATION,
    FUNCTIONALLOCATIONLABELNAME,
    IDENTIFYINGLABEL,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    LATESTACCEPTABLECOMPLETIONDATE,
    LOCATIONDESCRIPTION,
    LOCATIONNAME,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEOBJECTISDOWN,
    MAINTENANCEORDER,
    MAINTENANCEORDERTYPE,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEPLANT,
    MAINTENANCETASKLISTTYPE,
    MAINTENANCEWORKCENTER,
    MAINTENANCEWORKCENTERPLANT,
    MAINTEVTISCREATEDBYCURRENTUSER,
    MAINTNOTIFDETECTIONCATALOG,
    MAINTNOTIFDETECTIONCODE,
    MAINTNOTIFDETECTIONCODEGROUP,
    MAINTNOTIFEXTREFERENCENUMBER,
    MAINTNOTIFICATIONCATALOG,
    MAINTNOTIFICATIONCODE,
    MAINTNOTIFICATIONCODEGROUP,
    MAINTNOTIFINTERNALID,
    MAINTNOTIFPROCESSPHASECODE,
    MAINTNOTIFPROCESSSUBPHASECODE,
    MAINTNOTIFREJECTIONREASONCODE,
    MAINTNOTIFRESPPARTNERFUNCTION,
    MAINTNOTIFRQDENDDATETIME,
    MAINTNOTIFRQDSTARTDATETIME,
    MAINTNOTIFSOURCEAPPLICATION,
    MAINTNOTIFWITHLEADINGZEROS,
    MAINTOBJDOWNTIMEDURATIONUNIT,
    MAINTOBJECTDOWNTIMEDURATION,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    MAINTREQUESTEDITABLELONGTEXT,
    MAINTWORKREQUESTATTCHKEY,
    MAINWORKCENTER,
    MAINWORKCENTERPLANT,
    MALFUNCTIONEFFECT,
    MALFUNCTIONENDDATE,
    MALFUNCTIONENDDATETIME,
    MALFUNCTIONENDTIME,
    MALFUNCTIONSTARTDATE,
    MALFUNCTIONSTARTDATETIME,
    MALFUNCTIONSTARTTIME,
    MANUFACTURERPARTTYPENAME,
    NMBROFOPENMAINTNOTIFICATIONS,
    NOTIFICATIONCOMPLETIONDATE,
    NOTIFICATIONCREATIONDATE,
    NOTIFICATIONCREATIONDATETIME,
    NOTIFICATIONCREATIONTIME,
    NOTIFICATIONREFERENCEDATE,
    NOTIFICATIONREFERENCETIME,
    NOTIFICATIONTEXT,
    NOTIFICATIONTIMEZONE,
    NOTIFICATIONTYPE,
    NOTIFPROCESSINGPHASE,
    NUMBEROFORDERS,
    PERSONRESPONSIBLE,
    PERSONRESPONSIBLENAME,
    PLANTSECTION,
    REPORTEDBYUSER,
    REPORTERFULLNAME,
    REQUIREDENDDATE,
    REQUIREDENDTIME,
    REQUIREDSTARTDATE,
    REQUIREDSTARTTIME,
    SUPERIORTECHNICALOBJECTLABEL,
    TASKLIST,
    TASKLISTGROUP,
    TASKLISTGROUPCOUNTER,
    TASKLISTKEYDATE,
    TECHNICALOBJECT,
    TECHNICALOBJECTCATEGORY,
    TECHNICALOBJECTLABEL,
    TECHNICALOBJECTTYPE,
    TECHOBJINSTALLATIONLOCATION,
    TECHOBJISEQUIPORFUNCNLLOC,
    TEXTOBJECTCATEGORY,
    TEXTOBJECTTYPE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    WORKREQUESTTEXTTEMPLATE,
    PRIMARY KEY (MAINTENANCENOTIFICATION)
);