I'm working with Web Dynpro. I need to generate some reports in Web Dynpro based on the data in the table of SAP Data Base (Ztable). So How can i retrieve the data from the SAP Data Base.
Never code SQL statements directly whithin WebDynpro for ABAP. This is a bad and ugly mixture of UI and business logic - strictly forbidden (but technically possible) by the MVC design paradigm. Instead create ABAP Objects classes and methods and/or Function Modules you can call from within your WebDynpro for ABAP application. TRhere are Code Wizards to semi-automatically create the required coding.
Simply have a look at some tutorials in SAP documentation for WebDynpro for ABAP. In SDN you can also find (even better) tutorials. A good starting point is here:
You cannot retrieve data using web dynpro. You can only display them using wd4a. Retrieval is just as you would do in normal dynpros or any ABAP code. Create APIs to access your tables and use them. Create a table UI element and bind the data to the element so that you can see it in a view.
Use your function modules or select queries to fetch the data inside the WDDOINIT orWDDOMODIFY of your view.And this data , you can bind it to the context of your view .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.