Skip to Content

Task: Creating the Display warehouse stock of Material (MB52) with out
currency values field (Not at display in layout also). 

Process:

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

               

/wp-content/uploads/2013/03/1_197268.png

    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.

      /wp-content/uploads/2013/03/2_197269.png

     4.Goto Menu bar Edit–>Insert table /wp-content/uploads/2013/03/4_197315.png

    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).

/wp-content/uploads/2013/03/3_197316.png

     

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

     8. Please click on back in menu /wp-content/uploads/2013/03/5_197317.png

     9. Please click on /wp-content/uploads/2013/03/6_197318.pngfor selecting the layout (As shown below screen shot).

/wp-content/uploads/2013/03/7_197319.png

                

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

/wp-content/uploads/2013/03/8_197320.png    

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

/wp-content/uploads/2013/03/9_197324.png

        12. Goto menu bar Quick viewer –>check / /wp-content/uploads/2013/03/10_197325.png

       13. Goto menu bar Quick viewer–>Execute / /wp-content/uploads/2013/03/11_197326.png

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

        /wp-content/uploads/2013/03/12_197327.png

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

            16. Click on Execute//wp-content/uploads/2013/03/13_197328.png

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

            /wp-content/uploads/2013/03/14_197329.png

      18. We can change the report layout by using “Layout mode”/wp-content/uploads/2013/03/15_197333.png push button before saving the Quick viewer.

Creating T.code based on Quick viewer program:

       19. Enter the T.code SE93.

               /wp-content/uploads/2013/03/16_197334.png

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

/wp-content/uploads/2013/03/17_197335.png

         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).

            /wp-content/uploads/2013/03/18_197339.png

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

                /wp-content/uploads/2013/03/19_197340.png

         25. Save the transaction .

              /wp-content/uploads/2013/03/20_197341.png

                                         THANK YOU

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply