P_Damageanalysiscube

Damage Analysis Cube | view: PDAMAGEANALYCUBE | Extraction: Not supported | Component: Maintenance Notifications

Tables used: 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, ITOBCUST, IFLOUSR, TPAER

🔑 Keys (4)
💰 Amounts
∑ Quantities
📅 Dates (8)
☰ Categorical (4)
Other (25)
🔗 Relations (34)

Column Name	Description
MaintenanceNotification FK	Notification Number
MaintenanceNotificationItem	Item Number in Item Record
MaintenanceNotificationCause	Sequential Number for Cause
MaintNotificationActivity	Consecutive Number of 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	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
IsDeleted	Object is deleted	CHAR1
IsCompleted	Object is completed	CHAR1
MaintNotificationCode	Coding	QCODE
AssetRoom	Room	CHAR8
MaintObjectFreeDefinedAttrib	Sort Field	CHAR30
TechnicalObject	Technical Object	EAMS_TEC_OBJ
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	`P_DAMAGEANALYSISCUBE.MANDT == T370C.MANDT` `P_DAMAGEANALYSISCUBE.ABCINDICATOR == T370C.ABCKZ`
Assembly Assembly Client	`P_DAMAGEANALYSISCUBE.ASSEMBLY == MARA.MATNR` `P_DAMAGEANALYSISCUBE.MANDT == MARA.MANDT`
Location of maintenance object Client Location of maintenance object Maintenance Plant	`P_DAMAGEANALYSISCUBE.MANDT == T499S.MANDT` `P_DAMAGEANALYSISCUBE.ASSETLOCATION == T499S.STAND` `P_DAMAGEANALYSISCUBE.MAINTENANCEPLANT == T499S.WERKS`
Technical Object Authorization Group Technical Object Authorization Group Client	`P_DAMAGEANALYSISCUBE.AUTHORIZATIONGROUP == T370B.BEGRU` `P_DAMAGEANALYSISCUBE.MANDT == T370B.MANDT`
Business Area Business Area Client	`P_DAMAGEANALYSISCUBE.BUSINESSAREA == TGSB.GSBER` `P_DAMAGEANALYSISCUBE.MANDT == TGSB.MANDT`
Catalog Profile Client Catalog Profile	`P_DAMAGEANALYSISCUBE.MANDT == T352B.MANDT` `P_DAMAGEANALYSISCUBE.CATALOGPROFILE == T352B.RBNR`
Company Code Company Code Client	`P_DAMAGEANALYSISCUBE.COMPANYCODE == T001.BUKRS` `P_DAMAGEANALYSISCUBE.MANDT == T001.MANDT`
Construction type material of the object Client Construction type material of the object	`P_DAMAGEANALYSISCUBE.MANDT == MARA.MANDT` `P_DAMAGEANALYSISCUBE.CONSTRUCTIONMATERIAL == MARA.MATNR`
Controlling Area Client Controlling Area	`P_DAMAGEANALYSISCUBE.MANDT == TKA01.MANDT` `P_DAMAGEANALYSISCUBE.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center ? Cost Center Client Controlling Area	`P_DAMAGEANALYSISCUBE.[column in domain "DATBI"] == CSKS.DATBI` `P_DAMAGEANALYSISCUBE.COSTCENTER == CSKS.KOSTL` `P_DAMAGEANALYSISCUBE.MANDT == CSKS.MANDT` `P_DAMAGEANALYSISCUBE.CONTROLLINGAREA == CSKS.KOKRS`
Equipment Number Client Equipment Number	`P_DAMAGEANALYSISCUBE.MANDT == EQUI.MANDT` `P_DAMAGEANALYSISCUBE.EQUIPMENT == EQUI.EQUNR`
Functional Location Client Functional Location	`P_DAMAGEANALYSISCUBE.MANDT == IFLOT.MANDT` `P_DAMAGEANALYSISCUBE.FUNCTIONALLOCATION == IFLOT.TPLNR`
Maintenance Plant Client Maintenance Plant	`P_DAMAGEANALYSISCUBE.MANDT == T001W.MANDT` `P_DAMAGEANALYSISCUBE.MAINTENANCEPLANT == T001W.WERKS`
Cause Code Catalog Client Cause Code Catalog	`P_DAMAGEANALYSISCUBE.MANDT == TQ15.MANDT` `P_DAMAGEANALYSISCUBE.MAINTNOTIFCAUSECODECATALOG == TQ15.KATALOGART`
Cause Code Group Cause Code Group Client Cause Code Catalog	`P_DAMAGEANALYSISCUBE.MAINTNOTIFCAUSECODEGROUP == QPGR.CODEGRUPPE` `P_DAMAGEANALYSISCUBE.MANDT == QPGR.MANDT` `P_DAMAGEANALYSISCUBE.MAINTNOTIFCAUSECODECATALOG == QPGR.KATALOGART`
Damage Code Catalog Client Damage Code Catalog	`P_DAMAGEANALYSISCUBE.MANDT == TQ15.MANDT` `P_DAMAGEANALYSISCUBE.MAINTNOTIFDAMAGECODECATALOG == TQ15.KATALOGART`
Damage Code Group Damage Code Group Client Damage Code Catalog	`P_DAMAGEANALYSISCUBE.MAINTNOTIFDAMAGECODEGROUP == QPGR.CODEGRUPPE` `P_DAMAGEANALYSISCUBE.MANDT == QPGR.MANDT` `P_DAMAGEANALYSISCUBE.MAINTNOTIFDAMAGECODECATALOG == QPGR.KATALOGART`
Catalog Type - Coding Catalog Type - Coding Client	`P_DAMAGEANALYSISCUBE.MAINTNOTIFICATIONCATALOG == TQ15.KATALOGART` `P_DAMAGEANALYSISCUBE.MANDT == TQ15.MANDT`
Code Group - Coding Catalog Type - Coding Client Code Group - Coding	`P_DAMAGEANALYSISCUBE.MAINTNOTIFICATIONCATALOG == QPGR.KATALOGART` `P_DAMAGEANALYSISCUBE.MANDT == QPGR.MANDT` `P_DAMAGEANALYSISCUBE.MAINTNOTIFICATIONCODEGROUP == QPGR.CODEGRUPPE`
Object Part Code Catalog Client Object Part Code Catalog	`P_DAMAGEANALYSISCUBE.MANDT == TQ15.MANDT` `P_DAMAGEANALYSISCUBE.MAINTNOTIFOBJPRTCODECATALOG == TQ15.KATALOGART`
Object Part Code Group Client Object Part Code Group Object Part Code Catalog	`P_DAMAGEANALYSISCUBE.MANDT == QPGR.MANDT` `P_DAMAGEANALYSISCUBE.MAINTNOTIFOBJPRTCODEGROUP == QPGR.CODEGRUPPE` `P_DAMAGEANALYSISCUBE.MAINTNOTIFOBJPRTCODECATALOG == QPGR.KATALOGART`
Priority Client Priority Priority Type	`P_DAMAGEANALYSISCUBE.MANDT == T356.MANDT` `P_DAMAGEANALYSISCUBE.MAINTPRIORITY == T356.PRIOK` `P_DAMAGEANALYSISCUBE.MAINTPRIORITYTYPE == T356.ARTPR`
Priority Type Client Priority Type	`P_DAMAGEANALYSISCUBE.MANDT == T356A.MANDT` `P_DAMAGEANALYSISCUBE.MAINTPRIORITYTYPE == T356A.ARTPR`
Plant Plant Client	`P_DAMAGEANALYSISCUBE.MAINWORKCENTERPLANT == T001W.WERKS` `P_DAMAGEANALYSISCUBE.MANDT == T001W.MANDT`
Effect on Operation Client Effect on Operation	`P_DAMAGEANALYSISCUBE.MANDT == T357A.MANDT` `P_DAMAGEANALYSISCUBE.MALFUNCTIONEFFECT == T357A.AUSWK`
Country/Region of Manufacture Client Country/Region of Manufacture	`P_DAMAGEANALYSISCUBE.MANDT == T005.MANDT` `P_DAMAGEANALYSISCUBE.MANUFACTURERCOUNTRY == T005.LAND1`
Notification Type Client Notification Type	`P_DAMAGEANALYSISCUBE.MANDT == TQ80.MANDT` `P_DAMAGEANALYSISCUBE.NOTIFICATIONTYPE == TQ80.QMART`
Plant Section Plant Section Client Maintenance Plant	`P_DAMAGEANALYSISCUBE.PLANTSECTION == T357.BEBER` `P_DAMAGEANALYSISCUBE.MANDT == T357.MANDT` `P_DAMAGEANALYSISCUBE.MAINTENANCEPLANT == T357.WERKS`
Technical Object Category Client Technical Object Category	`P_DAMAGEANALYSISCUBE.MANDT == T370T.MANDT` `P_DAMAGEANALYSISCUBE.TECHNICALOBJECTCATEGORY == T370T.EQTYP`
Type of Technical Object Client Type of Technical Object	`P_DAMAGEANALYSISCUBE.MANDT == T370K.MANDT` `P_DAMAGEANALYSISCUBE.TECHNICALOBJECTTYPE == T370K.EQART`

Other Relations \| to Master Data Relations ↑	Join Conditions
Planner Group for Customer Service and Plant Maintenance Planner Group for Customer Service and Plant Maintenance Maintenance Planning Plant Client	`P_DAMAGEANALYSISCUBE.MAINTENANCEPLANNERGROUP == T024I.INGRP` `P_DAMAGEANALYSISCUBE.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `P_DAMAGEANALYSISCUBE.MANDT == T024I.MANDT`
Maintenance Planning Plant Maintenance Planning Plant Client	`P_DAMAGEANALYSISCUBE.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `P_DAMAGEANALYSISCUBE.MANDT == T399I.MANDT`