Try SE16H

[mickaelquesnot]

https://youtu.be/7IINGgdF8Z0

 

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

1.1.1 Complete query

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

• PRCD_ELEMENTS (Pricing Elements)
o VBAP (Sales Document: Item Data)

Launch SE16H with VBAP to join it to PRCD_ELEMENTS and create a join

 

Enter the criteria for your join
As described below, to have a complete sales document informations, we will add the table PRCD_ELEMENTS as a join. Then, we will click on the yellow arrow to add the fields we want to add to the output.

 

SE16H: Field Is Displayed (Grouped or Totaled)

 

VBAP

& PRCD_ELEMENTS as SQVI

Please note that, as it is shown in this figure, you can apply filters on the fields you need. SE16H offers also other methods as displayed below.

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

The fields displayed contain data from the table VBAP and data from PRCD_ELEMENTS.
1.1.2 Rapid check of entries number

Group feature
In case we want to have a quick view of the number of sales document.
We have to tick the field group as indicated below and execute.

SE16H: Group By for Select

 

Group and sort feature
In case we want to have a quick view of number of sales document.