P_DAMAGEANALYSISCUBE

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.

-- Damage Analysis Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_DAMAGEANALYSISCUBE (
    MAINTENANCENOTIFICATION,
    _ABCINDICATOR,
    _BUSINESSAREA,
    _COMPANYCODE,
    _EQUIPMENT,
    _FUNCTIONALLOCATION,
    _MAINTENANCENOTIFICATION,
    _MAINTENANCEPLANNERGROUP,
    _MAINTENANCEPLANNINGPLANT,
    _MAINTENANCEPLANPLANT,
    _MAINTENANCEPLANT,
    _MAINTNOTIFICATIONCATALOG,
    _MAINTNOTIFICATIONCODE,
    _MAINTNOTIFICATIONCODEGROUP,
    _MAINTNOTIFICATIONTECHOBJ,
    _MALFUNCTIONEFFECT,
    _MANUFACTURERCOUNTRY,
    _PLANTSECTION,
    _PMNOTIFICATIONPHASE,
    _PMNOTIFICATIONPRIORITY,
    _PMNOTIFICATIONPRIORITYTYPE,
    _PMNOTIFICATIONTYPE,
    _TECHNICALOBJECT,
    _TECHNICALOBJECTCATEGORY,
    _TECHNICALOBJECTCODECATALOG,
    _TECHNICALOBJECTTYPE,
    _TECHOBJISEQUIPORFUNCNLLOC,
    _USEDCONSTRUCTIONTYPEVH,
    _WBSELEMENTBASICDATA,
    ABCINDICATOR,
    ASSEMBLY,
    ASSETLOCATION,
    ASSETMANUFACTURERNAME,
    ASSETROOM,
    AUTHORIZATIONGROUP,
    BUSINESSAREA,
    CATALOGPROFILE,
    COMPANYCODE,
    CONSTRUCTIONMATERIAL,
    CONSTRUCTIONMONTH,
    CONSTRUCTIONYEAR,
    CONTROLLINGAREA,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEPLANT,
    MAINTNOTIFACTIVITYCODECATALOG,
    MAINTNOTIFACTIVITYCODEGROUP,
    MAINTNOTIFCAUSECODECATALOG,
    MAINTNOTIFCAUSECODEGROUP,
    MAINTNOTIFDAMAGECODECATALOG,
    MAINTNOTIFDAMAGECODEGROUP,
    MAINTNOTIFICATIONACTIVITYCODE,
    MAINTNOTIFICATIONCATALOG,
    MAINTNOTIFICATIONCAUSECODE,
    MAINTNOTIFICATIONCODE,
    MAINTNOTIFICATIONCODEGROUP,
    MAINTNOTIFICATIONDAMAGECODE,
    MAINTNOTIFICATIONROOTCAUSE,
    MAINTNOTIFOBJPRTCODE,
    MAINTNOTIFOBJPRTCODECATALOG,
    MAINTOBJECTFREEDEFINEDATTRIB,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    MAINWORKCENTERPLANT,
    MALFUNCTIONEFFECT,
    MALFUNCTIONENDDATE,
    MALFUNCTIONSTARTDATE,
    MANUFACTURERCOUNTRY,
    MANUFACTURERPARTTYPENAME,
    NOTIFICATIONCREATIONDATE,
    NOTIFICATIONREFERENCEDATE,
    NOTIFICATIONTYPE,
    NOTIFPROCESSINGPHASE,
    NUMBEROFMAINTNOTIFACTIVITIES,
    NUMBEROFMAINTNOTIFCAUSES,
    NUMBEROFMAINTNOTIFDAMAGES,
    NUMBEROFMAINTNOTIFOBJECTPARTS,
    PLANTSECTION,
    REPORTEDBYUSER,
    REQUIREDENDDATE,
    REQUIREDSTARTDATE,
    TECHNICALOBJECT,
    TECHNICALOBJECTCATEGORY,
    TECHNICALOBJECTTYPE,
    TECHOBJISEQUIPORFUNCNLLOC,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (MAINTENANCENOTIFICATION)
);