I_DamageAnalysisCube

Damage Analysis Cube | view: IDAMAGEANALYCUBE | TRAN | Extraction: Not supported | Component: Maintenance Notifications
Tables used: SCAL_TT_DATE, QMEL, QMUR, QMFE, QMMA, QMIH, JSTO, JEST, BUT000, EQUI, EQKT, EQUZ, IFLOS, T370S, IFLOT, IFLOTX, ILOA, ADCP, ADR6, ADRC, ADRP, USR21, NRIV, TQ80, CRHD, ADR2, ADR2, ITOBCUST, IFLOUSR, TPAER
Column Name Description
MaintenanceNotification FK Notification Number
MaintenanceNotificationItem Maintenance Notification Item Cause Number
MaintenanceNotificationCause Maintenance Notification Number for Cause
MaintNotificationActivity Maintenance Notification Number for Activity
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
NotificationCreationDate Date of Notification
RequiredStartDate Required Start Date
RequiredEndDate Required End Date
NotificationReferenceDate Notification Reference Date
MalfunctionStartDate Start of Malfunction (Date)
MalfunctionEndDate End of Malfunction (Date)
Column Name Description
NotifProcessingPhase Notification Processing Phase Show values
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
ConstructionMonth Month of construction Show values
MaintNotificationRootCause Root Cause Show values
Column Name Description Domain name
MainWorkCenter Main work center for maintenance tasks ARBPL
WorkCenter EAM Maintenance Work Center ARBPL
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ReportedByUser Name of Person Reporting Notification USNAM
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
NotificationCreationYear Calendar Year NUM4
MaintNotificationCode Coding QCODE
AssetRoom Room CHAR8
MaintObjectFreeDefinedAttrib Sort Field CHAR30
TechnicalObject Technical Object EAMS_TEC_OBJ
TechnicalObjectLabel Technical Object Identifier EAMS_TECH_OBJ_CONV
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
ConstructionYear Year of construction CJAHR
MaintNotificationDamageCode Damage Code QCODE
NumberOfMaintNotifDamages PMIS: No.of damages MCZAEHLER
MaintNotifObjPrtCode Object Part Code QCODE
NumberOfMaintNotifObjectParts Number of Object Parts MCZAEHLER
MaintNotificationCauseCode Cause Code QCODE
NumberOfMaintNotifCauses PMIS: No. of cause of damage codes MCZAEHLER
MaintNotifActivityCodeCatalog Activity Code Catalog QKATART
MaintNotificationActivityCode Activity Code QCODE
MaintNotifActivityCodeGroup Activity Code Group QCODEGRP
NumberOfMaintNotifActivities PMIS: number of activity codes MCZAEHLER
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • Client
  • ABC Indicator for Technical Object
  • I_DAMAGEANALYSISCUBE.MANDT == T370C.MANDT
  • I_DAMAGEANALYSISCUBE.ABCINDICATOR == T370C.ABCKZ
Assembly
  • Client
  • Assembly
  • I_DAMAGEANALYSISCUBE.MANDT == MARA.MANDT
  • I_DAMAGEANALYSISCUBE.ASSEMBLY == MARA.MATNR
Location of maintenance object
  • Client
  • Location of maintenance object
  • Maintenance Plant
  • I_DAMAGEANALYSISCUBE.MANDT == T499S.MANDT
  • I_DAMAGEANALYSISCUBE.ASSETLOCATION == T499S.STAND
  • I_DAMAGEANALYSISCUBE.MAINTENANCEPLANT == T499S.WERKS
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • I_DAMAGEANALYSISCUBE.AUTHORIZATIONGROUP == T370B.BEGRU
  • I_DAMAGEANALYSISCUBE.MANDT == T370B.MANDT
Business Area
  • Client
  • Business Area
  • I_DAMAGEANALYSISCUBE.MANDT == TGSB.MANDT
  • I_DAMAGEANALYSISCUBE.BUSINESSAREA == TGSB.GSBER
Catalog Profile
  • Client
  • Catalog Profile
  • I_DAMAGEANALYSISCUBE.MANDT == T352B.MANDT
  • I_DAMAGEANALYSISCUBE.CATALOGPROFILE == T352B.RBNR
Company Code
  • Company Code
  • Client
  • I_DAMAGEANALYSISCUBE.COMPANYCODE == T001.BUKRS
  • I_DAMAGEANALYSISCUBE.MANDT == T001.MANDT
Construction type material of the object
  • Client
  • Construction type material of the object
  • I_DAMAGEANALYSISCUBE.MANDT == MARA.MANDT
  • I_DAMAGEANALYSISCUBE.CONSTRUCTIONMATERIAL == MARA.MATNR
Controlling Area
  • Client
  • Controlling Area
  • I_DAMAGEANALYSISCUBE.MANDT == TKA01.MANDT
  • I_DAMAGEANALYSISCUBE.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • I_DAMAGEANALYSISCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_DAMAGEANALYSISCUBE.MANDT == CSKS.MANDT
  • I_DAMAGEANALYSISCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_DAMAGEANALYSISCUBE.COSTCENTER == CSKS.KOSTL
