condition table creation

[Former Member]

Dear All,

i have a requirement to create a condition table for discounts based on below criteria

1) we 2 types of customers 1) whole sale and 2) special customers

we need to give discounts based on

1) sales organization

2) distribution channel

3) customer group ( wholesale or special customer )

4) brand ( based on the brand also we have discounts )

kindly advise how to map brand in the condition table

with regards

Mohammed Raees

[Former Member · Accepted solution]

Hi,

> 1) we 2 types of customers 1) whole sale and 2) special customers

For customers, you can group the customer like wholesaler and special customers. For this maintain value in Customer master - Sales Area data - Sales view - in customer group field

You can maintain these values in OVS9

> 4) brand ( based on the brand also we have discounts )

For brands, again you can group materials according to material group

e.g. all materials with X brand will come under X mate. grp., and all materials with Y brand will come under Y mate. grp.,

You can enter these values in material master - sales: sales org 1 view

You can maintain these values in OVS9

Create condition table having all these fields along with sales org and distr. channel

Create Access seq and assign the created table

Assign Access seq to condition type and put the cond. type in pricing proc.

Create cond. record for the cond. type in VK11

Try this and post your feedback

regards,

Sagar

[Former Member · Accepted solution]

Dear Sagar Wagh,

you have suggested a feasible solution and the concept is quite clear.

with regards

Mohammed Raees

[Former Member · Accepted solution]

Dear Sagar

can i use material pricing group instead of material group and what could be the difference in using both the options i.e

material group and material pricing group

with regards

Mohammed

[Former Member · Accepted solution]

SAP recommendsto use Material pricing group for pricing related tables and Price Group in customer master data for pricing related tables.

Customer Group and Material Group are more widely usedfor reporting purposes.

Regards

Sai

[Former Member · Accepted solution]

Yes, you can very well use material pricing group. In fact you should use that only because as already suggested by our friend Material group and Customer group are mainly used for reporting purpose.

You can use Material Pricing Group for grouping material and price group or price list from pricing point of view.

regards,

Sagar

[jignesh_mehta3]

I guess in your Company, each brand would be a different Material Code...

If yes then Take material Code as a creteria in creating Condition Table...

Hope this helps...

Thanks,

Jignesh mehta