Production Orders status - where it is stored???

[Incho]

I am writting a production order overview report.


In which table is stored the production order status?
I mean the status which displayed on the header (eg REL PRT DLV PRC GMPS SETC...).

In the F1 help it is CAUFVD-STTXT, but CAUFVD is a structure. I found CAUFV as a view (AFKO+AUFK), but this info is not stored there.
I guess it is not stored in any database table, it is "calculated" from different other statuses (eg confirmation status)

Does anybody have any idea/experience about this??

Thanks,
Incho

Ps: My R/3 release is 46C.

[vishy]

u can try

the following function module.

STATUS_TEXT_EDIT

give object no and language

u can get the status text...


Hope it helps u.........

Vishy

I am writting a production order overview report.


In which table is stored the production order status?
I mean the status which displayed on the header (eg REL PRT DLV PRC GMPS SETC...).

In the F1 help it is CAUFVD-STTXT, but CAUFVD is a structure. I found CAUFV as a view (AFKO+AUFK), but this info is not stored there.
I guess it is not stored in any database table, it is "calculated" from different other statuses (eg confirmation status)

Does anybody have any idea/experience about this??

Thanks,
Incho

Ps: My R/3 release is 46C.

[RosieBrent]

Status information is held in table JEST Incho.

You will be able to find the short forms (INCO etc.) in that table.

(Can't be more specific, as company I now work for doesn't use PP )

Regards

Rosie

[Incho]

Hi guys,

thanks

vishy:
I checked the table JEST, it is store a status for object. If I use OR00000{Prod Ord Number} as an object number I got back the status, but I couldn't find out how to decode it (like I0001, I0361)...probable there is a table to link the description and this code, but I coulnt' find it

Rosie:
Function Module STATUS_TEXT_EDIT is coooool!!!!
I couldn't know how to link order number and object, but from table JEST, I picked up the object number and I got back the order status text
So It worx fine

Thanx,
Incho

Ps for Rosie: Do you really use the expression "Glasgow Kiss" in Glasgow?

[RosieBrent]

Incho

Answers were the other way round - Vishy gave you the Function module

TJ02T will allow you to decode the statuses if you feed in the status and the language.

Apparently they use the term 'Glasgow Kiss' outside of Glasgow, but inside they just say something along the lines of 'You got a problem wi' me pal?'
(Although I can't truely comment, as I am an English girl who moved up here a year ago from Somerset)

Ciao4Now

[Incho]

Rosie,

you' re right I mixed up the order a little bit

TJ02T is the table I was looking for.
THANKS!!!!
Meanwhile I found transaction BS23 to display system status

Incho

Ps: Thanks for the language lesson also!!!