Create a QuickViewer Query

No.	Steps
1	Create a Query on the tables KNA1 and KNVV
1.1	Goto Quick Viewer (SQVI)
1.2	Enter in a Quickview name and click on the create button. Enter in a description and choose Table Join as the data source. Hit the Check. (You can follow the directions in the information box in the lower left hand portion of the screen)
1.3	Using the Insert table button add the tables KNA1 and KNVV to the screen
1.4	Verify the join between the tables is an Inner Join on the KUNNR field by right clicking on the line between the boxes and choosing `Display Join Conditions'. When complete, Green arrow back
1.5	From the Upper Left hand box, select the fields to be displayed. General Table choose: Customer Number, Name 1, City, Sort Field Customer Master Sales table: Sales Org, Distribution Channel, Division These fields will now be visible in the upper right hand box and can be sorted if needed.
1.6	Choose the `Selection fields' tab in the main screen.
1.7	You can choose the selection screen fields by either using the `Possible Fields' selection box on the main screen or the upper left hand screen where you choose the fields to be displayed Name 1 Sort Field
1.8	Save the Quickview and execute the query. Enter `46DELTA' on the selection screen for the sort field and execute.

SAP R/3 ABAP 4.6 Delta Training Questions

ABAP Graph/Query Tools

PricewaterhouseCoopers LLP 1 August 2000

Global Training Centre

---