Do you know your SE16N?
Posted by Jörg Wulf in ABAP Development on Aug 8, 2014 12:40:16 PM
Probably, this does not exactly belong here, but i found no better place for it.
Several people i know(me included) like to use TA SE16N for a quick glance at table data or as a means of preselection e.g. for personnel data.
Something like a query but without the hassle of building one.
It’s really great, as long as you only need data from a single table AND all selection criteria are AND related. (Or so I thought)
One problem, I frequently ran into, is when you want to evaluate a „nested“ table. That is a table that has multiple fields in its structure, basically for the same data, representing a limited table in maintenance view.
For example infotype tables in HR are often built like that and the problem is always, that you do not know, in which field (nnnn01, nnnn02, …) to look for a certain value.
Now quite I recently figured out, that SE16N can do that and I found it worth sharing.
Let’s assume, you need to know all employee, that have a certain date type (say 18) in infotype 41, in a specific time interval, but you have no idea, in which date type column (DAR01, DAR02,…) it is to be found.
In the past, I would have run several selections, each one with a different DARxx targeted to my date type and then would have assembled the results in Excel.
This is how to do it now
Call TA Se16N with table PA0041
Fill in the first set of selection criteria (DAR01 / DAT01)
Change to Technical View On (SHIFT+F11 or right-click for context menu)
Select Multiple entry (Cntrl+F9 or right-click for context menu or More button in the top)
Youwill be rewarded with an additional, empty selection screen
Fill in your selection criteria and then press Next Entry (F5 Or Right Arrow in the bottom)
You get a new empty selection screen. Note the number shown in the top line, it will increase as you circle through your value sets.
Repeat
When you’re through with typing in your values in every possible column, press F8 to get back to your starting selection.
The only hint, that there are additional select criteria, is the more button in the top, now showing the filled Icon.
The difference is in the result. After executing your selection, you will now receive all entries, that match either of your value sets. They are each linked by OR-relation.
Of course, the use of this feature is in no way limited to HR Infotype tables. It’s just the most common use for me.
Wherever you need OR-related sets of values for a SE16N Selection , this feature comes in handy.
Hope you’ll enjoy it.
