Top include in Function module

[Former Member]

Hi All,

I have written a select statment in a FM.I want to retain the values selected so that it is available even when the FM is executed next time.Is it possibe to retain values selected by declaring the internal table in the TOP include?

Thanks,

Rakesh.

[Former Member]

Hi,

This is not possible.

You can try out Export to memeory ID and import from memory in subsequent function calls .

Check syntax of IMPORT/ EXPORT

[hymavathi_oruganti]

yah the only solution is either export/inport or sga/gpa parameters.

export/import is best in this case.

[JozsefSzikszai]

hi Rakesh,

if you declare the internal table in the TOP include, that only means it will be avaliable for each FM in the function group. The internal table will be avaliable, not the data (which is filled with the SELECT statement)!

The question is when do you execute the FM next time? It it's only a while, you can export the data into the memory, import by the next FM call and you don't need to select again. but it only works if it is still the same user, same session. can you enlight the scenario?

thanks

ec

[Former Member]

My requirement is to write a FM which gets the old material no(MARA-BISMT) for a given material no.In order to avoid hitting the data base table for each materail enterd in the FM I want to check wheteher an entry for this material no is present in the internal table If an entry is not present then only fetch from MARA.

[JozsefSzikszai]

hi Rakesh,

the problem is here when you return from the FM, all data is forgotten. On the other hand, I am not sure that it is worth to write an Fm for a simple SELECT SINGLE.

What I would do is to create an internal table with MARA-MATNR and MARA-BISMT and fill it in one go with all lines for these two fields from table MARA. Than whenever I need this information in the program I would just READ TABLE

ec

[hymavathi_oruganti]

yah u can do that in the same program. but if u want to retain the details of internal table for another program too, u need to import and export the internal table field values. then only u can do that.

and if u want to retain the internal table values for the next execution, u need to know that the nature of the internal table is for storage of data temporarily and for permanant we need to switch to database table only.

u can do one thing. u can create a table type in dd and use that.