Do you already use the new SE16H Transaction?

see note (it turns out it works in NW 7.01 (sp13), and it also works for Classic Databases)

advantage here: we can also define JOINS!


just select group or total and you will get the distinct/total values instead of the detail lines

create join definition:


click on Arrow-Button under ‘Output’ to select output fields of join



in realtime

Remember Transaction /NTAANA?

Transaction TAANA is a very useful transaction to analyze number of documents per year or per Document Type etc for Data Archiving Projects, Carve-Out analysis etc.

TAANA is able to compute the statistics in Batch so even in tables with millions of rows, we are able to analyse the results in a comfortable way.

i played around with this on hana, and of course i don’t need batch analytics, the results come in dialog in seconds.

see also note for some limitations:


select ‘create ad hoc variant button’


choose statistic fields like organisation values (salesorg, co area) or order type etc


non-hana: choose in the background for large tables

hana: online!


analysis results: number of documents etc

hana studio:

get a quick impression by using data preview/distinct values:


or use analysis for more details (select x/y axis):


in my version of web ide there was no preview feature, i think this is coming in Hana SPS9:


To report this post you need to login first.


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

  1. Nikolay Evstigneev

    Hi, Jörg!

    Many thanks for SE16H! Such a cool thing! I’ve already sent a brief tutorial to our consultants, now they have a unique opportunity of not making joins in Excel 🙂

  2. Jörg Wulf

    Hi Jörg,

    great to know! I have stumbled across se16h before, but wasn’t aware that we can use it on classic database as well.

    Thanks a lot for pointing out.

    Best regards – Jörg


Leave a Reply