Creating Material Master field status report by using Quick Viewer and Creating Tcode

HI All,

      This Document may helpful to creating own functional reports with out ABAP’s help by using Quick Viewer.

SAP Menu–>Tools–>ABAP workbench–>Utilities–>Quick Viewer(SQVI)

1. Enter the Name starting with
   “Z”(for our identification purpose) and click on creation button.
2. A POPUP screen will appear than
   select the “Table Join”( As shown below screen shot) option in data source
   field and enter. 

3 .Goto Menu bar Edit–>Insert table

4. Enter the initial table name “MARA”  and again click on insert table and enter the name “MARC”.

5. Now you can see the join relation between the two tables (As shown below screen shot).

6. Please remove the non required join between the tables(then only we can get the results).

7.  Please click on back in menu

8.  Please click on Basic mode button for selecting the layout (As shown below
screen shot).

9. Please select the initial required fields (input fields in initial screen) in selection fields tab(As shown below screen shot).

10. Please select the required fields for report ( output fields ) in List field selection tab(As shown below screen shot).

11. Goto menu bar Quick viewer–>check

12. Goto menu bar Quick viewer –>Execute 

13. You will see the selection fields as shown in below screen shot.

14. Enter the Material number and/or plant and/or material type / without entering anything .

15. Click on Execute.

16. Now we can see the required report with required fields as shown below screen shot.

17. We can change the report layout by using “Layout mode” push button before saving the Quick viewer.

Creating T.code based on Quick viewer
program:

1. Enter the T.code SE93.

2. Enter the creating T.code name with “Z”(for our identification purpose) and click on creation button.

3. Enter the short text and select the radio button for program and selection screen (report transaction)as shown above screen shot.

4. Enter the Program field.

5. We can take the Program name from Quick viewer screen main menu bar

Quick viewer–> Additional  functions–>Display report name (as shown a screen shot).

6.Copy the program name and past in Program filed in T.code creation field.

7. Save the transaction .

.