SAP Database
SAP Database (SAPDB.INFO) – Just one Place for SAP SQVI Tutorial There might come a time that you want the information and it is spread in multiple tables. You can write a SQVI and get this info. In this tutorial we will write an SQVI to find out role assigned to users with full name of the users. You can get role assigned to users from AGR_USER table and users full name from USER_ADDR. We will join both these table to get the result. 1. Execute transaction SQVI 2. Create a SQVI (z_user_role) and 3. Put a title and comments. Make sure that you select Table join from Data source 4. Click to insert tables. Insert AGR_USERS and USER_ADDR tables. 5. Select the correct join. Here we will join BNAME Hit the back button 6. Here I will select Role name and user name from AGR_USERS table and Full name
[Read the rest of this entry...]
