06-11-2007 12:32 PM
hi...
i want to know link between notification status and notification number..
My slection screen consists of..
<b>Notification Status Selection Criteria (With Drop down List box)
Default Value = New
Notification Creation Date Selection Criteria
Sourcing Plant / Group Selection Criteria
Downs Owner Parameter (With Search Help)
Part Number Parameter (With Search Help)
Sales Order No. Selection Criteria
Customer No. (Sold To) Selection Criteria (With Search Help) </b>
Based on the data entered by the user in the Selection Screen, the report should go to Tables QMEL, VBAK, VBAP, KNA1, MARA, MAKT etc to get the Notification, Sales Order Line Item, Customer and Material Master information
<b>But notification status is a text field in TJ30T table field is TXT04.
but i dont find any link to retrieve the data based on notification status</b>
Message was edited by:
madhavi pilla
06-11-2007 12:36 PM
I think you need to include the table JEST which stores the link between the object and status. Note that this table stores the status of all objects (production order, maintenance order,sales order etc).
award if it helps
Krishna
06-11-2007 12:36 PM
I think you need to include the table JEST which stores the link between the object and status. Note that this table stores the status of all objects (production order, maintenance order,sales order etc).
award if it helps
Krishna
06-11-2007 12:42 PM
06-11-2007 12:47 PM
Hi Madhavi,
Notification number is the document number for which you are creating a notification,
Ex. You need a spare part for a equipment, So you create a notification (u will get the notification number).
While creating the sales order refering the notification, the status of the notification changes to SOAS.
This status tells us the preseding operations done refering the Notification number
Regards,
Rusidar.