Use SE16H instead of SE16, SE16N or SQVI
Posted on 11/2/2017 by Abdellah Khebbari. 0 Comments.

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:

SE16H with BSEG

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.

Add table BKPF as a join

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 put a constant value. But SE16H offers also other methods as displayed below.

SE16H with constant value

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

Execute SE16H with join

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.

Header for table BKPF

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.

Quick view of the number of accounting entries by company code

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

Quick view of number of document types used

Like this article? Please share:
 Add a Comment

Your name (required)

Email (will not be published) (required)
 
Author Photo
Abdellah Khebbari
Over the last 8 years, I have been involved in all phases of SAP Finance implementation projects. My contributions in luxury and industry leading companies allow me to build a strong SAP technical and business skills. Moreover, participating to a SAP HANA implementation helps me to acquire new skills in the HANA LIVE reporting and cloud solutions. Explored the features expanded of the existing native integration with SAP HANA with ArcGIS mapping and geospatial intelligence technology of Esri.