tables in smartforms

[Former Member]

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.

[Former Member]

Hi,

gothrough this links.

Just check these links..

http://www.esnips.com/doc/13b7ae7a-b32c-4b96-b588-881859d4ac99/Template,Table,Loop,Command-in-Smartf...

http://www.esnips.com/doc/97acb00a-e513-4611-91f0-c626f460bfc5/Smart_Form_Overview.pdf

rgds,

latheesh

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[venkat_o]

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>

[Former Member]

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.

[Former Member]

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