Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

link between notification status and notification number..very very urgent

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

3 REPLIES 3

Former Member
0 Kudos

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

Former Member
0 Kudos

by using OBJNR of QMEL with JEST.

Regards

Peram

Former Member
0 Kudos

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.