Prices List.

[Former Member]

Hi everybody, I need to obtein the list of price for a particular customer, and particular materials. How can i do that?

[Former Member]

Hi everybody, I need to obtein the list of price for a particular customer, and particular materials. How can i do that?

[Former Member]

Hi,

In addition to an unlimited number of price lists, there are other elements that may affect the price given by SBO for an item. These include BP-specific prices, pricelist extensions and discount groups.

The default price for an item is determined as follows:

1. Special price defined for the customer/item ==> Use the special price

2. Discount group specified for the customer ==> Use the discounted price

3. Relevant extensions for the price list found ==> Use the price from price list extension

4. Otherwise, use the price found from the price list specified on the document

This explained in detail in the course material for TB1000 (SBO logistics).

Regards

[Former Member]

Hi,

You can use the following function modules to get the price for a material:

CK21_MATERIAL_PRICES_READ

TP_MATERIAL_PRICES_GET

MSR1_MD_MATPRICE_GETLIST

There is a table called as MBEW(Material Valuation). If you pass the matnr and plant in the BWKEY field, you can get 2 fields :

VERPR - Moving Price

STPRS - Standard Price

<b>Reward if helpful.</b>

[Former Member]

Sorry but the price list that i need is the sales price for a customer, do you know how can i do to obtein that?

Regards

[Former Member]

I did the task, trought the followings tables:

A900 and KONP.