cancel
Showing results for 
Search instead for 
Did you mean: 

Production order cost information in table

former_member224727
Active Participant
0 Kudos

Can you help me to find out the table where SAP system save production order cost relavent information?

I'm looking for table of field:

Target actual cost

Total actual cost

Target/actual var

Target acctual variance %

Currency

Labor cost

material handling cost

These information you can find production order menu Goto --> costs --> Analysis.

Please understand I'm looking for table field not standard report.

Help appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

Hello,

Check table COEP (CO Object: Line Items (by Period) is the table).

Here is where all the costs posted to the Production order is stored by CO document. Please run this table for the object number of the order. This is the storage for the t-code KOB1 Actual line items of an order.  You may  have to get the total of the line items.

You can find the object number (OBJNR) of the production order in the table <b>AUFK</b> given the field AUFNR (order no.). 

Hope the information was helpful.

Regards

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I am facing same problem can u please specify

field for

actual cost

target actual cost

In table COEP.

former_member184655
Active Contributor
0 Kudos

Dear Eric,

As already suggested you can get the object number from CAUFV by passing the order number and pass on

this object number to table COEP.

Regards

Mangalraj.S

former_member224727
Active Participant
0 Kudos

Yes, I can find value in COEP table but having difficulty to understand table data.

When I'm checking data in production order there are 50 line items,but when I check @ COEP there are 70 line items. For labor cost I have one line value of $40 in order while in table I have 4 line items with each $10..so total is same, but why I have multiple line item at table level?

Please help to understand this.

Former Member
0 Kudos

hi Eric ,

You can check table COSS and COSP for planned and actual cost from goods movement or confirmation.

regards,

Arman Lie

former_member224727
Active Participant
0 Kudos

Yes, these two tables are helpful, but again these table does not give me exact line item as order. So still I'm having difficulty to understand the data in table.

COSS having internal posting & COSP having external posting. Now how can I differentiate these two in system at order level at following path?

Order Menu Goto --> cost --> analysis?

Reply appreciated.