Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 21, 2007 at 01:00 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 01:05 PM

    Hi John,

    Try this Table TJ03T.

    Pass Object Category and Language to get text.

    Ali

    Add comment
    10|10000 characters needed characters exceeded