New SAP S4HANA SE16H - Forget about SE16N, SE11, SQVI
Hello SAP Consultants
Today we have one of the great innovation that SAP made since 2012 and fully available on SAP S4HANA
Transaction SE16H provides an advance development as part of the SAP HANA development.
You can use this transaction to access data from the SAP HANA database directly from the ERP system and to display this data in the ERP system.
We used to use the transactions code SE11/SE16/SE16N/SQVI to check table’s value and extract data.
Solution in brief
In addition to the functions of transaction SE16N, transaction SE16H also provides the following options:
* New field "Database Connection":
· In the "Database Connection" field, you can display and select the available database connections using the input help.
· The accesses are then executed using the relevant database connection selected.
· If a database connection was selected, the input help for the "Table" field displays the tables and views that are available in SAP HANA.
· The number of rows in your current system/client may therefore be lower than the number displayed.
· Note that transaction SE16H is able to check only the physical connection to the database. The table created in SAP HANA must correspond exactly to the definition in the SAP ERP Dictionary.
* New column "Group":
· In this column, you can enter any group or set that corresponds to the relevant field (selection using F4 help is possible).
· This is particularly useful if groups are used, for example, account groups, order groups, and so on.
· 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 and execute.
* New column "Total":
· If you select this field, all rows found that correspond to the grouping rule (see the new column "Group") are accumulated. As a result, you can generate aggregated views for a large amount of data that, for example, displays a value for each account for each period.
* New column "Sort":
· If you select this column, the system sorts the number of hits using this field.
· You can also do this using a default layout in the SAP List Viewer. However, the data is subsequently sorted, whereas the "Sort" column sorts the data directly from the database.
* New column "Highest/Lowest":
· After executing this, the system returns the largest postings in the object together with their frequency based on the number of hits you requested
* New column "Sequence":
· If you use the functions mentioned above (sorting with highest/lowest), the sequence in which the fields are sorted is relevant. If you enter something in this column (values from 01 to 99), the fields are sorted in the sequence from 1 to 99. If you do not enter anything in this column, the fields are sorted according to their occurrence in the table.
· If you mix fields that have explicit values from 01 to 99 with fields that do not have a value in this column, the fields without values are added according to their occurrence after the fields with a value.
* New column "Aggregate":
· In this column, you can choose between the aggregations "Maximum", "Minimum" and "Average". Depending on the data type, not all aggregation functions are available. You can either aggregate or group/total a field.
* New field "Outer Join Definition":
· This function corresponds to a basic view definition for tables that contain only additional information about the selected table (for example, to read texts).
· You cannot map any inner joins - that is, you cannot define restrictions that must be met for more than one table. The outer join definition is used only to read additional attributes from a user-selected database connection for the selected table. This means that, for example, postings can be read from a SAP HANA database and the texts for the resulting quantity can subsequently be read from the normal ERP database.
1- This is the New Selection Scree for SE16H rather than the old SE16N interface
2- Now we will prepare an Outer Join Query using SE16H instead of SQVI or SQ01-02-03
First Select The Primary Table for example LFB1
Second Select "Outer Join Definition"
3- Select Secondary Table for example LFA1 then Press Save
4- Choose Output yellow arrow to select required columns for display in the report
5- If you want to restrict the output based on a specific value on a specific field as a predefined filter you can use the second part of the screen
6- Then Press Save
7- Select Which fields you want from the Primary table as well then press Execute
Finally After executing SE16H with the outer joint you have created you will find exactly the data required from the two tables in one ALV grid with a button click in seconds
Hope you try it in you systems, Good Luck :)