Skip to Content
Author's profile photo Jörg Wulf

Do you know your SE16N?

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

  1. Call TA Se16N with table PA0041
  2. Fill in the first set of selection criteria (DAR01 / DAT01)
  3. Change to Technical View On (SHIFT+F11 or right-click for context menu)Technical View ON.png
  4. Select Multiple entry (Cntrl+F9 or right-click for context menu or More button in the top)
    Multiple Entry.png
    Youwill be rewarded with an additional, empty selection screen
  5. Fill in your selection criteria and then press Next Entry (F5 Or Right Arrow in the bottom)More First.png
    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.More Second.png
  6. Repeat
  7. 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.

SE16n Final.png

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.

Assigned tags

      80 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo SAP SAP
      SAP SAP

      Very helpful ... thanks

      Author's profile photo Rosario Selvakumar
      Rosario Selvakumar

      cool 🙂

      Author's profile photo Omar Ali
      Omar Ali

      Thanks Jorg,

      Would you or anyone happen to know if I can add a dynamic date (D) in the variant in SE16N?

      For example, in the FEBEP table, I'd like to have the posting date (BUDAT) always be current date. Thanks.

      Author's profile photo Jörg Wulf
      Jörg Wulf
      Blog Post Author

      Hi Omar,

      sorry to disappoint you but AFAIK variants of se16n are held rather simple. Only direct values, patterns or intervals.

      BR - Jörg

      Author's profile photo Rémi Corriveau
      Rémi Corriveau

      Nice to know.

      Thanks Jörg.

      Author's profile photo Joachim Rees
      Joachim Rees

      Wow, I didn't know that!

      Not sure if I had come across a situation where this would have been useful to me, but if I ever do, I'll remember you blog!

      I think SE16n has quite some secret (or better: non-obvious) features.
      One of them I remember having used is that you can do a "Number of Entries" as a background job:

      (That's useful if you run into a timeout when doing it in online).

      best
      Joachim

      Author's profile photo Former Member
      Former Member

      That’s useful if you run into a timeout when doing it in online

      You could, on the other hand, use the ADT SQL Console 🙂

      Author's profile photo Joachim Rees
      Joachim Rees

      Thanks for the Keyword, I found that blog about the ADT SQL Console and thus lerand something new!

      Can you give a example, though, on how this helps to do a complicated (= long running) count?

      Author's profile photo Former Member
      Former Member

      Hi,

      but when you save the query as a "variant" the or-selection-tupel is gone. maybe it´s a bug. Has anybody an idea?