Skip to Content
Former Member
Jun 10, 2008 at 05:20 AM

Can we have a if condition during data selection in Query Report (SQ02)


Hi all,

I have a required where in need to create a query report , where in which there are two types of condition exists.

first i input either functional location into View V_EQUI , when there is a equipment BOM exists(or when there is any entry for Equipment feild exists ) then the selected euipment should be passed to EQST else if equipment doesnot exist then the Functional location should be passed to TPST.

Now that I created a query report with base table as V_EQUI and joined it with EQST and whenever the equipment feild has a entry , it passes the equipment to EQST and works fine.

Now for some Functional location there is no equipment feild that exists for these base table is V_EQUI now when there is no entry for equipment , the functional location should be passed to TPST.

Now I would I achieve that.

Can I put a if condition to check on if equipment is initial then select X Y Z from tpst where fl = v_equi-fl.