This website is not affiliated with, sponsored by, or approved by SAP AG.

Production Orders status - where it is stored???

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, Gothmog, YuriT

Production Orders status - where it is stored???

Postby Incho on Tue Oct 22, 2002 2:58 am

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) :cry:

Does anybody have any idea/experience about this??

Thanks,
Incho

Ps: My R/3 release is 46C.

Incho
 
Posts: 1537
Joined: Mon Oct 21, 2002 3:32 am
Location: Belgium

Re: Production Orders status - where it is stored???

Postby vishy on Tue Oct 22, 2002 3:09 am

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


Incho wrote: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) :cry:

Does anybody have any idea/experience about this??

Thanks,
Incho

Ps: My R/3 release is 46C.
vishy
 

Order Statuses

Postby RosieBrent on Tue Oct 22, 2002 3:32 am

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 :lol: )

Regards

Rosie
RosieBrent
 
Posts: 6197
Joined: Mon Oct 21, 2002 3:04 am
Location: Darlington

Postby Incho on Tue Oct 22, 2002 4:10 am

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

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 :D
So It worx fine :!:

Thanx,
Incho

Ps for Rosie: Do you really use the expression "Glasgow Kiss" in Glasgow?
Incho
 
Posts: 1537
Joined: Mon Oct 21, 2002 3:32 am
Location: Belgium

JEST etc

Postby RosieBrent on Tue Oct 22, 2002 5:27 am

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
RosieBrent
 
Posts: 6197
Joined: Mon Oct 21, 2002 3:04 am
Location: Darlington

Postby Incho on Tue Oct 22, 2002 5:38 am

Rosie,

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

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

Incho

Ps: Thanks for the language lesson also!!! :D
Incho
 
Posts: 1537
Joined: Mon Oct 21, 2002 3:32 am
Location: Belgium


Return to ABAP

Who is online

Users browsing this forum: No registered users and 12 guests



This website is not affiliated with, sponsored by, or approved by SAP AG.