‎2006 Mar 01 11:54 AM
Hi all again..
My query is ..
Which method is better for printing data in Samartforms..
a) perform data selection at smartform level
b) select whole data in driver program and then pass to smartforms..
please consider the scenario where we have select data from 3-4 tables.
‎2006 Mar 01 12:03 PM
i would prefer doing the selection separately in the driver program and pass it to smartform level ..and then u can loop that internal table in the smartform for getting the values..
‎2006 Mar 01 11:59 AM
Hi Madan
In smartforms you can send more than one internal table at a time. you can loop at the internal table in the smart form then you can display the contents in the smartform.
you can do a both the methods.
I would prefer do all the processing in the driver program then pass the internal table to the smartform
regards
kishore
‎2006 Mar 01 12:02 PM
It depends also on your data in your tables.
If the data is huge in your internal tables, then you can perform the operation at the smartform program.
Either way, the driver program processing and passing data to smartforms would be the best one...
‎2006 Mar 01 12:03 PM
i would prefer doing the selection separately in the driver program and pass it to smartform level ..and then u can loop that internal table in the smartform for getting the values..
‎2006 Mar 01 12:03 PM
Hi Madan,
I think you can pass it from the driver Program..
you can populate the data from all the four tables into one itab... and pass it on to the form..
But see to that WHEN YOU CALL A SMARTFORM WITH ONE SUCH ITAB YOU'LL HAVE TO CREATE A SIMILAR STRUCTURE IN SE11..
then you can use the table there in your FORM..
regards
satesh
‎2006 Mar 01 12:09 PM
Hi Madan,
Passing data to smartform is always better but it depends on the scenarios too...
There may be the case where you may fetch data at smart form level which is not very huge , do some manipulation like concat (Basically for display fields) . In that probably u can use it otherwise for transactional huge data --> prefers data selection at smartform level.
Cheers
Sunny
‎2006 Mar 01 12:30 PM
i would go for selecting separately in the driver program and passing them to the smartform so that the internal tables can be looped with no due overload of database access when the samrtforms gets executed.
You can check for the standards by running the abap run time analysis trace(SE30).Run this transaction ,mention the program which drives your smartform and execute .then analyse.It will display the break up of execution time across:ABAP,DATABASE,R/3.None of which should exceed 60%.If you are accessing the database from smartform your r/3 execution time could be high hence leading to deviation from sap set standard.Chek out for yourself to get a better understanding.
Bye.