topic Re: Prices List. in Application Development and Automation Discussions

Prices List.

Former Member — Fri, 03 Aug 2007 14:17:43 GMT

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

Re: Prices List.

Former Member — Fri, 03 Aug 2007 14:23:13 GMT

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

Re: Prices List.

Former Member — Fri, 03 Aug 2007 14:25:48 GMT

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>

Re: Prices List.

Former Member — Fri, 03 Aug 2007 21:51:34 GMT

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

Re: Prices List.

Former Member — Wed, 15 Aug 2007 13:39:29 GMT

I did the task, trought the followings tables:

A900 and KONP.