I_DFS_MaintNotificationStruc

Interface view for Notification Struc | view: IDFSNOTIFSTRUC | Extraction: Not supported | Component: Maintenance (S/4)
Tables used: QMELQMIHJSTOJESTEQUIEQKTEQUZIFLOTIFLOTXILOAMARAMAKTT356T356_TCRTXTJ02TJ02TTJ30TJ30TCRHDT024I
Column Name Description
Equipment Equipment Number
MaintenanceNotification Notification Number
Column Name Description
Column Name Description
Column Name Description
RequiredStartDate Required Start Date
RequiredStartTime Required Start Time
RequiredEndDate Required End Date
RequiredEndTime Required End Time
CreationDate Date on which the record was created
Column Name Description
DfsMaintTechStsAggrgnIsStppd Stop Technical Status Aggregation Here Show values
Column Name Description Domain name
DfsMaintEquipmentType null
DfsMaintEquipTechStatusProfile Status Profile J_STSMA
FunctionalLocationName Description of functional location TEXT40
EquipmentName Description of technical object TEXT40
NotificationText Short Text TEXT40
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
CreatedByUser Name of Person Responsible for Creating the Object USNAM
DfsMaintNotificationObjectNmbr Object number J_OBJNR
DfsMaintNotifTechStsShortName Individual status of an object (short form) TEXT4
DfsMaintNotifTechStsLongName Object status TEXT30
DfsMaintNotifUserStsShortName null
DfsMaintNotifSystStsShortName null
DfsMaintExplosionType null
DfsMaintEquipmentUtilizerID null
Material Material Number MATNR
MaterialName Material Description TEXT40
MaintenancePlannerGroupName Name of the Maintenance Planner Group TEXT18
MaintPriority Priority PRIOK
MaintPriorityDesc Priority Text TEXT20
DfsMaintNotifTechStatusProfile Status Profile J_STSMA
DfsMaintTechStsIconURL null
TechObjectWithLeadingZeros null
Master Data Relations Join Conditions
Functional Location
  • Functional Location
  • Client
  • I_DFS_MAINTNOTIFICATIONSTRUC.DFSMAINTFUNCTIONALLOCATION == IFLOT.TPLNR
  • I_DFS_MAINTNOTIFICATIONSTRUC.MANDT == IFLOT.MANDT
Order Number
  • Order Number
  • Client
  • I_DFS_MAINTNOTIFICATIONSTRUC.MAINTENANCEORDER == AUFK.AUFNR
  • I_DFS_MAINTNOTIFICATIONSTRUC.MANDT == AUFK.MANDT
Plant for Work Center
  • Plant for Work Center
  • Client
  • I_DFS_MAINTNOTIFICATIONSTRUC.MAINTENANCEWORKCENTERPLANT == T001W.WERKS
  • I_DFS_MAINTNOTIFICATIONSTRUC.MANDT == T001W.MANDT
Notification Type
  • Notification Type
  • Client
  • I_DFS_MAINTNOTIFICATIONSTRUC.NOTIFICATIONTYPE == TQ80.QMART
  • I_DFS_MAINTNOTIFICATIONSTRUC.MANDT == TQ80.MANDT
Foreign key work center
  • Object ID of the Work Center
  • Work Center
  • ?
  • Client
  • I_DFS_MAINTNOTIFICATIONSTRUC.WORKCENTERINTERNALID == CRID.OBJID
  • I_DFS_MAINTNOTIFICATIONSTRUC.WORKCENTER == CRID.OBJID
  • I_DFS_MAINTNOTIFICATIONSTRUC.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_DFS_MAINTNOTIFICATIONSTRUC.MANDT == CRID.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
  • Client
  • I_DFS_MAINTNOTIFICATIONSTRUC.[column in domain "IWERK"] == T024I.IWERK
  • I_DFS_MAINTNOTIFICATIONSTRUC.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_DFS_MAINTNOTIFICATIONSTRUC.MANDT == T024I.MANDT