Application Development Blog Posts
Learn and share on deeper, cross technology development topics such as integration and connectivity, automation, cloud extensibility, developing at scale, and security.
cancel
Showing results for 
Search instead for 
Did you mean: 
salamancacm
Explorer
2,603

As impossible as it may seem, we sometimes forget the way in which a query should be constructed in openSQL. Have you ever wondered if there is an easy way to build queries to use in your programs? 


Well, the answer is YES, in this post I will show you how to get simple queries (nothing too complex) for your programs.


After reading this post you easily will build your SELECT statements and you could also modify it for UPDATE or INSERT statements.


Let's get into that.


Step 1: Go to transaction SE16N



Transaction SE16N


 

Step 2: Choose your table


Choosing table


 

For this example let's use SFLIGHT

 

Step 3: Choose your fields for filtering (in this case I'm using the field date)


Choosing Fields


 

Press F8

 

Step 4: Visualize your data


Visualize data


Step 5: Visualize your script

Now just click the Display selection Criteria button or SHIFT + F1


Click the button


 

And visualize your script


Visualize script


Now just copy the script and use it where you need it.

 

With this few steps yo can now get simple queries for your programs in no time.

IMPORTANT: the key is to know the fields of the table that you want to use in your program (for correct filtering).



I hope this information can be useful for your projects as it has been for me.


Share this post with whoever needs it


See you next time.


6 Comments
Labels in this area