Step | Description |
1. | Go to transaction SQVI and enter a name for your query and press the <CREATE> button. |
2. | In the popup, enter the following information: Then click the <ENTER> button |
3. | Using the Data Fields browser on the left-hand side of the screen you can now choose which fields you want on the selection screen, and which fields you want to see in the report. You can see the data for each table by clicking on the “expand” icon: As you add the list/selection fields they will then appear in the corresponding tabs on the lower right-hand side of the screen. You can also choose you fields from these tabs as well as sort and delete. |
4. | In this example I have chosen fields from the header (DIPLKO) and operation (DIPLPO) only. Save the query once you are happy with the data. |
5. | You can now test the query using the <EXECUTE> button. Because this is a LDB, you will notice that the top part of the selection screen is pre-assigned and you cannot change this. The Program Selections area of the screen are the additional options you have chosen in the steps above. You can now enter your selection screen values as required, and possibly save them as a variant to make testing easier. Once you are happy, press the selection screen values, press the <EXECUTE> button to run the report. Be patient, this LDB can be quite slow… |
6. | Check the results: Note: you can utilise the usually ALV functions (sort, total, group, filter, etc) to arrange the data as required and save as your preferred default variant. |
Step | Description |
1. | Multiple SQVIs: The PNI logical database can be very slow, especially if you go down to the 3rd level (materials or packages or PRTs, etc). If your query is too slow, then think about splitting your query into separate queries , e.g.
|
2.. | Colouring columns: Go into your query in change mode, and select the <LAYOUT MODE> button in the application toolbar. You will now be presented with a different view of the data. You can change column colours by clicking on a field in the top right-hand section of the screen, and then selecting the required colour in the List Field section of the screen: Apply the colour setting once finished. The graphic should then display your chosen colours: |
3. | Variants & Layouts: You can create selection screen variants and ALV layouts for your query as per any other list-edit style report. |
4. | View Options: The default is to view the data in an ALV format via the SAP List Viewer option. However you can change the default output to the following options: |
5. | Running SQVI via SE38 or SA38: SQVI queries are intended for personal use, so no one else can see or use your queries via transaction SQVI. However, you can get the ABAP program name using the following menu path: SQVI->QuickView->Additional Functions->Generate Report Name Then anyone can use this program name in either SE38 or SA38. You can also link this program to a “Z” transaction if you have developer access. |
6. | Converting SQVI into SAP Query: Do the following in SQ01: 1. Set the query area to the standard area using menu path: EnvironmentàQuery Areas 2. Set the required user group via (OTHER USER GROUP> button 3. Choose menu path: QueryàConvert QuickView 4. Enter the QuickView name/user of the query in the popup and click <ENTER>, then enter the new Query and InfoSet name and click the <ENTER> button 5. The SQ01 query should now be created and you can perform the usual SQ01/SQ02 functions |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
5 | |
4 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 |