Need to select 1 discount from 3 discount condition type - SAP SD

Hi All,

I have 3 discount condition type -

Condition type - A

Condition type - B

Condition type - C

Requirement -

• If condition record exists for condition type A then ignore B and C .
• If condition record doesn't exist for condition type A then check for B and C . If record exists for B ; ignore C
• If condition record doesn't exist for condition type A and B , then select C

I tried with condition exclusion but it doesn't fulfill the above requirement . Business doesn't want best or worst condition to be selected but only in the above sequence .

Please advise .

Regards,

Pabitra