condition record exclusion based on key combination for vendor rebate settlement

[venkat_narasimhan2]

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

[former_member233510]

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

[venkat_narasimhan2]

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