topic Re: JEST Table in Application Development and Automation Discussions

JEST Table

Former Member — Thu, 30 Aug 2007 07:44:22 GMT

Hi!

What is jest table what data does it hold.

Thanks.

Re: JEST Table

Former Member — Thu, 30 Aug 2007 07:49:58 GMT

hai rahul,

you should not pose each and every question here

try to find yourself u hav the table name

goto se11 and check it out.

if u find yourself you won't forget the things ok

regards

ramesh.

Re: JEST Table

Former Member — Thu, 30 Aug 2007 07:52:45 GMT

Hi,

JEST table holds the status of the Production Order (PP), Inspection lot status (QM), Project status (PS).

For example:

For a production order, fetch OBJNR from AUFK table.

Then for this OBJNR goto JEST table to get the status.

For fetching status texts got TJ02T.

data: wk_objnr type J_OBJNR,

wk_status type J_STATUS,

wk_statustext type J_TXT30.

select objnr from AUFK into wk_objnr

where aufnr = prodorder.

select STAT from JEST into wk_status

where objnr = wk_objnr.

select TXT30 from TJ02T into wk_statustext

where ISTAT = wk_status.

wk_statustext gives the production order status.

best regards,

Thangesh

Re: JEST Table

Former Member — Thu, 30 Aug 2007 07:53:33 GMT

Hi !

It holds the state informations of equipments.

It's OBJNR comes from EQUI-OBJNR.

Hope that helped a bit.

Rainer

Some points would be nice.

Re: JEST Table

Former Member — Thu, 30 Aug 2007 07:53:59 GMT

JEST

IT shows the

<u><b>Individual Object Status</b></u>

these are the fields

MANDT MANDT CLNT 3 0 Client

OBJNR J_OBJNR CHAR 22 0 Object number

STAT J_STATUS CHAR 5 0 Object status

INACT J_INACT CHAR 1 0 Indicator: Status Is Inactive

CHGNR J_CHGNR NUMC 3 0 Change number

Re: JEST Table

Former Member — Thu, 30 Aug 2007 07:57:11 GMT

good

Table JEST gives the system /user status associated with an order

thanks

mrutyun^

Re: JEST Table

Former Member — Thu, 30 Aug 2007 07:58:05 GMT

hi rahul,

when u create a sales order, and generate serial numbers according to it, the serial nunbers profile are kept as avialable. You can check it using transaction IQ09, by giving the material number there.

In JEST you could enter the OBJNR i.e the object number and check the status, whether it is available or no.

is your query cleared.

rewards points if useful

thanks

nayan