Link Between Cost Balance and production order

[Former Member]

Hi all.

I want to develop a report which will list all the production orders for which Cost Balance is not zero in production order transaction.

So that i can have idea of for which production orders, confirmation is done and i have to do a settlement for that particular production order.

Regards,

Sunny

[Former Member]

Hi,

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 AUFK given the field AUFNR (order no.).

For a completed order, the total will be zero. Hope you may find this workaround useful.

<b>Reward points</b>

Regards

[Former Member]

Hi

Take the data of Productions orders from AUFK,AFKO and AFPO

use table AFRU for Order Confirmations

All order related COSTs use tables COSP, COEP,COST ect by passing OBJNR field and using correct WRTTP field

Reward points for useful Answers

Regards

Anji

[Former Member]

Hi ... here is the list of table for Controlling ...

CEPCT Texts for Profit Center Master Data 
COBRA Settlement Rule for Order Settlement 
COBRB Distribution Rules Settlement Rule Order Settlement 
COKA CO Object- Control Data for Cost Elements 
COSP CO Object- Cost Totals for External Postings 
COSS CO Object- Cost Totals for Internal Postings 
CRCO Assignment of Work Center to Cost Center 
CSKA Cost Elements (Data Dependent on Chart of Accounts) 
CSKB Cost Elements (Data Dependent on Controlling Area)
AFKO Production Order Header 
AFPO Production Order Position (details) 
 

reward points if it is usefulll. ...

Girish

[gopi_narendra]

AFKO is the Production Order Header table.

For the costs use tables COSP, COEP,COST with the OBJNR field.

Regards

Gopi