Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

Tags:
Former Member
replied

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 bobjnr eq aobjnr

join tj02t as c

on cistat eq bstat

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 bobjnr eq aobjnr

join tj30t as c

on cestat eq bstat

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---

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question