topic FM exporting table in Application Development and Automation Discussions

FM exporting table

Former Member — Mon, 18 Sep 2006 15:14:20 GMT

Hi, I want to export a table from a FM.

What is the best method? Define the table under the EXPORT screen or TABLES screen?

What should the code in the FM be, if my internal table is named it_tableTOexport?

Thanks!

Re: FM exporting table

Former Member — Mon, 18 Sep 2006 15:15:50 GMT

Hi Rune,

Always it's better to define tables in tables only.

-Anu

Re: FM exporting table

Former Member — Mon, 18 Sep 2006 15:16:06 GMT

Hi,

If it is table then you need to export it in tables.

Hope this helps.

Re: FM exporting table

Former Member — Mon, 18 Sep 2006 15:17:01 GMT

Hi,

If you have a table type created in the DDIC you can use the EXPORTING parameter.

If you have structure only then you can use the TABLES parameter..

THanks,

Naren

Re: FM exporting table

Former Member — Mon, 18 Sep 2006 15:20:02 GMT

When you say EXPORT, hope you mean download to pc.

The best is to pass the table as a TABLE parameter and the code can be to use the FM Gui_download.

Call Function 'Gui_download'

exporting

filename = p_file

filetype = 'ASC'

tables

data_table = it_tabletoexport.

Re: FM exporting table

Former Member — Mon, 18 Sep 2006 15:21:19 GMT

Hello,

Under TABLES only. Use the option IMPORT, CHANGING and EXPORT only for variables or strucrures.

Regs,

Venkat Ramanan N

Re: FM exporting table

uwe_schieferstein — Mon, 18 Sep 2006 15:22:09 GMT

Hello Rune

The only way to differentiate between semantically different TABLES parameters is by using naming convention. I use the following conventions:

(1) Importing TABLES parameter (i.e. this is only input for the function module, the itab entries are not changed) = IT_<itab name>

(2) Exporting TABLES parameters (i.e. this is only output of the function module) = ET_<itab name> [In addition, one of the first line of coding in the function module is: REFRESH: et_<itab name>]

(3) Changing TABLES parameters (i.e. this is input and output at the same time) = XT_<itab name> [usually there will be no REFRESH statement using this TABLES parameter]

Note that the differentiation between importing, exporting and changing is purely semantic because technically all TABLES parameters are the same.

Regards

Uwe

Re: FM exporting table

Former Member — Tue, 19 Sep 2006 06:53:43 GMT

Thanks for all replies.

This is in my FM:

EXPORTING

*" VALUE(T_RESULT_EXPORT) LIKE ZT_RESULT STRUCTURE

*" ZTKG_RESULT

I have the parameter name T_RESULT_EXPORT in the Export section. How can I fill the table with data? I get an compiler error saying "T_RESULT_EXPORT is not an internal table - the OCCURS n specification is missing".

All I want to do is filling my export table.

Re: FM exporting table

Former Member — Tue, 19 Sep 2006 11:22:55 GMT

The exporting parameter cannot be filled like an internal table unless it points to a table type. Which is to say, the structure ZT_RESULT STRUCTURE should be a table type.

In your case, the error occurs because ZT_RESULT STRUCTURE is a structure and hence, T_RESULT_EXPORT is also a structure and not an itab.

2 solutions:

1. Create T_RESULT_EXPORT under tables instead of exporting

2. Creat ZT_RESULT STRUCTURE as a table type instead of structure.

Hope this helps.

Sudha