Skip to Content
0
Former Member
Oct 29, 2013 at 11:04 AM

Case Statement in Bex formula or if else with characteristic restriction

155 Views

Hi Experts,

Can I use a 'case' statement or if else with characteristic restriction in BEx?

for. e.g



(backlog qty = 0) and Max Shipment Date <= Promise Date.
Hence this line is Ontime to Promise i.e. Flag = 1 If Material Type not equal to 'ABCD' I need to consider the Max shipment Date

if Materil type = 'ABCD' I need to consider the Max Invoice Date.

(backlog qty = 0) and Max Invoice Date <= Promise Date.

Hence this line is Ontime to Promise i.e. Flag = 1

Thanks

Srini.