Production Order Machine and Labor Time

[cryan_marco]

Hi Experts,

Do you know what table can I access to get the values of Machine and Labor Time of a Production Order? (Activity 1 and 2)

In CO03, it is under Operation Details, then Qty/Activities Tab..

Thanks in advance.

Regards

Brian

[Former Member · Accepted solution]

Hi

Please check in TC20 table (I think you are refering the parameter details)

also you can check in TC21 which is std value key

Reward points if useful

Regards

Ranga

[Former Member · Accepted solution]

Hi

In the table AFRU , you can find actual values instead of parameterIDs in table TC20/TC21.

REgards

YMREDDY

[Former Member · Accepted solution]

Hi Reddy

Thanks

Regards

Ranga

[cryan_marco]

I got it already.

I am using a function module to get the default values.

BAPI_PRODORDCONF_GET_TT_PROP.

Thanks for the help.

[cryan_marco]

Hi YMREDDY,

Thanks for the reply. But still, it doent answer my question.

I am looking for the table where transaction CO11 or CO11n gets it default values for activity 1 (machine) and activity 2 (labor).

If i am not mistaken, AFRU contains the values that are already confirmed.

Please help. Thanks.

Regards

Ryan

[former_member196398]

Hi Brian,

Yes you are right you would get the actual confirmed values from "AFRU" table.

If you want to look for the Production order Operation standard values you need to get them from "AFVV" table the key field is "AUFPL". You need to fetch its value from Order header table "AFKO".

In other words if you create a query on Table join "AFKO" and "AFVV" you should be able to get the required values.

Hope this was useful. Reward your points,

Regards,

Prasobh

[cryan_marco]

Hi Prasobh,

Thanks for the reply. I think your answer is very close. I will need this table to get the default values for machine and labor time.

The problem is the values in CO11N transaction is in Seconds (720 S), but the values in AFVV is in minutes (12 MIN).

The values on CO11N are not always on Seconds, so I cannot just convert.

My question is, how will I know what unit of measure i need to use?

Is there a table I need to check? Or I just misused the table AFVV?

Thanks.

Regards

Ryan

[Former Member]

Hi

award the points

Regards

YMREDDY