production order duration

[Former Member]

I need to create a report with the help of Abap'er where i should fetch the duration i.e. Hours required for production order QTY and after completion of partial or 50 % of the quantity then i should fetch a remaining time for the remaining 50 % qty.

I tried for the table but i could not hence required SAP gurus help ..

Edited by: srinivasch ch on Jan 23, 2009 8:42 PM

[Former Member · Accepted solution]

Hi,

Try using the following BAPI for fetching the data

BAPI_PRODORDCONF_GET_TT_PROP

Hope it addresses your query

Warm regards,

Umesh Poojari

[Former Member · Accepted solution]

thank you for the information but mine is 3.1i were BAPI might not be support can i use any RFC ..?

please suggest for the RFC...

[Former Member · Accepted solution]

Hi,,

The remaining dates will not be updated in the system.

1. You can go to the table AFKO.In the table you can get the basic dates and times and from that you can find out the duration of the total production order.(By calaulating difference of basic start & finish dates and times).

2.You can get the target and actual quantity from AFPO and AUFM tables.(AUFM :-101-102 quantity).

3. From point 2 you can get the remaining quantity.

3. Based on the time from point 1 you can get the time required from remaining quantity from point 2.

Hope that will help you.

regards,

kaushik

[Former Member · Accepted solution]

As per the first point it seems it is fetching from Lead time scheduling and calculating through routing.

there for the field duration in production order -->Operation Dtaes fetches the duration but it is a structure hence searching for table from where we can calculate for remaining qty's duration.

For example

Po qty : 1000

in stock : 500

Duration for 1000 (will be displayed in operation dates of production order)

Remaining Qty = 1000- 500

Remaining = 500

here required time need to be claculated for remaining qty i.e. 500.

[Former Member]

Hi,

Hope there is no updation of the remaining time in any of the Production order tables. As a standerd, sytem proposes the same during Confirmation.

So the activity time should be calculated by the time taken from the standard values in the routing. Try the same by creating a formula by considering the Production order qty and the Confirmed qty.

-Thaila Shree