Equipment Number
  • Client
  • Equipment Number
  • I_DAMAGEANALYSISCUBE.MANDT == EQUI.MANDT
  • I_DAMAGEANALYSISCUBE.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • I_DAMAGEANALYSISCUBE.MANDT == IFLOT.MANDT
  • I_DAMAGEANALYSISCUBE.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance Plant
  • Client
  • Maintenance Plant
  • I_DAMAGEANALYSISCUBE.MANDT == T001W.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTENANCEPLANT == T001W.WERKS
Cause Code Catalog
  • Client
  • Cause Code Catalog
  • I_DAMAGEANALYSISCUBE.MANDT == TQ15.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTNOTIFCAUSECODECATALOG == TQ15.KATALOGART
Cause Code Group
  • Client
  • Cause Code Catalog
  • Cause Code Group
  • I_DAMAGEANALYSISCUBE.MANDT == QPGR.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTNOTIFCAUSECODECATALOG == QPGR.KATALOGART
  • I_DAMAGEANALYSISCUBE.MAINTNOTIFCAUSECODEGROUP == QPGR.CODEGRUPPE
Damage Code Catalog
  • Client
  • Damage Code Catalog
  • I_DAMAGEANALYSISCUBE.MANDT == TQ15.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTNOTIFDAMAGECODECATALOG == TQ15.KATALOGART
Damage Code Group
  • Client
  • Damage Code Group
  • Damage Code Catalog
  • I_DAMAGEANALYSISCUBE.MANDT == QPGR.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTNOTIFDAMAGECODEGROUP == QPGR.CODEGRUPPE
  • I_DAMAGEANALYSISCUBE.MAINTNOTIFDAMAGECODECATALOG == QPGR.KATALOGART
Catalog Type - Coding
  • Client
  • Catalog Type - Coding
  • I_DAMAGEANALYSISCUBE.MANDT == TQ15.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTNOTIFICATIONCATALOG == TQ15.KATALOGART
Code Group - Coding
  • Client
  • Code Group - Coding
  • Catalog Type - Coding
  • I_DAMAGEANALYSISCUBE.MANDT == QPGR.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTNOTIFICATIONCODEGROUP == QPGR.CODEGRUPPE
  • I_DAMAGEANALYSISCUBE.MAINTNOTIFICATIONCATALOG == QPGR.KATALOGART
Object Part Code Catalog
  • Client
  • Object Part Code Catalog
  • I_DAMAGEANALYSISCUBE.MANDT == TQ15.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTNOTIFOBJPRTCODECATALOG == TQ15.KATALOGART
Object Part Code Group
  • Client
  • Object Part Code Group
  • Object Part Code Catalog
  • I_DAMAGEANALYSISCUBE.MANDT == QPGR.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTNOTIFOBJPRTCODEGROUP == QPGR.CODEGRUPPE
  • I_DAMAGEANALYSISCUBE.MAINTNOTIFOBJPRTCODECATALOG == QPGR.KATALOGART
Priority
  • Client
  • Priority Type
  • Priority
  • I_DAMAGEANALYSISCUBE.MANDT == T356.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTPRIORITYTYPE == T356.ARTPR
  • I_DAMAGEANALYSISCUBE.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Client
  • Priority Type
  • I_DAMAGEANALYSISCUBE.MANDT == T356A.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTPRIORITYTYPE == T356A.ARTPR
Plant
  • Client
  • Plant
  • I_DAMAGEANALYSISCUBE.MANDT == T001W.MANDT
  • I_DAMAGEANALYSISCUBE.MAINWORKCENTERPLANT == T001W.WERKS
Effect on Operation
  • Client
  • Effect on Operation
  • I_DAMAGEANALYSISCUBE.MANDT == T357A.MANDT
  • I_DAMAGEANALYSISCUBE.MALFUNCTIONEFFECT == T357A.AUSWK
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • I_DAMAGEANALYSISCUBE.MANUFACTURERCOUNTRY == T005.LAND1
  • I_DAMAGEANALYSISCUBE.MANDT == T005.MANDT
Notification Type
  • Client
  • Notification Type
  • I_DAMAGEANALYSISCUBE.MANDT == TQ80.MANDT
  • I_DAMAGEANALYSISCUBE.NOTIFICATIONTYPE == TQ80.QMART
Plant Section
  • Client
  • Maintenance Plant
  • Plant Section
  • I_DAMAGEANALYSISCUBE.MANDT == T357.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTENANCEPLANT == T357.WERKS
  • I_DAMAGEANALYSISCUBE.PLANTSECTION == T357.BEBER
Technical Object Category
  • Technical Object Category
  • Client
  • I_DAMAGEANALYSISCUBE.TECHNICALOBJECTCATEGORY == T370T.EQTYP
  • I_DAMAGEANALYSISCUBE.MANDT == T370T.MANDT
Type of Technical Object
  • Type of Technical Object
  • Client
  • I_DAMAGEANALYSISCUBE.TECHNICALOBJECTTYPE == T370K.EQART
  • I_DAMAGEANALYSISCUBE.MANDT == T370K.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Client
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • I_DAMAGEANALYSISCUBE.MANDT == T024I.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_DAMAGEANALYSISCUBE.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • I_DAMAGEANALYSISCUBE.MANDT == T399I.MANDT
  • I_DAMAGEANALYSISCUBE.MAINTENANCEPLANNINGPLANT == T399I.IWERK