Thanks to SAP and the team to
enhancing the product and providing the newbies.
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
- BKPF: Header data of accounting segment
- BSEG: Accounting document segment
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.
