C_QltyNotificationFDP

Header Data of Quality Notification | view: CQLTYNOTIFFDP | TRAN | Extraction: Not supported | Component: Quality Notifications
Tables used: AFVC, QAOP, QMEL
Column Name Description
QualityNotification Notification Number
Column Name Description
Column Name Description
📏 Unit of Measure (NotificationQuantityUnit):
NotificationComplaintQuantity Complaint Quantity
NotificationInternalQuantity Defective Quantity (Internal)
NotificationExternalQty Defective Quantity (External)
NotificationReferenceQuantity General Reference Quantity
NotifReturnDeliveryQuantity Return Delivery Quantity
Column Name Description
CreationDate Date on which the record was created
LastChangedDate Last Changed On
NotificationCreationTime Time of Notification
NotificationReportingDate Date of Notification
NotificationCompletionDate Date for Notification Completion
NotificationRequiredStartDate Required start date
NotificationRequiredStartTime Required Start Time
NotificationRequiredEndDate Required End Date
NotificationRequiredEndTime Required End Time
CustomerPurchaseOrderDate Customer Reference Date
NotificationReturnDeliveryDate Date of Return Delivery
Column Name Description
NotificationOrigin Origin of Notification Show values
NotifProcessingPhase Notification Processing Phase Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description Domain name
MasterLanguage Master Language SPRAS
NotificationText Short Text TEXT40
IsDeleted Delete Data Record CHAR1
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
NotificationCodeID Code QCODE
ReportedByUser Name of Person Reporting Notification USNAM
MfgOrderInternalID Plan Number for Operations in Order (Production Order) AUFPL
OrderOperationInternalID Current Node Number from Order Counter KNTNR
MaterialDocumentYear Material Document Year GJAHR
MaterialDocument Number of Material Document BELNR
MaterialDocumentItem Item in Material Document MBLPO
AdditionalDeviceData Additional Device Data DEVICEID
NotificationExtReferenceNumber External Reference Number CHAR020
PurchaseOrderByCustomer Customer Reference BSTKD
OrderOperation Operation or Phase Number VDM_VORNR
OperationText Operation Short Text TEXT40
Master Data Relations Join Conditions
Division
  • Client
  • Division
  • C_QLTYNOTIFICATIONFDP.MANDT == TSPA.MANDT
  • C_QLTYNOTIFICATIONFDP.ACTIVEDIVISION == TSPA.SPART
Batch Number
  • Material Number
  • Batch Number
  • Client
  • C_QLTYNOTIFICATIONFDP.MATERIAL == MCH1.MATNR
  • C_QLTYNOTIFICATIONFDP.BATCH == MCH1.CHARG
  • C_QLTYNOTIFICATIONFDP.MANDT == MCH1.MANDT
Account Number of Customer
  • Client
  • Account Number of Customer
  • C_QLTYNOTIFICATIONFDP.MANDT == KNA1.MANDT
  • C_QLTYNOTIFICATIONFDP.CUSTOMER == KNA1.KUNNR
Distribution Channel
  • Client
  • Distribution Channel
  • C_QLTYNOTIFICATIONFDP.MANDT == TVTW.MANDT
  • C_QLTYNOTIFICATIONFDP.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Foreign key work center
  • Object types of the CIM resource
  • Client
  • Object ID of the Work Center
  • C_QLTYNOTIFICATIONFDP.WORKCENTERTYPECODE == CRID.OBJTY
  • C_QLTYNOTIFICATIONFDP.MANDT == CRID.MANDT
  • C_QLTYNOTIFICATIONFDP.MAINWORKCENTERINTERNALID == CRID.OBJID
Plant for Work Center
  • Plant for Work Center
  • Client
  • C_QLTYNOTIFICATIONFDP.MAINWORKCENTERPLANT == T001W.WERKS
  • C_QLTYNOTIFICATIONFDP.MANDT == T001W.MANDT
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • C_QLTYNOTIFICATIONFDP.MANUFACTURER == LFA1.LIFNR
  • C_QLTYNOTIFICATIONFDP.MANDT == LFA1.MANDT
