cancel
Showing results for 
Search instead for 
Did you mean: 

Active Lots - table needed

Former Member
0 Kudos

I need to select al activa lots (no long term or no short term left) to be able to send them down to XI and through to the lab-system.

Where can i find active lots (for example status INSP) in a table or in any other whay do a query for this? Cant find any userful status in table QALS for this purpose.

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Andreas,

To get inspection lot status INSP follow these steps

1. from QALS table - Get object number of Inspection lot

2. System status are stored in JEST table , but these are 5 digit number ( for example INSP status =I0212)

3. You can get all the status number from TJ02 table

You can either build SQVI query

or configure selection profile and use QA33 transaction to get the results

Former Member
0 Kudos

Thank you! Solved!

Answers (0)