COEP Table - aggregated data

[Former Member]

Hello,

Is there any way to make COEP to display just the total value for an object (column Value/Obj. Crcy)

Right now it displays the costs for every confirmation... and if I have thousands of confirmations per order therefore I won't be able to run a query for several orders.

What I want is to get just the totals... or the costs by cost element (totalazing it by cost element will mean about 10 records/order which is bearable).

Thanks a lot!

[RaymondGiuseppi]

COEP is "Line Items ", try to use COSS/COSP "Cost Totals for Internal/External Postings" which are already aggregated. (Don't forget to filter on value type (WRTTP) equal to 04 for actual postings, as not only COEP is aggregated here)

Regards,

Raymond

[former_member194152]

If you want record return based on cost element then use COSP table before and prepare a key to access COEP table, attaching herewith a code snapshot :

Thanks,

Gagan

[Former Member]

Thanks guys!

So there's no way to use COEP? Because it seems that I don't have access to COSP.

[RaymondGiuseppi]

What do you mean by

Because it seems that I don't have access to COSP.

Else, you could try table PMCO "Cost structure of maintenance order" or similar tables, but the cost elements are grouped in "value category" (Which kind of orders are you looking for)

As you are writing on "confirmations" that could be internal costs (COSS) like employee work time costs and not external costs (COSP) like purchase order cost or material consumption from stock.

Regards,

Raymond