C_PMNotificationHeader

Maintenance Notification | view: CPMNOTIFHEAD | TRAN | Extraction: Not supported | Component: Maintenance Notifications

Tables used: QMEL, QMIH, BUT000, T370U, EQUI, T370T, EQKT, EQUZ, T370F_T, IFLOS, IFLOT, T370F, IFLOTX, ILOA, T357A, T357A_T, IHPA, ADCP, ADR6, ADRC, ADRP, USR21, T356, T356_T, NRIV, TQ80, TQ80_T, T370K, T370K_T, CRHD, ADR2, ADR2, ITOBCUST, IFLOUSR, TPAER

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (8)
☰ Categorical (1)
Other (36)
🔗 Relations (23)

Column Name	Description
MaintNotifWithLeadingZeros	Notification Number

Column Name	Description

Column Name	Description

Column Name	Description
CreationDate	Date on which the record was created
CreationTime	Time at Which Record Was Added
RequiredStartDate	Required Start Date
RequiredStartTime	Required Start Time
RequiredEndDate	Required End Date
RequiredEndTime	Required End Time
NotificationCreationDate	Date of Notification
NotificationCreationTime	Time of Notification

Column Name	Description
NotifProcessingPhase	Notification Processing Phase	Show values

Column Name	Description	Domain name
MaintenanceNotification	null
ReportedByUser	Name of Person Reporting Notification	USNAM
FunctionalLocationLabelName	Functional Location Label	ILOM_STRNO
NotificationText	Short Text	TEXT40
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
LastChangedByUser	Name of Person Who Changed Object	USNAM
IsCompleted	Object is completed	CHAR1
IsDeleted	Object is deleted	CHAR1
NotificationDateTime	null
LastChangeDateTime	null
MainWorkCenter	Work Center	ARBPL
MalfunctionEffectText	Text - Effect on Operation	TEXT40
AssetRoom	Room	CHAR8
MaintenanceWorkCenter	Work Center	ARBPL
LocationDescription	Description of Current Location	PM_LOC_DESC
NotifProcessingPhaseDesc	Short Text for Fixed Values	DDTEXT
MaintPriorityDesc	Priority Text	TEXT20
NotificationTypeName	Notification Type Text	TEXT20
UserIsNotified	null
ChangedDateTime	null
ReporterFullName	Full Name of Person	TEXT80
DateMonitor	null
UserCanBeNotified	null
TechObjectWithLeadingZeros	Technical Object	EAMS_TEC_OBJ
TechObjIsEquipOrFuncnlLoc	Technical Object Type	SYCHAR132
TechnicalObject	Technical Object	EAMS_TEC_OBJ
TechnicalObjectDescription	Technical Object Description	TEXT40
TechObjIsEquipOrFuncnlLocDesc	Description of Technical Object Type	/PLMB/GOS_OTYPE_DESC
TechnicalObjectCategory	null
TechnicalObjectCategoryDesc	Equipment category description	TEXT30
TechnicalObjectType	null
TechnicalObjectTypeDesc	Text for Object Type	TEXT20
AssetManufacturerName	null
ManufacturerPartTypeName	null
ABCIndicator	null
AuthorizationGroup	null

