topic Re: COEP Table - aggregated data in Application Development and Automation Discussions

COEP Table - aggregated data

Former Member — Thu, 04 Oct 2012 07:56:31 GMT

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!

Re: COEP Table - aggregated data

RaymondGiuseppi — Thu, 04 Oct 2012 08:16:37 GMT

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

Re: COEP Table - aggregated data

former_member194152 — Thu, 04 Oct 2012 08:30:13 GMT

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

Re: COEP Table - aggregated data

Former Member — Thu, 04 Oct 2012 09:04:33 GMT

Thanks guys!

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

Re: COEP Table - aggregated data

RaymondGiuseppi — Thu, 04 Oct 2012 09:48:27 GMT

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