SQVI Report - join two or more tables in SAP Security

Here I am explaining about SQVI to create report.

By using SQVI will get one report by joining multiple tables.

For example if you want to extract the data of users with roles details you can do it by AGR_AGRS and AGR_USERS.  To get this report we can combine both tables in SQVI in a single shot.

T-code: SQVI

Steps:

•  Go to SQVI and Enter name in Quick View field. And then click on create.

 

•  Enter Title like description and then select data source filed as Table join.

           Here  options will be available in Data source filed like Table, Table Join , Logical database,     SAP Query info set

• Next you can select basis mode or layout Mode and click on continue. For best result select Layout mode and click on continue.

•  new window pop up as per below. here select insert button

 

•  Enter Table name in filed and click continue button.

•  Again click on insert filed and enter tables as you wish to join the tables. 

We can add multiple tables , once completed the adding of tables then select back button . 

• Now extract the tables which are in left side as per below. 
  

Select the check box filed which ever you want in output.

selection fields means in selection screen what fields required , these fields  are display in input selection screen

list fields means out put format.

• Click on execute. Will get new window.
• Select SAP list viewer and click on execute.

 

 

 extract the report using    option.

the same way we can join more than two tables to get reports ....