Creation of ZMB52 with out Currency field using Quick Viewer
Task: Creating the Display warehouse stock of Material (MB52) with out
currency values field (Not at display in layout also).
Process:
- SAP Menu–>Tools–>ABAP workbench–>Utilities–>Quick Viewer(SQVI)
2. Enter the Name starting with “Z”(for our identification purpose) and click on creation button.
3. A POPUP screen will appear than select the “Table Join”( As shown below screen shot) option in data source field and enter.
4.Goto Menu bar Edit–>Insert table
5. Enter the initial table name “MARA” and again click on insert table and enter the name “MAKT”,”MARD”,”MCHB”,”T001L”.
6. Now you can see the join relation between the two tables (As shown below screen shot).
7. Please remove the non required join between the tables(then only we can get the results).
8. Please click on back in menu
9. Please click on for selecting the layout (As shown below screen shot).
10. Please select the initial required fields (input fields in initial screen) in selection fields tab(As shown below screen shot).
11. Please select the required fields for report ( output fields ) in List field selection tab(As shown below screen shot).
12. Goto menu bar Quick viewer –>check /
13. Goto menu bar Quick viewer–>Execute /
14. You will see the selection fields as shown in below screen shot.
15. Enter the Material number and/or plant and/or material type / without entering anything .
17. Now we can see the required report with required fields as shown below screen shot.
18. 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:
19. Enter the T.code SE93.
20. Enter the creating T.code name with “Z”(for our identification purpose) and click on creation button.
21. Enter the short text and select the radio button for program and selection screen (report transaction)as shown above screen shot.
22. Enter the Program field.
23. 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).
24. Copy the program name and past in Program filed in T.code creation field.
25. Save the transaction .
THANK YOU