Skip to Content
Technical Articles
Author's profile photo abdellah khebbari

You used to use SE16/SE16N and SQVI, Try SE16H!

As you know, SAP HANA comes with many enhancements and features. The new transaction SE16H comes with new features which enables rapid tables check and small queries.

SAP Consultants used to use the transactions code SE16/SE16N/SQVI to check table’s value and/or extract data.

The transaction code SE16H enables:

  • Tables check (consult and extract) like a classical SE16 or SE16N
  • Joint creation for small query
  • Rapid check of number of entries

Here are two cases where this new features are explained

1- Complete accounting document query

Imagine a scenario where you want to check entries for complete accounting document. We can combine many finance tables, but for this example, we will only use two tables:

  • BKPF: Header data of accounting segment
  • BSEG: Accounting document segment

Launch SE16H with BSEG and create a join

Enter the criteria for your join

As described below, to have a complete finance document informations, we will add the table BKPF as a join. Then, we will click on the yellow arrow to add the fields we want to add to the output.

Please note that, as it is shown in this figure, you can apply filters on the fields you need. In this example, we have put filter on fiscal year, company code and posting month. For these filters, we have putted a constant value. But SE16H offers also other methods as displayed below.

After executing the SE16H with the joint we have created, your financial data are displayed as below.

Please note that a layout have been used for the displayed result

The fields displayed contain data from the header table BKPF and data from accounting document segment. For example, here are some field’s detail.

2- Rapid check of entries number

Group feature

In case we want to have a quick view of the number of accounting entries by company code, we have to tick the field group as indicated below and execute.

Group and sort feature

In case we want to have a quick view of number of document type used in the system for a single company code

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Thangaraj Thomas
      Thangaraj Thomas

      Hi abdellah khebbari,

      Excellent overview information. Thank you for sharing.

      Thanks

      Thangaraj Thomas

       

       

      Author's profile photo Siva Prasad
      Siva Prasad

      Good information

      Author's profile photo Micheal Mathews
      Micheal Mathews

      Thank you, very well explained

      Author's profile photo Surykumar Tripathi
      Surykumar Tripathi

      Thank you so much for sharing knowledge ☺️

      Author's profile photo GIANLUCA TACCONE
      GIANLUCA TACCONE

      Hi Adbellah.

      Well written, elegant and illustrative, thanks a lot for that.

      Since it it so huge, people are frequently searching for a way to compare fields in S/4HANA ACDOCA and ECC tables (e.g  BSEG ,COEP, FAGLFLEXA ) a very useful note on that argument is this one https://launchpad.support.sap.com/#/notes/2156822

      I know yours was just an example but I wonder whether it would be possible to find the entire example's result in ACDOCA.  😉

      Thanks a lot!

      Best

      Gianluca

       

      Author's profile photo Pranav Kumar
      Pranav Kumar

      Hi Sir,

      Very useful article first time i have heard about SE16H

      Thq So much !!

      Author's profile photo Tejas Shelke
      Tejas Shelke

      Very useful transaction details, sharing on LinkedIn.

      Author's profile photo Yasin N
      Yasin N

      Very good explanation. Thanks for your efforts Abdullah.