Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

MM : material netprice update

Former Member
0 Kudos

Hi,

The management team updates the price of the material once in 3 months period. I am trying to pull up the updated price value thru EKPO-Netprice field and displaying on the report. But the report is displaying the previous cycle value than the current value. Is EKPO-Netprice is the right field to pull up the updated value?

What is the right way to pull up the value?

Thanks,

Sobhan.

10 REPLIES 10

Former Member
0 Kudos

Hi, I usually get valuation from table MBEW. Take a look to it.

Regards!

Former Member
0 Kudos

Purchase order is transaction data and that implies that it is time-dependent. So EKPO-NETPR is the net price of the material at the time when the PO is created. If you have to obtain the material price then go to MBEW.

0 Kudos

Hi,

I tried with the fields STPRS and LPLPR in MBEW table. But that didn't work. Can someone explain what field in the table MBEW can contain current price? or should I link to another table from MBEW?

Thanks,

Sobhan.

0 Kudos

Hi Sobhan,

Exactly where do your business people update the material price? Are they maintaining the material master--> Accounting view? Or is it the PR00 condition type price that you are talking about?

Please explain what you meant by 'current price'. Where do you see it in your system, on the material master or on the POs?

Srinivas

0 Kudos

Srinivas,

Thanks for the great help.

They do update the price thru ME32K transaction code. ME32K is Change contracts. The material price is changed once in 3 months. (The changed value will have validity period beginning from the changed time to future time.) The requirement is to pull this new value into the report. If I use EKPO-netpr it is pulling previous value.

I have also used the MBEW table fields: STPRS and LPLPR.

But no luck.

Thanks,

Sobhan.

0 Kudos

That sounds like pricing conditions. Go to the contract display and select an item. Look at its pricing details. You will probably see some condition types and some amounts associated with them. If you are seeing your price here, let us know.

Srinivas

0 Kudos

Hi,

I have displayed the contract thru ME33K. I can see the current price there. I can see the date validity conditions such as valid on 2/1/2005 - 8/1/2005 and valid on 8/2/2005 - 12/31/9999. For each valid date range there is a price.

Thanks,

Sobahn.

0 Kudos

In that case try the function module ME_GET_CONTRACT_CONDITIONS.

0 Kudos

Hi,

Can you explain how this function module can help?

Thanks,

Sobhan.

0 Kudos

Pass the import parameters and it will return the condition records for you. Loop through that conditions table and identify your conditions for each line item.