MM : material netprice update

[Former Member]

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.

[Former Member]

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

Regards!

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

In that case try the function module ME_GET_CONTRACT_CONDITIONS.

[Former Member]

Hi,

Can you explain how this function module can help?

Thanks,

Sobhan.

[Former Member]

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.