topic Re: tables in smartforms in Application Development and Automation Discussions

tables in smartforms

Former Member — Fri, 16 Jun 2006 06:45:36 GMT

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.

Re: tables in smartforms

Former Member — Fri, 16 Jun 2006 06:50:39 GMT

Hi,

gothrough this links.

Just check these links..

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

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

rgds,

latheesh

Re: tables in smartforms

Former Member — Fri, 16 Jun 2006 06:52:04 GMT

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

Re: tables in smartforms

Former Member — Fri, 16 Jun 2006 06:52:05 GMT

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.

Re: tables in smartforms

Former Member — Fri, 16 Jun 2006 06:56:03 GMT

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.

Re: tables in smartforms

Former Member — Fri, 16 Jun 2006 07:00:19 GMT

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

Re: tables in smartforms

venkat_o — Fri, 16 Jun 2006 07:04:57 GMT

Hi Salil,

1.

If u r getting data from Smartform itself ,Write that in PRogram Lines.

2.

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.

Thanks,

Venkat.O

Re: tables in smartforms

Former Member — Fri, 16 Jun 2006 07:32:46 GMT

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.

Re: tables in smartforms

Former Member — Fri, 16 Jun 2006 07:37:11 GMT

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