topic NOT GETTING DATA FROM DB IN SMARTFORMS in Application Development and Automation Discussions

NOT GETTING DATA FROM DB IN SMARTFORMS

Former Member — Thu, 21 Jun 2007 03:47:55 GMT

Hi all,

i created zsmart form...

in form interface ,i declared wa_spflig like spfli.

in global definition ,i gave itab like spfli

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 wa_spfli into itab.

in table i created loop..in that i gave : wa_spfli into itab

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

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 ssf_function_module_name n assigned form name n fm_name

in loop at itab statement included fm generated by smartform n assigned wa_spfli = itab

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

its urgent.

plz help me.

thanx in advance

Arundathi

Re: NOT GETTING DATA FROM DB IN SMARTFORMS

Former Member — Thu, 21 Jun 2007 03:54:13 GMT

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.

SSF_FUNCTION_MODULE_NAME

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

EXCEPTIONS

formatting_error = 1

internal_error = 2

send_error = 3

user_canceled = 4.

Regards,

Padmam.

Re: NOT GETTING DATA FROM DB IN SMARTFORMS

Former Member — Thu, 21 Jun 2007 03:58:08 GMT

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*****************

Re: NOT GETTING DATA FROM DB IN SMARTFORMS

Former Member — Thu, 21 Jun 2007 04:00:14 GMT

HI,

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

Regards,

Padmam.

Re: NOT GETTING DATA FROM DB IN SMARTFORMS

Former Member — Thu, 21 Jun 2007 13:10:23 GMT

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&