Prices for VA21

[Former Member]

Hello All,

I need to select prices stored in VA21 tranasction against sales quotation.However I am not find releavant tables for this.

Please can anyone let me know how to fetch the prices and condition types.Is there any FM,

Thanks in advance.

[christian_wohlfahrt]

Hi!

The conditions are stored in table KONV. Key can be found in VBAK-KNUMV, line numbers are same as in VBAP.

Currently I can't check, but also FM BAPI_PRICES_CONDITIONS might give you the desired result.

Regards,

Christian

[Former Member]

Thanks a lot Christian .Your input has helped me to get the prices for VA21.

I have additional requirement to get the prices from ME47 line items and copy them to VA21 transaction.

I have found the source.They Are stored in table KONP.But the problem is I am not able to get the condition no KNUMH in EKKO or EKPO table.How do I link these prices to EKKO table/EKPO table.

[Former Member]

Hi Amruta,

Follow this step.

GOto transaction spro.

Sales and Distribution>Basic Functions > Pricing > Pricing control.

Under this you can see the pricing procedure, condition type, condition tables, etc.

This will surely help you. Contents of the condition record is only finally stored in konv and konp.

Hope thsi helps.

Reg,

PP

[christian_wohlfahrt]

Hi!

But after conditions are read like defined in customizing, user can change values in a purchase order / contract...

So you better read conditions linked to the document, EKKO-KNUMV is the link to table KONV.

Regards,

Christian

[Former Member]

Hi Christian,

This link is fine.But the prices I need to fetch are stored in KONP .(These r prices related to line items of the Quotation(ME47 transaction).

However they are not linked to either EKKO or EKPO.

Do you have any idea on this.

Thanks in advance

Amruta

[christian_wohlfahrt]

Hi Amruta!

I had a look into transaction ME49 and found following FM: ME_PRICING_DIALOG (include FM06IFAP_DATEN_SELEKTION_AP). It's called dialog, but can also run without popup (set dunkel = 'X'). Looks like mainly purchasing view is needed as import.

Regards,

Christian