Need Field & Table name

[Former Member]

Hi SAP Gurus,

In the transaction qa03, after entering inspection lot and pressing Enter, there is a field "System Status". Can i know from where i can pick it from database table with respect to lot number. Please help.

Thanks and Regards,

Pavan.

[Former Member]

Hi Pavan,

If you would liek to get the status that I mentioend in my previous reply , Here's how you do it :

1) Pass the OBJNR value to table JEST and get the STAT where INACT = ' '.

2) Pass these STAT to table TJ02 and get teh value of TXT04.

This is how you can get the status text like CRTD(Created) REL (Released) TECO(TEchnically Co0mpleted) etc.

[Former Member]

try tables QALS,QAVE OR QAMB,it might help you out...

Revert back if you find any issues...

[Former Member]

This message was moderated.

[kesavadas_thekkillath]

TJ02,TJ02T,JEST,JCDS

pass the objnr to jest

Try fm STATUS_READ

[Former Member]

Hi Vasuki and Keshu,

I have tried as you have suggested, from there i am able to get a field called status , but what i actually want is the field which is present in qa03 .(system status).

Thanks & Regards,

Pavan.

[former_member206377]

Hi Pavan,

In the field system status that you have mentioned, there may be status such as SPCO ICCO ARBL CRTD so on.. do you want to get this?

[former_member404244]

Hi,

Check the below piece of code provided by SAP... Put a break point in the program LQPL1O0O and in the below FM..You will get the text in field rmqea-statustext.

The value C_KREUZ is having value 'X'.

and qals-objnr eq 'QL<inspectionlotnumber>.

Please see what you are getting in you system

call function 'STATUS_TEXT_EDIT'
     exporting
          flg_user_stat     = c_kreuz
          objnr             = qals-objnr
          only_active       = c_kreuz
          spras             = sy-langu
     importing
          anw_stat_existing = rmqea-kz_anwstat
          line              = rmqea-statustext
          user_line         = rmqea-anw_status
     exceptions
          object_not_found  = 01.
if sy-subrc = c_rc01.
  message x004 with 'OBJECT NOT FOUND LQPL1O10'.
endif.

Regards,

Nagaraj

[kesavadas_thekkillath]

pass the objnr in qals to jest objnr

then pass status to TJ02

gt the status from jest where inact = space.

Refer JCDS to get the latest status by considering the field UDATE UTIME.

These are the status related tables.

JEST - Object Status

JCDS - Change Documents for Statuses

JSTO - Status Object Information

JCDO - Change Documents for Status Objects

TJ02 - System Statuses

TJ03 - Object Types

TJ04 - Status Control for Object Type

TJ20 - Status Profiles

TJ30 - User Statuses

TJ02T - Text for system status

TJ30T - Text for user status.

Edited by: Keshu Thekkillam on Nov 20, 2009 4:21 PM

[former_member404244]

Hi Pavan,

Sorry in my earlier post i didn't mentioned how to trigger the program.. You can trigger it after u press enter after giving inspection lot number in QA03 tocde.

Regards,

Nagaraj

[former_member206377]

Hi pavan,

For this you will have to pass teh OBJNR to JEST table and get the system status from field STAT .

[former_member206377]

Hi Pavan,

If you would liek to get the status that I mentioend in my previous reply , Here's how you do it :

1) Pass the OBJNR value to table JEST and get the STAT where INACT = ' '.

2) Pass these STAT to table TJ02 and get teh value of TXT04.

This is how you can get the status text like CRTD(Created) REL (Released) TECO(TEchnically Co0mpleted) etc.