Master Data Relations \| to Other Relations ↓	Join Conditions
Assembly Assembly Client	`C_PMNOTIFICATIONHEADER.ASSEMBLY == MARA.MATNR` `C_PMNOTIFICATIONHEADER.MANDT == MARA.MANDT`
Location of maintenance object Location of maintenance object Location of maintenance object Client Maintenance Plant	`C_PMNOTIFICATIONHEADER.MAINTENANCEOBJECTLOCATION == T499S.STAND` `C_PMNOTIFICATIONHEADER.ASSETLOCATION == T499S.STAND` `C_PMNOTIFICATIONHEADER.MANDT == T499S.MANDT` `C_PMNOTIFICATIONHEADER.MAINTENANCEPLANT == T499S.WERKS`
Business Area Business Area Client	`C_PMNOTIFICATIONHEADER.BUSINESSAREA == TGSB.GSBER` `C_PMNOTIFICATIONHEADER.MANDT == TGSB.MANDT`
Company Code Company Code Client	`C_PMNOTIFICATIONHEADER.COMPANYCODE == T001.BUKRS` `C_PMNOTIFICATIONHEADER.MANDT == T001.MANDT`
Controlling Area Controlling Area Client	`C_PMNOTIFICATIONHEADER.CONTROLLINGAREA == TKA01.KOKRS` `C_PMNOTIFICATIONHEADER.MANDT == TKA01.MANDT`
Cost Center Controlling Area ? Client Cost Center	`C_PMNOTIFICATIONHEADER.CONTROLLINGAREA == CSKS.KOKRS` `C_PMNOTIFICATIONHEADER.[column in domain "DATBI"] == CSKS.DATBI` `C_PMNOTIFICATIONHEADER.MANDT == CSKS.MANDT` `C_PMNOTIFICATIONHEADER.COSTCENTER == CSKS.KOSTL`
Equipment Number Equipment Number Client	`C_PMNOTIFICATIONHEADER.EQUIPMENT == EQUI.EQUNR` `C_PMNOTIFICATIONHEADER.MANDT == EQUI.MANDT`
Functional Location Client Functional Location	`C_PMNOTIFICATIONHEADER.MANDT == IFLOT.MANDT` `C_PMNOTIFICATIONHEADER.FUNCTIONALLOCATION == IFLOT.TPLNR`
Location of maintenance object Location of maintenance object Location of maintenance object Client Maintenance Plant	`C_PMNOTIFICATIONHEADER.MAINTENANCEOBJECTLOCATION == T499S.STAND` `C_PMNOTIFICATIONHEADER.ASSETLOCATION == T499S.STAND` `C_PMNOTIFICATIONHEADER.MANDT == T499S.MANDT` `C_PMNOTIFICATIONHEADER.MAINTENANCEPLANT == T499S.WERKS`
Order Number Order Number Client	`C_PMNOTIFICATIONHEADER.MAINTENANCEORDER == AUFK.AUFNR` `C_PMNOTIFICATIONHEADER.MANDT == AUFK.MANDT`
Maintenance Plant Client Maintenance Plant	`C_PMNOTIFICATIONHEADER.MANDT == T001W.MANDT` `C_PMNOTIFICATIONHEADER.MAINTENANCEPLANT == T001W.WERKS`
Plant for Work Center Plant for Work Center Client	`C_PMNOTIFICATIONHEADER.MAINTENANCEWORKCENTERPLANT == T001W.WERKS` `C_PMNOTIFICATIONHEADER.MANDT == T001W.MANDT`
Priority Priority Priority Type Client	`C_PMNOTIFICATIONHEADER.MAINTPRIORITY == T356.PRIOK` `C_PMNOTIFICATIONHEADER.MAINTPRIORITYTYPE == T356.ARTPR` `C_PMNOTIFICATIONHEADER.MANDT == T356.MANDT`
Priority Type Priority Type Client	`C_PMNOTIFICATIONHEADER.MAINTPRIORITYTYPE == T356A.ARTPR` `C_PMNOTIFICATIONHEADER.MANDT == T356A.MANDT`
Effect on Operation Client Effect on Operation	`C_PMNOTIFICATIONHEADER.MANDT == T357A.MANDT` `C_PMNOTIFICATIONHEADER.MALFUNCTIONEFFECT == T357A.AUSWK`
Notification Category Notification Category Client	`C_PMNOTIFICATIONHEADER.NOTIFICATIONCATEGORY == TQ8T.QMTYP` `C_PMNOTIFICATIONHEADER.MANDT == TQ8T.MANDT`
Time Zone for Notification Time Zone for Notification Client	`C_PMNOTIFICATIONHEADER.NOTIFICATIONTIMEZONE == TTZZ.TZONE` `C_PMNOTIFICATIONHEADER.MANDT == TTZZ.CLIENT`
Notification Type Notification Type Client	`C_PMNOTIFICATIONHEADER.NOTIFICATIONTYPE == TQ80.QMART` `C_PMNOTIFICATIONHEADER.MANDT == TQ80.MANDT`
Plant Section Plant Section Client Maintenance Plant	`C_PMNOTIFICATIONHEADER.PLANTSECTION == T357.BEBER` `C_PMNOTIFICATIONHEADER.MANDT == T357.MANDT` `C_PMNOTIFICATIONHEADER.MAINTENANCEPLANT == T357.WERKS`
Address key assignment to users User Name in User Master Record Client	`C_PMNOTIFICATIONHEADER.REPORTERUSERID == USR02.BNAME` `C_PMNOTIFICATIONHEADER.MANDT == USR02.MANDT`

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	`C_PMNOTIFICATIONHEADER.MAINTENANCEPLANNERGROUP == T024I.INGRP` `C_PMNOTIFICATIONHEADER.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `C_PMNOTIFICATIONHEADER.MANDT == T024I.MANDT`
Maintenance Planning Plant Maintenance Planning Plant Client	`C_PMNOTIFICATIONHEADER.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `C_PMNOTIFICATIONHEADER.MANDT == T399I.MANDT`