Show product price in DP Planning Book from ECC.

[Former Member]

Hi SAP DP mentors,

I have a business requirement where we need to display the product price in DP Planning book from ECC.  We want to express it as Inventory Value - so the product price is multiplied with the ending inventory in Macro.  Kindly share how to go about this.  Thank you.

Best regards,

Glason

[former_member254329]

Hi, if product price validity date is important for your business, then you should use a key figure and not a characteristic. There are standard pricing extractor from ECC but you might need some custom development to develop your own extractor to fetch the data in the pricing conditions tables as well as change tables from ECC.

Regards

[former_member187488]

Hi Glason,

First the price should be a field in product master. Then you use macro function MAT() or MAT_EXTRA() if the field is location independent, macro function MATLOC() or MATLOC_EXTRA if the field is location dependent, to get the value, and pupulate it into a key figure.
Please refer to Functions for InfoObjects and Planning Folders - Planning Area Administration - SAP Libraryfor these macro functions.

You must assign product/location characteristic in your MPOS if you're using characteristic other than 9AMATNR and 9ALOCNO to make these macro functions work.

BR, Ada