smartforms

[Former Member]

how to reading the data from the database in smartforms?

can we create text emelemts in smartforms? how to use that in smartforms?

Regards,

pandu.

[former_member196280 · Accepted solution]

If you want to fetch data from table, try to right click on the page you want to display the new fields and select program lines.. here you can write all your code, (similarly what you write in SE38 editor)

Regards,

SaiRam

[Former Member · Accepted solution]

thank u sai..

i right clicked on main window but i dint get that option?

what is wrong?

regards,

pandu.

[Former Member · Accepted solution]

hi,

u can do like this

main window->right click->create->text

[former_member196280 · Accepted solution]

Try to modify the form in change mode, RIGHT click on the name given to first page, you will see program lines.... there you can build your logic for retriving.

Regards,

SaiRam

[Former Member]

Hi ,

In global declarations in tab types or global data declare the structure or internal table required to hold the data .

Fetch the data as follows :

Then you can write a query in the initialization tab to fetch the data from the database into the structure or internal table .

Or

Right click on main window or text box -> create->flow logic->program lines

In the input parameter and output parameter write the name of the structure or internal table that should contain the data .

then write the query in the editor below .

now the structure or internal table or the structure will contain the fetched data.

That u can use .

Regards

[Former Member]

Hi Pandu,

Yes u can create texxt elements in sf's

by declaring the internal tables in a global definitions and you can write select statements

Reward points for all helpful answers

Reagds,

Kiran.M

Message was edited by:

KIRAN KUMAR

[Former Member]

Hi,

in the smartforms you have to option to write

the program lines

in that you can write the abap coding

for that you have to declare the internal table in the global declarations

or form interface -- tables tab.

and

for text elements

create a window

and right clik on it

and create --> text

and here you can display the data what ever you want

reward points if helpful,

thanks & regards,

venkatesh.