on 09-17-2010 2:38 PM
Hi Gurus,
Need help in the scenario below. Thanks in advance.
We want help in a scenario as to how the pricing condition value is determined from KONV,KONP tables.
Let us suppose there is a sales order line with pricing condition PR00. The value is 70 INR as per the condition record value maintained in VK13 transaction.
How do we get this data from the tables? Like is there any tables from where we can that a particluar sales order number and line, this is the value of pricing condition PR00 is 70 INR.
Please also let me know if this can be derived from any table entries
(backdrop : Client is refreshing the system where we are taking the physical backup of data from the tables. So, for any future reference, the data in tables would be checked).
Anyhelp in this regard is deeply appreciated.
Regards,
krishna.
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Let's use condition in a sales order for example.
in table VBAP, the condition record # is on the field VBAP-KNUMV.
Here is the linkages:
VBAP-KNUMV <=> KONH-KNUMH <=> KONP-KNUMH <=> KONM-KNUMH and KONM-KOPOS
<=> KONV-KNUMV and KONV-KPOSN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In VBRK & VBAK You will get the Knumv field value with number, this is nothing but document condition number. With the same number can see in KONV, system will show you all the details of pricing condition values.
Hope this will be helpful to you query.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.