Object status - Get description instead of code (J_STATUS) for OBJNR

[Former Member]

Hi,

I am modifying a report, in which one of the fields on output is "Object status," which is pulled from table "Jest". The field is called "Stat" and pertains to the specific OBJNR (object number.)

However, the status is a code (5 Char) but the user wants to see a description instead. Where can I get the description data for the status from?

Thanks,

John

[kathryn_mcgallicher]

Hello,

I think you may be talking about the statuses held in tables TJ02T and TJ30T (4.64). If yes, here's how we get to them:

f_system_status type j_stsma.

f_user_status type j_stsma.

select single c~txt04

into (f_system_status)

from equi as a

join jest as b

on b_{objnr eq a}objnr

join tj02t as c

on c_{istat eq b}stat

where a~sernr = i_old-sernr and

a~eqtyp = 'I' and

not b~inact = 'X' and

c~istat like 'I%' and

c~spras = 'EN'.

select single c~txt04

into (f_user_status)

from equi as a

join jest as b

on b_{objnr eq a}objnr

join tj30t as c

on c_{estat eq b}stat

where a~sernr = i_old-sernr and

a~eqtyp = 'I' and

not b~inact = 'X' and

c~stsma eq 'CPS-DEV1' and

b~stat like 'E%'.

Hope this helps!

K---

[Former Member]

Hi John,

Try this Table TJ03T.

Pass Object Category and Language to get text.

Ali