cancel
Showing results for 
Search instead for 
Did you mean: 

Reg fetching the Contract Price, List price per customer for each item

Former Member
0 Kudos

Hi,

I know that this might be a basic question in sap sd, but the truth is that I am new to SAP SD, and the requirement is really confusing. I have consulted with the Functional Guys here but it makes me more confused.

It would be great if I could get some material on the issue. I have searched the forums but found nothing similar to my scenario.

Basically there are 2 kinds of prices for each customer within my system. A list price and a contract price.

I understand that list price can be found for all the items for my customer by the below method.

Get all items for the customer from KNMT Table. get the condition records(KUNMH) for these Materials from A091 table and finally get KBETR (price) based on the condition record from the KONP table. This would be termed as list price.

The second price is Contract price. This would either be a value or a percentage of the list price and would come into play only if a contract exists for the customer.

My questions are as follows:

1. Is my assumption for getting the List price sensible/ logical

2. How to check if a contract exists for a customer and also find the condition types to arrive at contract price. (I assume this has to do something with condition types, but not sure how to use that in code)

Any help which would point me in the right direction would be appreciated.

Cheers,

Mz

Edited by: Mazin Mahmood on Jul 1, 2011 5:40 PM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi, I got some clarifications for the questions below.

1. Is my assumption for getting the List price sensible/ logical.

A) Pricing is basically configured in the system. Best way to get it is to simulate a sales order using bapisimulatesales*order(if you are working on orders) and get the resulting prices for the items.

2. How to check if a contract exists for a customer and also find the condition types to arrive at contract price. (I assume this has to do something with condition types, but not sure how to use that in code)

A) Contracts can be found in VBAK table. they are not directly related to prices, they contain items which have prices.

Cheers,

Mz

0 Kudos

Get all items for the customer from KNMT Table. get the condition records(KUNMH) for these Materials from A091 table and finally get KBETR (price) based on the condition record from the KONP table. This would be termed as list price-

Hi have you checked in system before writing the above.

Check for contaracts what pricing procedure is defined and the condition type. further ther are settings in Sales doc header to refer to contract if the customer has one.

so, when you are releasing an order against referring to contract the prices willbe copied from the same.