Sunday, April 16, 2017

Forget SE16/SE16N, Try New - SE16H!

Thanks to SAP and the team to enhancing the product and providing the newbies.

The new transaction SE16H comes with new features which enables rapid tables check and small queries.

Generally, SAP Functional Consultants require transactions code like SE16 / SE16N / SQVI to check table’s value and to extract data.

SAP is now available with new transaction code SE16H which 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- Query for entries for Accounting document 


This scenario is when we want to check entries for complete accounting document. We can query many finance tables but for this example we are using only 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 information, 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.

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

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

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


2- Checking of number of entries - Group feature



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


Group and sort feature
Here, we want to have a quick view of number of document type used in the system for a single company code as shown below:


For more information on SE16H, please refer SAP Note : 1636416.

1 comment: