I need to Clarify "JEST " table

[Former Member]

Hi All,

I need to know the meaning of data stored in the column "STAT" of table JEST.

Example:-

I0001 - ?

I0002 - ?

I0010 - ?

I0016 - ?

I0028 - ?

I0045 - ?

I0056 - ?

I0074 - ?

I0118 - ?

I0215 - ?

I0321 - ?

I0361 - ?

I0369 - ?

I0420 - ?

These are some of the information stored how could I get the meaning of the rest stored in "STAT" column? AND what do they mean by "CHGNR" column?

Thanks,

Kishan

[Former Member]

Hi,

JEST-STAT stores the Equipment status.

These statuses can be "Invoiced", 'Rented', 'Deleted', etc.

You can look into TJ30T for long text of statuses.

Changenr is nothing but the identifier to indicate the number of changes.

There is an inactive flag 'INACT' in JEST.

There can only be one status ACTIVE at any given time.

Hope it helps.

Regards,

Shashank

[Former Member]

Hi Shashank,

The table "TJ30T" didnt have the Status that I have highlighted above. Could U help to find the Table?

Thanks,

Kishan

[Former Member]

Hi,

These are not the texts but the status indicators what you have specified in the earlier post. These are customizing settings and can vary.

TJ30T stores the long texts for these status indicators. for ex. 'I001',etc .

To use the table TJ30T you need to know the Status Profile which is again a customzing done by Functional Consultant.

Have a look at following sample code.

• Get the User Status of the Equipment.

select single objnr from equi into z_objnr

where equnr = t_equnr-equnr.

if sy-subrc = 0.

select single stat from jest into z_stat where

objnr = z_objnr and inact <> 'X'.

if sy-subrc = 0.

select single txt30 from tj30t into z_txt04

where estat = z_stat

and stsma = 'ZEQUIP'.

if sy-subrc = 0.

t_pnwtyh_alv-stat = z_txt04.

endif.

endif.

endif.

Hope it helps.

Regards,

Shashank

[vinod_gunaware2]

This are status of object(USER OR SYSTEM)

suppose u consider equipemnt then u can uss BAPI

• Get user status for Equipemnt

<b>BAPI_EQUI_GETSTATUS</b>

Table use are

<b>TJ30T

JEST

JSTO</b>

Reagards

vinod

[claus_wallacher]

You find the information in table TJ02T, for example

I0001 Created

I0002 Released

I0010 Partially confirmed

I0016 Pre-costed

etc.

Table TJ30T contains the descriptions of user statuses (Exxxx), you are looking for the description of system statuses (Ixxxx).

Regards,

Claus

[Former Member]

Points Awarded accordingly.

Hi Claus,

How did U manage to find the table TJ02T? It solved my problem.

Thanks,

Kishan

[claus_wallacher]

Hi Kishan,

I had to look for this info a while back myself. How did I do it? Start a transaction that displays the text for system status, e.g. display of a project, run the SQL trace while you do it and check the tables that are in this trace.

Regards,

Claus

[Former Member]

Hello Kishan,

I believe these come as a predefined and cannot be maint. by customer. Goto SE11, check the delivery class, it indicates that it is being maint by SAP.