How to determine value of PO account assignment item

[pokrakam]

G'Day,

Simple question: I'm after a cost breakdown of a PO at account assignment level. For this I need to determine the value of an account assignment item in a consistent manner. e.g. if a PO item has an account assignment split across multiple cost centers then I need the value against each cost center. Very straightforward in theory, however in practice the value field in EKKN is not always filled. Some account assignment categories use percentages, others use quantities and others use values or combinations thereof.

I can code this quite easily, but the examples I've seen for different account assignment categories are a bit too random for my liking. I don't know if I will catch every option so I would prefer some SAP function module or something similar, which I have thus far been unable to find. Does anyone have a method using standard SAP?

Input appreciated,

Mike

[Former Member]

Dear Mike,

Try report ME2K with Cost center using *, account assignment K, plant and posting date restrictions.

This report will give you the purchasing document - cost center wise quantity distribution details (irrespective of either Quantity or Percentage distribution in Purchase order).

Only part missing is - in this report you will get ordered price / per unit and cost center wise allotted quantity, the value (Price per unig X cost center wise allotted qty) you didnt get. This can get if the data transferred to excel.

I hope this will help the requirement.

Regards,

Syed Hussain.

[Former Member]

Dear Mike,

Try report ME2K with Cost center using *, account assignment K, plant and posting date restrictions.

This report will give you the purchasing document - cost center wise quantity distribution details (irrespective of either Quantity or Percentage distribution in Purchase order).

Only part missing is - in this report you will get ordered price / per unit and cost center wise allotted quantity, the value (Price per unig X cost center wise allotted qty) you didnt get. This can get if the data transferred to excel.

I hope this will help the requirement.

Regards,

Syed Hussain.

[pokrakam]

Hi,

Thanks for the feedback. I was looking for a way to do this programmatically (hence mentioning function module) and for any account assignment category - cost center was just an example.

For what it's worth, I ended up coding it myself. I found that the value field in EKKN was unreliable, sometimes it would have '0.01' for an item with a qty of 0 and other such nonsense, so I ignored it completely and calcluated it based on quantity or percentage fields.

Cheers,

Mike