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.

To report this post you need to login first.

80 Comments

You must be Logged on to comment or reply to a post.

  1. 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.

    (0) 
    1. Jörg Wulf 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

      (0) 
  2. 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

    (0) 

Leave a Reply