I_QltyNotificationTaskVH

Search for Quality Notification Task | view: IQNOTIFTSKVH | 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
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
NotificationCompletionDate Date for Notification Completion
Column Name Description
NotificationOrigin Origin of Notification Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
QualityTask null
NotificationTaskText Short Text for Task TEXT40
ResponsiblePerson Person Responsible for Task (Partner Number) I_PARNR
NotificationText Short Text TEXT40
CreatedByUser Name of Person Responsible for Creating the Object USNAM
Master Data Relations Join Conditions
Account Number of Customer
  • Account Number of Customer
  • Client
  • I_QLTYNOTIFICATIONTASKVH.CUSTOMER == KNA1.KUNNR
  • I_QLTYNOTIFICATIONTASKVH.MANDT == KNA1.MANDT
Notification Type
  • Client
  • Notification Type
  • I_QLTYNOTIFICATIONTASKVH.MANDT == TQ80.MANDT
  • I_QLTYNOTIFICATIONTASKVH.NOTIFICATIONTYPE == TQ80.QMART
Time zone for task
  • Client
  • Time Zone for Task
  • I_QLTYNOTIFICATIONTASKVH.MANDT == TTZZ.CLIENT
  • I_QLTYNOTIFICATIONTASKVH.NOTIFTASKTIMEZONE == TTZZ.TZONE
Plant for Material
  • Client
  • Plant for Material
  • I_QLTYNOTIFICATIONTASKVH.MANDT == T001W.MANDT
  • I_QLTYNOTIFICATIONTASKVH.PLANT == T001W.WERKS
Quality Task Origin
  • Quality Task Origin
  • Client
  • I_QLTYNOTIFICATIONTASKVH.QUALITYTASKORIGIN == TQTASKORIGIN.TASKORIGIN
  • I_QLTYNOTIFICATIONTASKVH.MANDT == TQTASKORIGIN.MANDT
Partner Function: Person/Department Responsible
  • Partner Function: Person/Department Responsible
  • Client
  • I_QLTYNOTIFICATIONTASKVH.RESPONSIBLEPERSONFUNCTIONCODE == TPAR.PARVW
  • I_QLTYNOTIFICATIONTASKVH.MANDT == TPAR.MANDT
Supplier Account Number
  • Client
  • Supplier Account Number
  • I_QLTYNOTIFICATIONTASKVH.MANDT == LFA1.MANDT
  • I_QLTYNOTIFICATIONTASKVH.SUPPLIER == LFA1.LIFNR