topic Re: Smartform query in Application Development and Automation Discussions

Smartform query

Former Member — Thu, 28 Jan 2010 05:08:37 GMT

Where should i make changes in the smartform while taking two table instead of 1 table. I can able to see the result while taking 1 table , but i don't know how to do it in 2 tables . Please help me experts .

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:10:25 GMT

Can you please explain? Your question is not very clear.

Thansk,

Archana

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:11:59 GMT

hi ,

check out in GLOBAL SETTINGS options Form Interface & Global definitions

Regards

Gaurav

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:17:59 GMT

Hi,

In the driver Program u declare the two tables and in SmartForms in Global setting ~~>Form Interface~~>Tables --u have to declare.

After that loop it and read and display.

Regards

Arbind

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:19:51 GMT

My question is like should i declare 2 tables in the smartform or , i have to take final table at smart form.

Thanks And Regards

Arun Kumar Sethi

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:23:22 GMT

Hi,

It depends on u how u want to display fields.

If two tables not nedded I mean if all data u have merge in 1 final internal table in driver program, then no need of two tables .

Regards

Arbind

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:27:04 GMT

hi,

you can declare 2 tables in global definitions in smart form ..............or pass final table trough smartform driver program ........

regards

Gaurav

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:27:28 GMT

Can i declare Final table like

" IT_FINAL TYPE FINAL " OR " IT_FINAL LIKE FINAL ".

And Loop as follows,

" IT_FINAL INTO WA_FINAL " .

Thanks And Regards

Arun Kumar Sethi

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:31:20 GMT

hi,

you can declare internal table & workarea in SF.............but first you have to create same structure in SE11

" IT_FINAL LIKE FINAL ".

And Loop as follows,

" IT_FINAL INTO WA_FINAL " .

Thanks And Regards

gaurav

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:33:45 GMT

If i declare 2 tables at the Global definition then how to loop it at the main area .

Thanks And Regards

Arun kumar Sethi.

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:40:38 GMT

hi,

in smartform main area you can create 2 tables ....on each table condition option put some condition as your requirement for display a single table .

regards

Gaurav

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:44:01 GMT

Hi,

In the Main Area Right Click u will find LOOP stement Select that.

There u make ur 1st Inernal table loop and u can again select loop or use table and pass ur 2nd Internal Table.

Thats it.

Regards

Arbind

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:48:53 GMT

Thanks Gaurav Igot my problem solved.

Re: Smartform query

Former Member — Thu, 28 Jan 2010 05:52:20 GMT

Thanks all for the helpful replays..

Thanks And Regards

Arun Kumar Sethi.