Skip to Content
avatar image
Former Member

condition record exclusion based on key combination for vendor rebate settlement

Hello Experts, We have requirement to create multiple condition records for vendor rebate settlement. For example in a contract some or all types of condition records are being created ZVR1 - with a key combination of Purch.Org./Vendor/Site/Article - value in % ZVR2 -Purch.Org./Vendor/Site/Article - value in $ ZVR3 - Purch.Org./Vendor/Site - value in % ZVR4 -Purch.Org./Vendor/Subrange/Site - value in % ZVR5 - Purch.Org./Vendor/Site/Imprint ( custom field) - value in % the requirement is if all the condition records were created for a contract, still PO pricing procedure and rebate pricing procedure should pick only one condition record and not all. In the above case if Porg/Vendor/subrange/site specific condition record is maintained, then all other conditions should be deactivated. Similarly if Porg/vendor/site/imprint does exist then all other condition records should be deactivated. I tried using the standard exclusion technique and I can compare 2 condition and exclude one but I am not sure how to expand beyond 2 conditions. We need to define the hierarchy level and exclusion should work base on hierarch level so in this case ZVR4 is level 5 followed by ZVR5>> ZVR2 and so on. If any one has done this type of exclusion using standard configuration, please share your thoughts with example . I appreciate your help in this regard and thank you in advance. Regards, Venkat

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 28, 2015 at 10:36 AM

    Please check the following function,

    OLME ---> Purchasing ---> Conditions ---> Define Price determination process ---> Define Condition exclusion.

    With help of this function you can exclude the condition records and for details, please refer the following link. Condition Exclusion For Groups Of Conditions - Basic Functions - SAP Library

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Rosh, thanks for your reply. I used this exclusion functionality and able to exclude condition records for 2. But in my there are 5 condition records and each condition record is created with different key combinations. I can't select the condition record based best or least value which is not suitable for our purpose. I am looking for exclusion based on hierarchy. For example here is the scenario. Purchase vendor rebate contract ---1000 with the following conditions created ZVR1- PORG/VENDOR/SITE/ARTICLE - VALUE IN % ZVR3 - Purch.Org./Vendor/Site - value in % ZVR4 -Purch.Org./Vendor/Subrange/Site - VALUE IN % ZVR5 - Purch.Org./Vendor/Site/Imprint ( custom field) - value in % if all the above 4 condition records exists, it should pick up only ZVR4 and exclude other 3. I was able to do for 2 conditions but not for 4 using the regular exclusion process. Further guidance is much appreciated. Thanks again for your help. Regards, Venkat