How to Extract the Data by using Quick Viewer Query (SQVI)
The Quick Viewer allows you to define reports without having to program
yourself. The Quick Viewer is especially useful for new users and occasional
use. Quick Viewer is a tool for generating reports. SAP Query offers the user a
whole range of options for defining reports.
Quick Viewer is a tool for generating reports. SAP Query offers the user a
whole range of options for defining reports. SAP Query also supports different
kinds of reports such as basic lists, statistics, and ranked lists. Quick Viewer, on
the other hand, is a tool that allows even relatively inexperienced users to
create basic lists.
Reports created using the Quick Viewer may also be passed to external
programs like Excel.
Step by Step Process of Generating Report by using Quick Viewer Query
(SQVI)
Just Go to SAP Screen & Enter the T-Code: - SQVI in Command filed.
Press enter.
Below screen of Quick Viewer opens.
LinkedIn | Mayur Sonar
Email :-
[email protected] Mo. No: - 7744918923
As per the Business Requirement we can Generate or Extract the data
from Multiple Table by using Quick Viewer Query.
Now in this Query Business Require a Report of all the Purchase Order
with its Material Document No. (GR No)
Below is the list of Important Table in Purchasing.
Tables: -
1) EBAN: - Purchase Requisition
2) EKKO: - Purchasing Document Header
3) EKPO: - Purchasing Document Item
4) EKBE: - Purchase Order History Table
5) MKPF: - Material Document Header Data
6) MSEG: - Material Document Item Data
7) RBKP: - Invoice Receipt Header Table
8) RSEG: - Invoice Receipt Item Table
After Executing T-Code: - SQVI
Just Enter the Name of Query as above shown & Click on Create.
Below Screen Opens.
LinkedIn | Mayur Sonar
Email :-
[email protected] Mo. No: - 7744918923
Enter the Title of Report
Select the Data Source as Table Join & then click on Tick Mark. Below
Screen Opens.
Click on Insert Table. As above shown.
Insert the Table Name here from which you need to Extract the data.
EKKO, EKPO, EKBE, MKPF, MSEG, RBKP & RSEG
Here I am using this table to extract the data which are related to
Purchasing.
LinkedIn | Mayur Sonar
Email :-
[email protected] Mo. No: - 7744918923
EKPO: - Purchasing Document Item
MSEG: - Material Document Item Data
Enter the Table Name & Press Enter.
Follow this process for Inserting all the Table as per requirement.
LinkedIn | Mayur Sonar
Email :-
[email protected] Mo. No: - 7744918923
As above shown we are Inserted EKPO & MSEG Table which are required
for our Report.
As above shown We can add multiple Tables as per Requirement.
Also we can Link the table Each other as per Requirement.
For just Showing Purpose I am adding all the Table here. You can add as
per your Requirement.
LinkedIn | Mayur Sonar
Email :-
[email protected] Mo. No: - 7744918923
After joining the table click on Check & Take back.
Below Screen Opens.
All the Table are added here with its technical Name as above shown.
Just Expand the Table & Add the Selection field as per requirement from
each & every table select the required fields which you need to include
in table.
LinkedIn | Mayur Sonar
Email :- [email protected]
Mo. No: - 7744918923
Tick on Selection Field the data which you need to require to generate
the Report as per requirement.
From Each Table list you can select the required data as above.
Select the data from table.
After Selecting All the Require Data. Click on SAVE.
System will give a Precautionary Message. Press Enter.
LinkedIn | Mayur Sonar
Email :-
[email protected] Mo. No: - 7744918923
Query Z_PO_GR created
Then Click on Execute. Below Screen Opens.
Enter the Company Code & Plant here. Execute.
After Executing this System will show you the all the PO with Material
Document No (GR No.) as shown above.
LinkedIn | Mayur Sonar
Email :- [email protected]
Mo. No: - 7744918923
If we want to Export the Data in Excel.
Just Right Click on it. Select the Spreadsheet.
Below Screen Opens. Click Enter.
LinkedIn | Mayur Sonar
Email :-
[email protected] Mo. No: - 7744918923
Enter the File Name & File Type as per requirement. As shown above &
Click on Save.
Click on Allow.
LinkedIn | Mayur Sonar
Email :-
[email protected] Mo. No: - 7744918923
This is how we can export the Data in Excel & use it for further
reference.
This is how we can Extract the Data by using Quick Viewer (SQVI)
LinkedIn | Mayur Sonar
Email :-
[email protected] Mo. No: - 7744918923
