topic Re: Need Field & Table name in Application Development and Automation Discussions

Need Field & Table name

Former Member — Fri, 20 Nov 2009 10:09:29 GMT

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.

Re: Need Field & Table name

Former Member — Fri, 20 Nov 2009 10:15:52 GMT

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

Revert back if you find any issues...

Re: Need Field & Table name

kesavadas_thekkillath — Fri, 20 Nov 2009 10:19:23 GMT

TJ02,TJ02T,JEST,JCDS

pass the objnr to jest

Try fm STATUS_READ

Re: Need Field & Table name

Former Member — Fri, 20 Nov 2009 10:28:13 GMT

This message was moderated.

Re: Need Field & Table name

former_member206377 — Fri, 20 Nov 2009 10:28:18 GMT

Hi pavan,

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

Re: Need Field & Table name

Former Member — Fri, 20 Nov 2009 10:34:26 GMT

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.

Re: Need Field & Table name

former_member206377 — Fri, 20 Nov 2009 10:43:09 GMT

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?

Re: Need Field & Table name

former_member404244 — Fri, 20 Nov 2009 10:44:48 GMT

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

Re: Need Field & Table name

kesavadas_thekkillath — Fri, 20 Nov 2009 10:47:54 GMT

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

Re: Need Field & Table name

former_member206377 — Fri, 20 Nov 2009 10:55:14 GMT

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.

Re: Need Field & Table name

former_member404244 — Fri, 20 Nov 2009 11:01:12 GMT

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