cancel
Showing results for 
Search instead for 
Did you mean: 

Condition amount bases on the sales office

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

problem is solved. table A906 contain the combination of sales organisation, distrubution chanle and sales office.

Thanks

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

RBM
Active Participant
0 Kudos

This message was moderated.

Former Member
0 Kudos

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

RBM
Active Participant
0 Kudos

Ok, tables you need: KONH and KONP.

first use the KONH to get the KNUMH field and then go to KONP to get the price.

for these tables you need to access using the pricing condition.

Regards!

Former Member
0 Kudos

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

RBM
Active Participant
0 Kudos

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!