C_ObjPgMaintNotification

Maintenance Notification | view: COBJPGMAINTNOTIF | Extraction: Not supported | Component: Maintenance Processing

Tables used: QMEL, QMFE, QMSM, AFIH, AFKO, QMMA, QMIH, JSTO, JEST, DMS_DOC2LOIO, DMS_PHIO2FILE, DMS_PH_CHKO_CD1, DRAD, T370C, T370C_T, BUT000, EAM_OSTAT_SPH, EAM_OSTAT_SPH_T, EQUI, EQKT, EQUZ, IFLOS, IFLOS, IFLOT, IFLOT, IFLOTX, QPCD, QPGR, T499S, ILOA, T353I, T353I_T, MPOS, AUFK, MPLA, T399W, T399W_T, NRIV, T352R, T357A, T357A_T, MARA, MAKT, T003O, T001W, T357, ADCP, ADR6, ADRC, ADRP, USR21, T356, T356_T, T356A, NRIV, TQ80, TQ80_T, T356A_T, CRTX, USR21, TJ30, TJ30T, CRHD, DMS_DOC_FILES, DMS_PHF_CD1, DMS_PH_CD1, DRAD_LAST_CHANGE, ADR2, ADR2, ITOBCUST, IFLOUSR, T024I, T350, TPAER

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (17)
☰ Categorical (4)
Other (85)
🔗 Relations (31)

Column Name	Description
MaintenanceNotification	Notification Number

Column Name	Description

Column Name	Description

Column Name	Description
LatestAcceptableCompletionDate	Final Due Date
CreationDate	Date on which the record was created
CreationTime	Time at Which Record Was Added
CompletionTime	Completion Time of Notification
NotificationCompletionDate	Date for Notification Completion
NotificationReferenceTime	Notification Reference Time
NotificationReferenceDate	Notification Reference Date
InspectionDate	Date of Technical Inspection
MalfunctionStartDate	Start of Malfunction (Date)
MalfunctionStartTime	Start of Malfunction (Time)
MalfunctionEndDate	End of Malfunction (Date)
MalfunctionEndTime	End of Malfunction (Time)
RequiredStartDate	Required Start Date
RequiredStartTime	Required Start Time
RequiredEndDate	Required End Date
RequiredEndTime	Required End Time
BasicStartDate	Start date

Column Name	Description
WorkCenterTypeCode	Object types of the CIM resource	Show values
MaintenanceObjectIsDown	Breakdown Indicator	Show values
MaintPlanTechObjIsEquipment	Technical Object Type	Show values
RequiredStartEndDateAdjust	Adjustment of the Requirement/Start Data	Show values

