Skip to Content
avatar image
Former Member

condition table creation

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 14, 2010 at 09:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • Apr 14, 2010 at 09:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded