NOT GETTING DATA FROM DB IN SMARTFORMS

[Former Member]

Hi all,

i created zsmart form...

in form interface ,i declared <b>wa_spflig like spfli</b>.

in global definition ,i gave <b>itab like spfli</b>

i created header ,footer n gave output options 4 all header,footer n main window.

i created text for header n footer n gave some text in general attributes tab...

in main, i created table n gave output options n indata tab, i gave <b>wa_spfli into itab</b>.

in table i created loop..in that i gave : <b>wa_spfli into itab</b>

in loop i created 2 texts to retrieve connid n carrid so i gave <b>&itab-carrid&</b> n <b>&itab-connid&</b>

then it showing check is correct n got function module.

in source code

data : itab like spfli occurs 0 with header line.

select * from spfli into table itab.

data fm type RS38L_fnam.

then included <b>ssf_function_module_name</b> n assigned <b>form name</b> n <b>fm_name</b>

in <b>loop at itab</b> statement included fm generated by smartform n assigned <b>wa_spfli = itab</b>

but i am not getting output,its showing <b>&itab-carrid& &itab-connid&</b> as output...what is mistake in my pgm?<b>what is RS38L_fnam , ssf_function_module_name.why it is used?</b>

its urgent.

plz help me.

thanx in advance

Arundathi

[Former Member]

Hi,

RS38L_FNAM is a DATA ELEMENT ( Domain- Funcname ).

It is used in SMARTFORMS to describe name of FUNCTION MODULE which get generated while a SMARTFORM is getting processed.

<b>SSF_FUNCTION_MODULE_NAME</b>

Say i have a program in which I have called the smartform in direct method by using the function module generated.

Now if I change that smartform so much, sometimes a new function module will be generated. or if I delete that smartform and create a new one with same name, a new function module will be generated. Then I need to go and change all programs that call this smartform directly.

In the two step process, it is not necessary. Everytime the function module related to a smart form changes, the SSF_FUNCTION_MODULE_NAME fetches the latest. So we dont need to update our report programs each time we manipulate the smartform

For example when we call a smartform from print program inside the print program we describe

DATA: w_fmname TYPE rs38l_fnam.

• This Function Returns the name of generated Function Module.

CALL FUNCTION 'SSF_FUNCTION_MODULE_NAME'

EXPORTING

formname = <Form Name>

IMPORTING

fm_name = FMNAME

EXCEPTIONS

no_form = 1

no_function_module = 2

OTHERS = 3.

IF sy-subrc NE 0.

EXIT.

ENDIF.

• To call the generated Function Module in the above step.

CALL FUNCTION FMNAME

EXPORTING

< work areas>

TABLES

<Tables>

EXCEPTIONS

formatting_error = 1

internal_error = 2

send_error = 3

user_canceled = 4.

Regards,

Padmam.

[Former Member]

Hi,

check out this link it might help you to resolve your query

http://www.erpgenie.com/abap/smartforms_detail.htm

*********please reward points if the information is helpful to you*****************

[Former Member]

HI,

where u gave the &itab-carrid& n &itab-connid& ?

Regards,

Padmam.

[Former Member]

hi padmam,

in main-> in table->in loop->in header->in txt ->general attritubute tab in txt.

i gave it as text element n seleted new paragraph radio button.in the same window , below i gave &itab-carrid&