06-16-2006 7:45 AM
Hi Experts,
I wanted to ask how to get the data from database table to my smartforms main window.
Actually i defined one internal table. Now in text element of each cell i wrote like &itab-name1&.
Will u tell after this what i can do??
Tell me step by step so that i can proceed further.
06-16-2006 7:50 AM
Hi,
gothrough this links.
Just check these links..
http://www.esnips.com/doc/97acb00a-e513-4611-91f0-c626f460bfc5/Smart_Form_Overview.pdf
rgds,
latheesh
06-16-2006 7:52 AM
hai,
If you use print program fetch the data from database there itself and pass the internal table to form interface.
So that you will get the data you fetched.
The text elements you have created should be inside loop ..endloop.
Cheers,
Umasankar
06-16-2006 7:52 AM
If you are getting data into this internal table via the parameter of the SMART FOrms, you don't have to do anything else, you have write a select in the program lines to get data from the database.
Regards,
Ravi.
06-16-2006 7:56 AM
Hi Salil,
Create the process line for that window in which you have to populate the data.Write the select statement in that process line to select the data from the database table to the internal table then use your command in the data element.
06-16-2006 8:00 AM
Hai Go through the followiung Documents
I have sent you some documents.
http://www.sap-img.com/smartforms/smart-006.htm
http://www.sap-img.com/smartforms/smartforms-faq-part-two.htm
Thansk & regards
Sreeni
06-16-2006 8:04 AM
Hi Salil,
<b>1</b>.
If u r getting data from Smartform itself ,Write that in PRogram Lines.
<b>2</b>.
Instead of writing &itab-name1& ,u have to Drag and Drop that from Field List on/off Button .that is next to Form Painter button.
<b>Thanks,
Venkat.O</b>
06-16-2006 8:32 AM
Hi Salil,
Tell me 1 by one... i'll explain the process.
U hav ethe print program. right? In that program u have the filled internal table. u r passing that internal table to Smartforms. Right.
06-16-2006 8:37 AM
in the main window u will create a table or Loop .
then Goto the DAta Tab....
Then u will see the loop at option
then u'll give the interanal table and the work area
then create the TEXT Nodes(How many fields u want)
in each text node u'll give the <Work area>-<variable name>
it will automatically display all the fields