Skip to Content
author's profile photo Former Member
Former Member

Discount need to be given based on material for the fixed quantity for each customer

Dear Experts,

i Have Requirement, Discount to be given based on material for the fixed quantity for each customer.

Example: Let us Consider Customer A buys - Material X -100 Quantity then 20% Discount will be given.He may give 100 quantity order for 1 time or 100 times. Discount will be given up to 100 quantity.After exceeding 100 quantity if order created for the same material then system should not propose discount. I tried in vk11 when maintain condition record for the Discount condition and maintained scales. Discount will be created when created order for 100 quantity. but when created order for 1 quantity system was not giving. Can we do this in Standard or any other way is there.

Thanks in Advance

Rakesh Rahul

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Mar 11, 2014 at 06:47 PM

    Hi Rahul,

    Per ur query it's understood that u wana give discount based on customer and material on scale basis.

    I didn't get ur last point that is created order for 1.??

    Please get back with more details So that you can get help.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 11, 2014 at 07:18 PM


    Here's what I understood: you have a requirement where you give a discount of 20% for up to 100 units of an item. Once the customer buys a 100 units (regardless of the number of orders he places to get to the 100 units) the system should stop issuing a discount. Is this correct?

    You can carry this out with cumulative values. Within a condition record, you have a field for max. condition base value. In this field, you can specify the max number of pieces or cases/ units are allowed before the condition is made inactive. Check out this link.

    Note: condition update has to be active for the condition type in question for this to work.


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 12, 2014 at 06:31 AM

    As per my understanding of your requirement you can achieve this through condition update.

    If you need more details please follow the below link.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Rahul,

      In addition to the settings that I already told you about, please try using the condition exclusion indicator in the discount condition record (go to VK12-scales-go to details of scales-there is an exclusion field KONP-KZNEP).

      Follow the below procedure:

      1) Define condition exclusion, say Z with description as Quantity>100. This setting can be done in IMG-Sales&Distribution-basic functions-pricing-Condition exclusion-Condition exclusion for condition types and records)

      2) Assign the condition exclusion indicator(Z in my example) in the condition record-in the details of scales screen

      3) Create a routine with this condition exclusion and assign the routine in your pricing procedure. (Make the routine customer specific. I.e. if the total quantity of the material, for the particular customer, from all sales orders is greater than 100 then exclude the condition record.).

      The system should now ignore the condition record if the total quantity from all orders, for the customer is greater than 100.

      I haven't tried the solution out. Please do let me know if it works.


      Sumita Mittra

  • author's profile photo Former Member
    Former Member
    Posted on Mar 13, 2014 at 08:36 PM

    I don't think so that your requirement will be fulfilled using only condition record.

    You can do is, Don't make this condition type as Mandatory in pricing procedure, secondly with the help of ABAPer write routine / requirement and assign this new requirement to condition type in pricing.

    In your requirement you should add all quantity sold to the customer and if that is less than or equal to 100 then only populate this condition type else not.

    if you search (maximum quantity in SD pricing), many people had same kind of requirement and that is fulfilled by using routine / requirement only. Check post # 3394720

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.