I_QltyNotificationTask

Quality Notification Task | view: IQNOTIFTSK | TRAN | Extraction: Not supported | Component: Quality Notifications
Tables used: QMELQMSM
Column Name Description
QualityNotification FK Notification Number
NotificationTask Sequential Task Number
Column Name Description
Column Name Description
Column Name Description
NotifTaskPlannedStartDate Planned Start Date
NotifTaskPlannedStartTime Planned Start Time for Task
NotifTaskPlannedEndDate Planned Finish Date
NotifTaskPlannedEndTime Planned Finish Time for Task
NotifTaskCompletionDate Date on Which the Task Was Completed
NotifTaskCompletionTime Time at Which Task Was Completed
NotifTaskResubmissionDate Date on Which Task Was Resubmitted
NotifTaskResubmissionTime Time at Which Task Was Resubmitted
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Added
LastChangeDate Last Changed On
LastChangeTime Time of Change
Column Name Description
NotifProcessingPhase Notification Processing Phase Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
QualityTask null
NotificationTaskText Short Text for Task TEXT40
IsDeleted Delete Data Record CHAR1
NotifTaskCompletedByUser Person Who Completed the Task USNAM
ResponsiblePerson Person Responsible for Task (Partner Number) I_PARNR
NotificationTaskSortNumber Sort Number for Task NUMC04
QualityTaskCode Task Code QCODE
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Notification Type
  • Client
  • Notification Type
  • I_QLTYNOTIFICATIONTASK.MANDT == TQ80.MANDT
  • I_QLTYNOTIFICATIONTASK.NOTIFICATIONTYPE == TQ80.QMART
Time zone for task
  • Client
  • Time Zone for Task
  • I_QLTYNOTIFICATIONTASK.MANDT == TTZZ.CLIENT
  • I_QLTYNOTIFICATIONTASK.NOTIFTASKTIMEZONE == TTZZ.TZONE
Plant for Material
  • Client
  • Plant for Material
  • I_QLTYNOTIFICATIONTASK.MANDT == T001W.MANDT
  • I_QLTYNOTIFICATIONTASK.PLANT == T001W.WERKS
Catalog Type - Tasks
  • Client
  • Catalog Type - Tasks
  • I_QLTYNOTIFICATIONTASK.MANDT == TQ15.MANDT
  • I_QLTYNOTIFICATIONTASK.QUALITYTASKCODECATALOG == TQ15.KATALOGART
Code Group - Tasks
  • Client
  • Catalog Type - Tasks
  • Code Group - Tasks
  • I_QLTYNOTIFICATIONTASK.MANDT == QPGR.MANDT
  • I_QLTYNOTIFICATIONTASK.QUALITYTASKCODECATALOG == QPGR.KATALOGART
  • I_QLTYNOTIFICATIONTASK.QUALITYTASKCODEGROUP == QPGR.CODEGRUPPE
Quality Task Origin
  • Client
  • Quality Task Origin
Function of Person Responsible for Task
  • Client
  • Function of Person Responsible for Task
  • I_QLTYNOTIFICATIONTASK.MANDT == TPAR.MANDT
  • I_QLTYNOTIFICATIONTASK.RESPONSIBLEPERSONFUNCTIONCODE == TPAR.PARVW