Create SQVI query in SAP

 Create SQVI query in SAP

Step 1.  Goto T-Code - SQVI.  Provide Name for the query ( EX. ZMAT ) . 

              Click on data source and select table join.

                

Step 2.  Next screen is your navigation window. Here you can set relationship between tables.

Step 3.  Press SHIFT + F1 or  select insert table option and provide name of the tables

              you want to join.

Step 4. After set relationship click on back button and  below screen will appear.

            Here you can set field to be displayed when query execute.

Step 5. In next tab you can set sorting order for the query to be displayed.

Step 6.  In selection field tab select the fields whom you want to display on selection screen.

              Data will be fetch on that  field.

Step 7.  ALL SET. NOW EXECUTE AND PROVIDE VALUE FOR SELECTION SCREEN.

ASSIGN T-CODE TO SAP QUERY