PRICING CONDITIONS

[Former Member]

Hi,

In which table (not structure) the Pricing Conditions being stored like Basic Price with the Valid From & Valid to Date.

Also give me a Transaction code from where I can download the list of Basic Price on my system. Through VK13 it is not possible.

Regards,

Vishal

[Former Member]

Done.

[Former Member]

The base table will depend on your access sequence. For each access, the system maintains a separate table Annn and this contains the base information. The standard access sequence for condition PR00 is PR00 and that uses table A005, A006 and A004.

For example the access :

- Sales Org/Dist Chan/Material

for condition PR00 is table A005.

If you look at the data in A005 you will see the following fields :

- Condition type

- Sales org

- Dist Chan

- Material

- Valid to

- Valid from

- Condition record number

You can now use the last field, condition record number, to access KONH and KONP.

Regards,

Brian

[Former Member]

hi Vishal

Check these tables related to pricing.

KONV Conditions for Transaction Data

KONP Conditions for Items

KOND Conditions (Data)

KONH Conditions (Header)

KONM Conditions

A000 Condition Table for Pricing $

T684 Condition Exclusion Groups

T684G Condition Exclusion Groups: Condition Types

T684S Condition Exclusion: Procedure Assignment

T689 Download Profile for the Conditions

T689K Reference: Download Profile - Pricing Procedures

Regards

Vishal

[former_member183879]

Hi Vishal,

Try KONP, KONH

You have to know the condition tables for which you want the basic prices related data.

Once you know that,

Go to KONP, get all the values of KONP-KNUMV

No go to the condition table in SE16

Give KONP-KNUMV as the input selection criteria

Get the output

This will give the values, valid from and Valid to, the variant key for which the value is maintained and so on.

Hope this helps.

Pls reward if this helps.

[Lakshmipathi]

Dear Vishal

1) In table KONV, all conditions types is stored

2) Go to V/LD, maintain 08 in Pricing Report and execute. Just give your sales area and execute. You will have customer wise the pricing condition with effective validity dates.

thanks

G. Lakshmipathi

[Former Member]

Hi Lakshmi,

well your answer has solved my problem. Thanks for this.

But now from where I will get the Condition record No. for KONP Table.

Regards,

Vishal

[former_member183879]

KONP-KNUMV is the field

[alpesh_saparia3]

Condition record no you will get from KONH table, depending on your condition table, condition type and condition key (which contains the combination of different fields like you price is maintained at Material-Customer-Plant level, then combination willl be MaterialCustomerPlant) and validity period.

-Alpesh

[Lakshmipathi]

Dear Vishal

Go to SE16 / VBAK and execute so that you will get list of all sale orders. In that list, on the right side, there is a field "Document conditions" under which some numeric value will flow.

Copy that and again go to SE16 now give KONP and execute. Here there is a field Document condition. Paste those references here and execute.

You will get the required report.

thanks

G. Lakshmipathi