on 11-18-2009 6:21 PM
Hello Experts,
I need to take the condition value amount ( Basic Price ZG02) based on the selection creiteria
sales org, distrubution chanel, divsion and sales office for particular material.
In our organisation basic price is different for different sales office.
How can i retrive condtion amount depending on sales org , distrubution chanel, division and sales office
for particular material.
Thanks in advance.
Regards,
Sai
problem is solved. table A906 contain the combination of sales organisation, distrubution chanle and sales office.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You can get Sales Org, Distibution Channel, Division, Sales Office and Condition record number (KNUMV) from VBAK.
You can also refer KONP for the condition record number (KNUMH).
Best Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your reply.
ya i know table konv and konp.
but my problem is i have to retrive basic price based on sales org, dist chanel, division and sales office.
In our organisation basic price is different for different sales office.
so i have to retrive based on sales office also.
Rgerds,
sai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Table KONV and KONP is stores the applied sales order pricing condition records.
to get the pricing condition record table KONH to get the KNUMH field and then go to KONP to get the condition price.
if there is an access sequance exits with sales office with condition record, you will get there.
regards
Vivek.
Thanks for your reply.
we have already the combination sales organsation, dist chanel , division and sales office.
i have to write the program in which i have to select basic price for materials bases on sales org, dist chanel, division and sales office.
which table or transaction code i have to find data.
regards,
sai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For this you have to create a new condition table for that combination.
Go to Tx: V/03
Give a number around 900.
Press Enter.
Then from "FieldCatlg" section double click on below fields sequentially.
Use UP & DOWN keyboard buttons to go up & down in that section.
Sales Organization
Distribution Channel
Division
Sales Office
Material
Then press on GENERATE button (RED color circle)
Then you condition table generation is over.
Now you can create a new access sequence or assign that table number to your existing access sequence from this IMG Path.
SPRO / Sales and Distribution / Basic Functions / Pricing / Pricing Control / Define Access Sequences / Maintain Access Sequences
Assign that access sequence to your condition type from
SPRO / Sales and Distribution / Basic Functions / Pricing / Pricing Control / Define Condition Types / Maintain Condition Types
Then in VK11, Enter your condition type and press enter.
If you add that condition table to a existing Access Seq, pop up will appear.
Select the relevant table and go in.
Enter relevant Sales Organization/ Distribution Channel/ Division/ Sales Office and,
maintain prices for each Material in that combination.
Now create a new sales order for that combination and see whether price is coming.
Best regards,
Anupa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Define a new condition table (V/03) using the fields you need.
Then add this new table on the access sequence associated to your condition ZG02.
Hope this help.
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 |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.