- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- How to add condition in where clause of select que...
Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How to add condition in where clause of select query?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2023 Aug 18 2:49 PM
297
- SAP Managed Tags:
- SAP Select,
- ABAP Development
How to add condition in where clause of select query? like
Select *
from table
where field1 = cond #( when flag = x then '111'
else '123')
into it_table.
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2023 Aug 18 3:40 PM
210
- SAP Managed Tags:
- SAP Select,
- ABAP Development
You probably mean ABAP SQL CASE?
https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abensql_case.htm
-- Tomas --
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2023 Aug 18 4:17 PM
210
- SAP Managed Tags:
- SAP Select,
- ABAP Development
Unclear question. What is FLAG? What is X? Variable? Column?
The answers depend on that.
