C_DamageAnalysisQuery

Damage Analysis Query | view: CDAMAGEANALYQRY | 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

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

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
NotificationCreationYear	Maintenance Notification Creation Year	NUM4
MaintNotificationCode	Coding	QCODE
AssetRoom	Room	CHAR8
MaintObjectFreeDefinedAttrib	Sort Field	CHAR30
TechnicalObject	Technical Object	EAMS_TEC_OBJ
TechnicalObjectLabel	Technical Object Identifier
AssetManufacturerName	Manufacturer of Asset	TEXT30
ManufacturerPartTypeName	Manufacturer model number	TYPBZ
ConstructionYear	Year of construction	CJAHR
MaintNotificationDamageCode	Damage Code	QCODE
MaintNotifObjPrtCode	Object Part Code	QCODE
MaintNotificationCauseCode	Cause Code	QCODE
MaintNotifActivityCodeCatalog	Activity Code Catalog
MaintNotificationActivityCode	Activity Code	QCODE
MaintNotifActivityCodeGroup	Activity Code Group	QCODEGRP
NumberOfMaintNotifActivities	PMIS: number of activity codes	MCZAEHLER
NumberOfMaintNotifDamages	PMIS: No.of damages	MCZAEHLER
NumberOfMaintNotifCauses	PMIS: No. of cause of damage codes	MCZAEHLER
NumberOfMaintNotifObjectParts	Number of Object Parts	MCZAEHLER

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object Client ABC Indicator for Technical Object	`C_DAMAGEANALYSISQUERY.MANDT == T370C.MANDT` `C_DAMAGEANALYSISQUERY.ABCINDICATOR == T370C.ABCKZ`
Assembly Assembly Client	`C_DAMAGEANALYSISQUERY.ASSEMBLY == MARA.MATNR` `C_DAMAGEANALYSISQUERY.MANDT == MARA.MANDT`
Location of maintenance object Client Location of maintenance object Maintenance Plant	`C_DAMAGEANALYSISQUERY.MANDT == T499S.MANDT` `C_DAMAGEANALYSISQUERY.ASSETLOCATION == T499S.STAND` `C_DAMAGEANALYSISQUERY.MAINTENANCEPLANT == T499S.WERKS`
Technical Object Authorization Group Client Technical Object Authorization Group	`C_DAMAGEANALYSISQUERY.MANDT == T370B.MANDT` `C_DAMAGEANALYSISQUERY.AUTHORIZATIONGROUP == T370B.BEGRU`
Business Area Client Business Area	`C_DAMAGEANALYSISQUERY.MANDT == TGSB.MANDT` `C_DAMAGEANALYSISQUERY.BUSINESSAREA == TGSB.GSBER`
Catalog Profile Client Catalog Profile	`C_DAMAGEANALYSISQUERY.MANDT == T352B.MANDT` `C_DAMAGEANALYSISQUERY.CATALOGPROFILE == T352B.RBNR`
Company Code Company Code Client	`C_DAMAGEANALYSISQUERY.COMPANYCODE == T001.BUKRS` `C_DAMAGEANALYSISQUERY.MANDT == T001.MANDT`
Construction type material of the object Client Construction type material of the object	`C_DAMAGEANALYSISQUERY.MANDT == MARA.MANDT` `C_DAMAGEANALYSISQUERY.CONSTRUCTIONMATERIAL == MARA.MATNR`
Controlling Area Controlling Area Client	`C_DAMAGEANALYSISQUERY.CONTROLLINGAREA == TKA01.KOKRS` `C_DAMAGEANALYSISQUERY.MANDT == TKA01.MANDT`
Cost Center Controlling Area Cost Center Client ?	`C_DAMAGEANALYSISQUERY.CONTROLLINGAREA == CSKS.KOKRS` `C_DAMAGEANALYSISQUERY.COSTCENTER == CSKS.KOSTL` `C_DAMAGEANALYSISQUERY.MANDT == CSKS.MANDT` `C_DAMAGEANALYSISQUERY.[column in domain "DATBI"] == CSKS.DATBI`
Equipment Number Equipment Number Client	`C_DAMAGEANALYSISQUERY.EQUIPMENT == EQUI.EQUNR` `C_DAMAGEANALYSISQUERY.MANDT == EQUI.MANDT`
Functional Location Client Functional Location	`C_DAMAGEANALYSISQUERY.MANDT == IFLOT.MANDT` `C_DAMAGEANALYSISQUERY.FUNCTIONALLOCATION == IFLOT.TPLNR`
Maintenance Plant Client Maintenance Plant	`C_DAMAGEANALYSISQUERY.MANDT == T001W.MANDT` `C_DAMAGEANALYSISQUERY.MAINTENANCEPLANT == T001W.WERKS`
Cause Code Catalog Client Cause Code Catalog	`C_DAMAGEANALYSISQUERY.MANDT == TQ15.MANDT` `C_DAMAGEANALYSISQUERY.MAINTNOTIFCAUSECODECATALOG == TQ15.KATALOGART`
Cause Code Group Client Cause Code Catalog Cause Code Group	`C_DAMAGEANALYSISQUERY.MANDT == QPGR.MANDT` `C_DAMAGEANALYSISQUERY.MAINTNOTIFCAUSECODECATALOG == QPGR.KATALOGART` `C_DAMAGEANALYSISQUERY.MAINTNOTIFCAUSECODEGROUP == QPGR.CODEGRUPPE`
Damage Code Catalog Damage Code Catalog Client	`C_DAMAGEANALYSISQUERY.MAINTNOTIFDAMAGECODECATALOG == TQ15.KATALOGART` `C_DAMAGEANALYSISQUERY.MANDT == TQ15.MANDT`
Damage Code Group Damage Code Group Damage Code Catalog Client	`C_DAMAGEANALYSISQUERY.MAINTNOTIFDAMAGECODEGROUP == QPGR.CODEGRUPPE` `C_DAMAGEANALYSISQUERY.MAINTNOTIFDAMAGECODECATALOG == QPGR.KATALOGART` `C_DAMAGEANALYSISQUERY.MANDT == QPGR.MANDT`
Catalog Type - Coding Client Catalog Type - Coding	`C_DAMAGEANALYSISQUERY.MANDT == TQ15.MANDT` `C_DAMAGEANALYSISQUERY.MAINTNOTIFICATIONCATALOG == TQ15.KATALOGART`
Code Group - Coding Client Code Group - Coding Catalog Type - Coding	`C_DAMAGEANALYSISQUERY.MANDT == QPGR.MANDT` `C_DAMAGEANALYSISQUERY.MAINTNOTIFICATIONCODEGROUP == QPGR.CODEGRUPPE` `C_DAMAGEANALYSISQUERY.MAINTNOTIFICATIONCATALOG == QPGR.KATALOGART`
Object Part Code Catalog Client Object Part Code Catalog	`C_DAMAGEANALYSISQUERY.MANDT == TQ15.MANDT` `C_DAMAGEANALYSISQUERY.MAINTNOTIFOBJPRTCODECATALOG == TQ15.KATALOGART`
Object Part Code Group Object Part Code Group Client Object Part Code Catalog	`C_DAMAGEANALYSISQUERY.MAINTNOTIFOBJPRTCODEGROUP == QPGR.CODEGRUPPE` `C_DAMAGEANALYSISQUERY.MANDT == QPGR.MANDT` `C_DAMAGEANALYSISQUERY.MAINTNOTIFOBJPRTCODECATALOG == QPGR.KATALOGART`
Priority Priority Type Client Priority	`C_DAMAGEANALYSISQUERY.MAINTPRIORITYTYPE == T356.ARTPR` `C_DAMAGEANALYSISQUERY.MANDT == T356.MANDT` `C_DAMAGEANALYSISQUERY.MAINTPRIORITY == T356.PRIOK`
Priority Type Priority Type Client	`C_DAMAGEANALYSISQUERY.MAINTPRIORITYTYPE == T356A.ARTPR` `C_DAMAGEANALYSISQUERY.MANDT == T356A.MANDT`
Plant Client Plant	`C_DAMAGEANALYSISQUERY.MANDT == T001W.MANDT` `C_DAMAGEANALYSISQUERY.MAINWORKCENTERPLANT == T001W.WERKS`
Effect on Operation Effect on Operation Client	`C_DAMAGEANALYSISQUERY.MALFUNCTIONEFFECT == T357A.AUSWK` `C_DAMAGEANALYSISQUERY.MANDT == T357A.MANDT`
Country/Region of Manufacture Client Country/Region of Manufacture	`C_DAMAGEANALYSISQUERY.MANDT == T005.MANDT` `C_DAMAGEANALYSISQUERY.MANUFACTURERCOUNTRY == T005.LAND1`
Notification Type Client Notification Type	`C_DAMAGEANALYSISQUERY.MANDT == TQ80.MANDT` `C_DAMAGEANALYSISQUERY.NOTIFICATIONTYPE == TQ80.QMART`
Plant Section Plant Section Client Maintenance Plant	`C_DAMAGEANALYSISQUERY.PLANTSECTION == T357.BEBER` `C_DAMAGEANALYSISQUERY.MANDT == T357.MANDT` `C_DAMAGEANALYSISQUERY.MAINTENANCEPLANT == T357.WERKS`
Technical Object Category Client Technical Object Category	`C_DAMAGEANALYSISQUERY.MANDT == T370T.MANDT` `C_DAMAGEANALYSISQUERY.TECHNICALOBJECTCATEGORY == T370T.EQTYP`
Type of Technical Object Client Type of Technical Object	`C_DAMAGEANALYSISQUERY.MANDT == T370K.MANDT` `C_DAMAGEANALYSISQUERY.TECHNICALOBJECTTYPE == T370K.EQART`

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