on 02-11-2011 1:27 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.