SAP SE16

As you know, SAP's newest release S/4HANA comes with many enhancements and features compared to the previous SAP ERP release ECC 6. One of these great new features is the new transaction SE16H - SAP table display. This SAP transaction code can be used as a data browser and includes features that enable rapid table checks and small queries for a list of tables and table fields.

SAP Consultants and SAP customers alike used to use the general table display transaction SE16, SE16N or transaction code SQVI to list fields or check a table’s values or extract data. These transactions were very popular and used often because they provide a quick way to review important table contents and extract date easily. SE16 was the first transaction used to display and download the values from an SAP table - it was quick & easy to do. Then came transaction SE16N that allowed us to view table structures which wasn't possible before. And SQVI could be used to create complex queries over multiple tables and put the results into an easy-to-read table. However, as good as these two old transactions were, the new SE16H is even better.

The transaction code SE16H offers additional functionality and enables the SAP user:

  • Tables check (consult and extract) like a classical SE16 or transaction code SE16N
  • Table join / join conditions creation for small query
  • Rapid check of the number of entries 

 

Here are two cases where these new features are explained in more detail.

 

SE16H - Complete accounting document query

Imagine a scenario where you want to check data source entries for a complete accounting document. We would have to combine many finance tables to get a complete pictures of the document, but for this example, we will only use two tables:

  • BKPF: Header data of accounting segment

  • BSEG: Accounting document segment

 

Now login to SAP and start SE16H with table BSEG and create a join:

SE16H with BSEG

Enter the criteria for your join.

As described below, to have a better finance document information, we will add the table BKPF as a join with table BSEG. Then, we 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 a filter on the fiscal year, company code, and posting month. For these filters, we have put a constant value. But SE16H also offers other methods as displayed below.

SE16H with constant value

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

Execute SE16H with join

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

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

To learn more about using SAP's query capabilities, check out these SAP training courses: SAP Query Reporting or SAP Query Made Simple.

Header for table BKPF

 

 

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 select the field group as indicated below and execute it.

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 the number of document types used in the system for a single company code.

Quick view of number of document types used

If you want to learn more about exporting data from SAP, take a look at this video that shows how to extract data from an SAP logical database or table using GUI Scripting instead of SE16N:

 

I hope you found this blog useful - if so, please share it with your coworkers or social network.

PS: To learn more about reporting in S/4HANA please read this blog: Reporting in SAP S/4HANA.

 


Author Photo

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.