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