SELECT <WITH CONDITIONS> INTO iTable
Can we do query's in SAP with conditions? Like we can do in SQL Server or MySQL or whatever. Something like:
SELECT field1, (if field2='1' THEN 'YES' ELSE 'NO') as field2 FROM TABLE WHERE <conditions2>.
I know that SAP is not a database and these things are Database related but as i just began in SAP, i wanted to know if this is possible or not.