Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 .

Thanks ,

Tags:
replied

Hi Hari,

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

CHeers

VJ

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question