Logic to catpur production order status

[Former Member]

I'm developing new rpeort for production order.What is Logic to catpur production order status by considering posting date of GR?

Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Check whehther following logic work for ur report.

To capture posting date (BUDAT) pass order number (AUFNR) from table AUFM into table AFRU

To capture system status of order number, pass order number (AUFNR) from AUFM into database table CAUFV to get object number (OBJNR).

Pass object number (OBJNR) into table JEST to capture status (STAT) of production order for Release (STAT= I0002) & technically completed (STAT= I0045).

Then pass STAT into table TJ02T to get description of status.

Regrads,

Sanjay

[former_member199502]

Hi,

Go To AUFM table take the order number(AUFNR) and input in the CAUFV table.from CAUFV table take object number(OBJNR).input this OBJNR in JEST table and STAT value.Input this STAT value in TJ02T table u will get the status of the production order.Hope it helps.

If your query is answered please close the thread by giving points.

[former_member196398]

Ravi,

Can you please re explain your requirment and scenario?

Regards,

Prasobh

[Former Member]

null

Edited by: Sanjay Hebali on Mar 27, 2009 11:45 AM

Edited by: Sanjay Hebali on Mar 27, 2009 11:45 AM

[former_member189817]

Input Posting date in AUFM and get the order number and inpit it to with Prefix 'OR' and leading zeros in 'JEST' where you will get Status object and input valid status to TJ02T where you will get Status description.

AUFM-TJ02T-JEST