Column Name	Description	Domain name
NotificationText	Short Text
NotificationTypeName	Notification Type Text
TechnicalObjectLabel	Technical Object Identifier	EAMS_TECH_OBJ_CONV
TechnicalObjectDescription	Technical Object Description
FunctionalLocationName	Description of functional location	TEXT40
EquipmentName	Description of technical object	TEXT40
TechObjIsEquipOrFuncnlLoc	Technical Object Type
TechObjIsEquipOrFuncnlLocDesc	Description of Technical Object Type
MaintenanceOrderDesc	Description
MainWorkCenter	Work Center
MainWorkCenterText	Work Center Text
MainWorkCenterPlantName	Plant Name
MaintPriorityColorCode	null
MaintPriorityDesc	Priority Text
ConcatenatedActiveSystStsName	Concatenated System Status
NotifProcessingPhase	Notification Processing Phase
NotifProcessingPhaseDesc	Short Text for Fixed Values
MaintenancePlanningPlantName	Plant Name
MaintenancePlannerGroupName	Name of the Maintenance Planner Group
MaintenanceWorkCenter	Work Center
MaintenanceWorkCenterText	Work Center Text
PersonResponsible_H	Person Responsible ID	I_PARNR
PersonResponsible	Person Responsible
PersonResponsibleName	Person Responsible Name
ABCIndicatorDesc	Description of ABC Indicator of Technical Object
ConcatenatedActiveUserStsName	Concatenated User Status
InspectedByUser	Name of Person Responsible for Technical Inspection
InspectedByUserDescription	User Description
ReportedByUser	Name of Person Reporting Notification	USNAM
ReportedByUserDescription	User Description
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
CreatedByUserDescription	User Description
AssemblyName	Material Description
MaintObjectDowntimeDuration	Breakdown Duration	FLTP
MaintenanceRevision	Revision for Plant Maintenance and Customer Service	REVNI
MaintenanceRevisionDesc	Revision description
MaintenanceActivityTypeName	Description of maintenance activity type
MaintenanceWorkCenterPlantName	Plant Name
AssetLocationName	Location Name	TEXT40
AssetRoom	Room	CHAR8
MaintenancePlantName	Plant Name
PlantSectionPersonRespName	Group of Employees Responsible for Company Area
PlantSectionPersonRespPhone	Phone Number of Employee Group Responsible for Company Area
MaintObjectFreeDefinedAttrib	Sort Field	CHAR30
MaintenancePlanDesc	Maintenance Plan Text
MaintenanceItem	Maintenance item	POSNU
MaintenanceItemDescription	Item Short Text
MaintenancePlanCategoryDesc	Text, 40 Characters Long
MaintPlanCnctntdActvSystSts	Concatenated System Status
MaintPlanTechnicalObjectLabel	Technical Object Identifier	EAMS_TECH_OBJ_CONV
MaintPlanTechnicalObjectDesc	Technical Object Description	TEXT40
MaintPlanTechObjIsEquipDesc	Description of Technical Object Type	/PLMB/GOS_OTYPE_DESC
LastSchedldMaintNotifText	Short Text
NotifNmbrOfAttachedDocuments	null
NumberOfMaintNotifItems	null
NumberOfMaintNotifTasks	null
NumberOfMaintNotifActivities	null
MaintPriorityTypeDesc	Priority Type Text	TEXT20
IsCompleted	Checkbox
IsDeleted	Checkbox
MaintNotificationLongText	Long Text
MaintNotificationCode	Code	QCODE
MaintNotificationCodeGroup	Code Group	QCODEGRP
TechObjectWithLeadingZeros	Technical Object	EAMS_TEC_OBJ
AuthorizationGroup	Technical Object Authorization Group	IAUTG
FunctionalLocationLabelName	Functional Location Label	ILOM_STRNO
MaintenancePlanInternalID	Object number	J_OBJNR
MaintNotifWithLeadingZeros	Character Field of Length 12	CHAR12
MaintenanceOrderType	Order Type	AUFART
NotificationHasLongText	Object Long Text Available	CHAR1
TechnicalObject	Technical Object	EAMS_TEC_OBJ
UserStatus	null
StatusName	null
StatusProfile	Status Profile
NmbrOfOpenMaintNotifications	Number of Open Notifications	DEC9
MaintNotificationThumbnailURL	null
ChangeDocObjectClass	null
MaintNotifProcessPhaseCode	Process Phase
MaintNotifProcessSubPhaseCode	Process Subphase
EAMProcessSubPhaseCodeDesc	Description of Overall Process Subphase	TEXT40
EAMProcessPhaseCodeDesc	Short Text for Fixed Values	DDTEXT
MalfunctionEffectText	Text - Effect on Operation	TEXT40
MaintNotifDetectionCatalog	Detection Method Profile
MaintNotifDetectionCode	Detection Method
MaintNotifDetectionCodeGroup	Detection Method Group

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object ABC Indicator for Technical Object Client	`C_OBJPGMAINTNOTIFICATION.ABCINDICATOR == T370C.ABCKZ` `C_OBJPGMAINTNOTIFICATION.MANDT == T370C.MANDT`
Assembly Assembly Client	`C_OBJPGMAINTNOTIFICATION.ASSEMBLY == MARA.MATNR` `C_OBJPGMAINTNOTIFICATION.MANDT == MARA.MANDT`
Location of maintenance object Location of maintenance object Client Maintenance Plant	`C_OBJPGMAINTNOTIFICATION.ASSETLOCATION == T499S.STAND` `C_OBJPGMAINTNOTIFICATION.MANDT == T499S.MANDT` `C_OBJPGMAINTNOTIFICATION.MAINTENANCEPLANT == T499S.WERKS`
Controlling Area Controlling Area Client	`C_OBJPGMAINTNOTIFICATION.CONTROLLINGAREA == TKA01.KOKRS` `C_OBJPGMAINTNOTIFICATION.MANDT == TKA01.MANDT`
Cost Center ? Cost Center Controlling Area Client	`C_OBJPGMAINTNOTIFICATION.[column in domain "DATBI"] == CSKS.DATBI` `C_OBJPGMAINTNOTIFICATION.COSTCENTER == CSKS.KOSTL` `C_OBJPGMAINTNOTIFICATION.CONTROLLINGAREA == CSKS.KOKRS` `C_OBJPGMAINTNOTIFICATION.MANDT == CSKS.MANDT`
Equipment Number Equipment Number Client	`C_OBJPGMAINTNOTIFICATION.EQUIPMENT == EQUI.EQUNR` `C_OBJPGMAINTNOTIFICATION.MANDT == EQUI.MANDT`
Functional Location Technical Object Functional Location Client	`C_OBJPGMAINTNOTIFICATION.MAINTENANCEPLANTECHNICALOBJECT == IFLOT.TPLNR` `C_OBJPGMAINTNOTIFICATION.FUNCTIONALLOCATION == IFLOT.TPLNR` `C_OBJPGMAINTNOTIFICATION.MANDT == IFLOT.MANDT`
Catalog Catalog Catalog Client	`C_OBJPGMAINTNOTIFICATION.INSPECTIONCATALOG == TQ15.KATALOGART` `C_OBJPGMAINTNOTIFICATION.MAINTNOTIFICATIONCATALOG == TQ15.KATALOGART` `C_OBJPGMAINTNOTIFICATION.MANDT == TQ15.MANDT`
Code Group Code Group Code Group Catalog Catalog Client	`C_OBJPGMAINTNOTIFICATION.INSPECTIONCODEGROUP == QPGR.CODEGRUPPE` `C_OBJPGMAINTNOTIFICATION.MAINTNOTIFICATIONCODEGROUP == QPGR.CODEGRUPPE` `C_OBJPGMAINTNOTIFICATION.INSPECTIONCATALOG == QPGR.KATALOGART` `C_OBJPGMAINTNOTIFICATION.MAINTNOTIFICATIONCATALOG == QPGR.KATALOGART` `C_OBJPGMAINTNOTIFICATION.MANDT == QPGR.MANDT`
Maintenance Activity Type Maintenance Activity Type Client	`C_OBJPGMAINTNOTIFICATION.MAINTENANCEACTIVITYTYPE == T353I.ILART` `C_OBJPGMAINTNOTIFICATION.MANDT == T353I.MANDT`
Order Number Order Number Client	`C_OBJPGMAINTNOTIFICATION.MAINTENANCEORDER == AUFK.AUFNR` `C_OBJPGMAINTNOTIFICATION.MANDT == AUFK.MANDT`
Maintenance Plan Maintenance Plan Client	`C_OBJPGMAINTNOTIFICATION.MAINTENANCEPLAN == MPLA.WARPL` `C_OBJPGMAINTNOTIFICATION.MANDT == MPLA.MANDT`
Maintenance Plant Client Maintenance Plant	`C_OBJPGMAINTNOTIFICATION.MANDT == T001W.MANDT` `C_OBJPGMAINTNOTIFICATION.MAINTENANCEPLANT == T001W.WERKS`
Technical Object Technical Object Functional Location Client	`C_OBJPGMAINTNOTIFICATION.MAINTENANCEPLANTECHNICALOBJECT == IFLOT.TPLNR` `C_OBJPGMAINTNOTIFICATION.FUNCTIONALLOCATION == IFLOT.TPLNR` `C_OBJPGMAINTNOTIFICATION.MANDT == IFLOT.MANDT`
Plant for Work Center Plant for Work Center Client	`C_OBJPGMAINTNOTIFICATION.MAINTENANCEWORKCENTERPLANT == T001W.WERKS` `C_OBJPGMAINTNOTIFICATION.MANDT == T001W.MANDT`
Catalog Catalog Catalog Client	`C_OBJPGMAINTNOTIFICATION.INSPECTIONCATALOG == TQ15.KATALOGART` `C_OBJPGMAINTNOTIFICATION.MAINTNOTIFICATIONCATALOG == TQ15.KATALOGART` `C_OBJPGMAINTNOTIFICATION.MANDT == TQ15.MANDT`
Partner Function: Person/Department Responsible Partner Function: Person/Department Responsible Client	`C_OBJPGMAINTNOTIFICATION.MAINTNOTIFRESPPARTNERFUNCTION == TPAR.PARVW` `C_OBJPGMAINTNOTIFICATION.MANDT == TPAR.MANDT`
Unit for Breakdown Duration Unit for Breakdown Duration Client	`C_OBJPGMAINTNOTIFICATION.MAINTOBJDOWNTIMEDURATIONUNIT == T006.MSEHI` `C_OBJPGMAINTNOTIFICATION.MANDT == T006.MANDT`
Priority Priority Type Client Priority	`C_OBJPGMAINTNOTIFICATION.MAINTPRIORITYTYPE == T356.ARTPR` `C_OBJPGMAINTNOTIFICATION.MANDT == T356.MANDT` `C_OBJPGMAINTNOTIFICATION.MAINTPRIORITY == T356.PRIOK`
Priority Type Priority Type Client	`C_OBJPGMAINTNOTIFICATION.MAINTPRIORITYTYPE == T356A.ARTPR` `C_OBJPGMAINTNOTIFICATION.MANDT == T356A.MANDT`
Plant Plant Client	`C_OBJPGMAINTNOTIFICATION.MAINWORKCENTERPLANT == T001W.WERKS` `C_OBJPGMAINTNOTIFICATION.MANDT == T001W.MANDT`
Effect on Operation Effect on Operation Client	`C_OBJPGMAINTNOTIFICATION.MALFUNCTIONEFFECT == T357A.AUSWK` `C_OBJPGMAINTNOTIFICATION.MANDT == T357A.MANDT`
Notification Category Notification Category Client	`C_OBJPGMAINTNOTIFICATION.NOTIFICATIONCATEGORY == TQ8T.QMTYP` `C_OBJPGMAINTNOTIFICATION.MANDT == TQ8T.MANDT`
Notification Type Notification Type Client	`C_OBJPGMAINTNOTIFICATION.NOTIFICATIONTYPE == TQ80.QMART` `C_OBJPGMAINTNOTIFICATION.MANDT == TQ80.MANDT`
Plant Section Plant Section Client Maintenance Plant	`C_OBJPGMAINTNOTIFICATION.PLANTSECTION == T357.BEBER` `C_OBJPGMAINTNOTIFICATION.MANDT == T357.MANDT` `C_OBJPGMAINTNOTIFICATION.MAINTENANCEPLANT == T357.WERKS`
Foreign key work center Work Center Work Center Object ID of the Work Center ? Client	`C_OBJPGMAINTNOTIFICATION.MAINTENANCEWORKCENTER == CRID.OBJID` `C_OBJPGMAINTNOTIFICATION.MAINWORKCENTER == CRID.OBJID` `C_OBJPGMAINTNOTIFICATION.WORKCENTERINTERNALID == CRID.OBJID` `C_OBJPGMAINTNOTIFICATION.[column in domain "CR_OBJTY"] == CRID.OBJTY` `C_OBJPGMAINTNOTIFICATION.MANDT == CRID.MANDT`

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