How can I get SD pricing conditions list as in VA01 without creating SO?

[Former Member]

Hi Guys,

I have searched a lot of posts for this answer but only found that it's not possible to do through function 'PRICING' without creating SO document.

My initial input is: sales organization, distribution channel, customer, material number, pricing date. Can I find relevant pricing conditions based on this info? I need to make a report, which would display all pricing conditions with values based on the selection parameters mentioned earlier. Thanks for any help.

[Former Member]

There is a bapi funciton BAPI_SALESORDER_SIMULATE which allows to you simulate the creation of an order for sales org, customer, material, pricing date without actually creating an order.

This will return the pricing conditions in the table parameter ORDER_CONDITION_EX

[Former Member]

Hi,

You can check the table A609. In this table you can get condition record number A609-KNUMH. Based on that you can get the amount from KONP table KONP-KBETR.

In this process you can also check the pricing date.

[Former Member]

Seems like Paul's idea is brilliant, wanted to do the same with BAPI_CREATE_FROM_DAT... didn't know about the SIMULATE.. need to try and will get back to you. Thanks.

[former_member191735]

Use function module 'PRICING'

This is a pretty big task interms of collecting all the required data.

Check where used list for pricing. This is used in 2 places. Put a break point on them and run your sales order transaction. See what are the fields passing through.

You can also determine from KOMK and KOMP . One for customer and the other for material. Make sure you pass all the data that is required.

You will get results of conditions in importing table. (may be konv)

Using simulate will actually creates a document number (i believe). Even though this will not be available in VBAK, VBAP... the number will be taken off from the sales order number range.

I have used PRICING function module in of my work.

[Former Member]

BAPI_SALESORDER_SIMULATE is what I need Paul, thanks a lot, you've saved me a lot of time.

Maybe PRICING could also work, but did not try to pass all of those KOMP, KOMV parameters.. actually you still have to pass KOMV - the list of conditions to do pricing for.. or maybe not, anyway i did not find any code sample for PRICING and not willing to waste time on writing my own, it's actually used in VA01, but it uses lots of parameters from previous processing.

A609 is not active in my system, so can't use it.