Skip to Content
0
Former Member
Dec 04, 2008 at 05:15 AM

IF ..AND.. ELSE..condition in BEx reporting

25 Views

Hi All,

I want to see my materials rating % :in BEx

I want to apply these IF condition in BEx level not in modeling/cube extraction/rules level.

Requirement:

If MATID = MAT5 and MAT Type u2018FINISHu2019 then VALUE= 66%

If MATID = MAT8 and MAT Type u2018SEMI FINISHu2019 then VALUE= 45%

If MATID = MAT9 and MAT Type u2018NORMALu2019 then VALUE= 36%

Please let me know the procedure: I know we can write using Customer exit abap code.

Is there any alternative method i.e CALCULATED KFG/RESTRICTED KFG/FORMULA......?

Please let me know the procedure and give some sample code using IF.

or else provide abap code using customer exit.

Thanks & Regards,

SRI