Getting Data from a View
Hi Friends ,
I am making a new report where i need to get the material no(matnr) from a view zmatnr_view . When i select the required plant(werks) on the selection screen it should display all the material no's and the respective plants with some additional calculation . Please suggest on this issue .
Vijayendra Rao replied
Why have you created a custom view? I believe the same can be achieved by a simple join on MARA and MARC or infact by writing simple select statements and to carry on your calculation based on the records fetched.
-> Select data from MARC based on ur plant from selection screen
-> Sort based on plant
-> If you need any additional info from MARA ( either use a join or based on the unique material no's selected in the above select statement get the required information)
-> Loop through the internal table to work out ur calculation.
Hope this helps