Material Number
  • Material Number
  • Client
  • C_QLTYNOTIFICATIONFDP.MATERIAL == MARA.MATNR
  • C_QLTYNOTIFICATIONFDP.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_QLTYNOTIFICATIONFDP.MATERIALGROUP == T023.MATKL
  • C_QLTYNOTIFICATIONFDP.MANDT == T023.MANDT
Catalog Type - Coding
  • Catalog Type - Coding
  • Client
  • C_QLTYNOTIFICATIONFDP.NOTIFICATIONCATALOG == TQ15.KATALOGART
  • C_QLTYNOTIFICATIONFDP.MANDT == TQ15.MANDT
Code Group - Coding
  • Code Group - Coding
  • Catalog Type - Coding
  • Client
  • C_QLTYNOTIFICATIONFDP.NOTIFICATIONCODEGROUP == QPGR.CODEGRUPPE
  • C_QLTYNOTIFICATIONFDP.NOTIFICATIONCATALOG == QPGR.KATALOGART
  • C_QLTYNOTIFICATIONFDP.MANDT == QPGR.MANDT
Priority
  • Priority Type
  • Priority
  • Client
  • C_QLTYNOTIFICATIONFDP.NOTIFICATIONPRIORITYTYPE == T356.ARTPR
  • C_QLTYNOTIFICATIONFDP.NOTIFICATIONPRIORITY == T356.PRIOK
  • C_QLTYNOTIFICATIONFDP.MANDT == T356.MANDT
Priority Type
  • Priority Type
  • Client
  • C_QLTYNOTIFICATIONFDP.NOTIFICATIONPRIORITYTYPE == T356A.ARTPR
  • C_QLTYNOTIFICATIONFDP.MANDT == T356A.MANDT
Unit of Measure
  • Unit of Measure
  • Client
  • C_QLTYNOTIFICATIONFDP.NOTIFICATIONQUANTITYUNIT == T006.MSEHI
  • C_QLTYNOTIFICATIONFDP.MANDT == T006.MANDT
Notification Type
  • Notification Type
  • Client
  • C_QLTYNOTIFICATIONFDP.NOTIFICATIONTYPE == TQ80.QMART
  • C_QLTYNOTIFICATIONFDP.MANDT == TQ80.MANDT
Plant for Material
  • Client
  • Plant for Material
  • C_QLTYNOTIFICATIONFDP.MANDT == T001W.MANDT
  • C_QLTYNOTIFICATIONFDP.PLANT == T001W.WERKS
Order Number (Production Order)
  • Order Number (Production Order)
  • Client
  • C_QLTYNOTIFICATIONFDP.PRODUCTIONORDER == AUFK.AUFNR
  • C_QLTYNOTIFICATIONFDP.MANDT == AUFK.MANDT
Production Version
  • Production Version
  • Client
  • ?
  • ?
  • C_QLTYNOTIFICATIONFDP.PRODUCTIONVERSION == MKAL.VERID
  • C_QLTYNOTIFICATIONFDP.MANDT == MKAL.MANDT
  • C_QLTYNOTIFICATIONFDP.[column in domain "MATNR"] == MKAL.MATNR
  • C_QLTYNOTIFICATIONFDP.[column in domain "WERKS_D"] == MKAL.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • C_QLTYNOTIFICATIONFDP.PURCHASINGGROUP == T024.EKGRP
  • C_QLTYNOTIFICATIONFDP.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_QLTYNOTIFICATIONFDP.PURCHASINGORGANIZATION == T024E.EKORG
  • C_QLTYNOTIFICATIONFDP.MANDT == T024E.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_QLTYNOTIFICATIONFDP.SALESORGANIZATION == TVKO.VKORG
  • C_QLTYNOTIFICATIONFDP.MANDT == TVKO.MANDT
Supplier Account Number
  • Client
  • Supplier Account Number
  • C_QLTYNOTIFICATIONFDP.MANDT == LFA1.MANDT
  • C_QLTYNOTIFICATIONFDP.SUPPLIER == LFA1.LIFNR