SE16H is an Upgraded version of SE16N. A very Hana specific transaction provided by SAP for browsing data by joining two or more tables.
If you are a functional or a technical consultant you must have used SE16, SE16N for data analysis. Se16 and SE16N limits us to a single table. Whereas, SE16H is a power tool having the functionality to join two or more tables and provides additional functionality like aggregate, grouping and more.
Let's dive in-
In this post we will use VBRK, VBRP and PRCD_ELEMENTS for test purpose. These are the most used Tables in SD module.
Goto Tcode SE16H and give VBRK as table name.
For joining multiple tables and see the output we have to use Outer Join Definition.
1. Select the "Main. of relationship" logo to create "Outer Join Definition".
2. A maintenance window will open. Use VBRK as primary Table. In Secondary Table Definitions use VBRP and PRCD_ELEMENTS. You can check the Inner Join field or it will be treated as outer Join condition. Select the Output button for selecting output that you want for display.
3. From the Filed maintenance window select the fields you want to show.
4. You can use aggregate functions as well for specific fields. Maximum, minimum and average are provided as default functionality. Apply these entries and go back. And again select fields for prcd_elements.
VBRK-
PRCD_ELEMENTS-
5. Select the VBRK table line and press the maintain detail button having the magnifier logo( marked red in the image).
Maintain the access definition of secondary table. This is our join condition between VBRK and VBRP.
6. Do the same for PRCD_ELEMENTS.
Save it, and press f8 or apply entries button from below. (marked red).
7. select the newly created outer join definition from the outer join definition dropdown. Select the fields you want to view. I have selected only a few.
8. Now Execute.
Here is how the output looks like. This way you can use multiple tables to analysis your data without using excel.
No comments:
Post a Comment