topic Re: Function module for DB records in Application Development and Automation Discussions

Function module for DB records

Former Member — Fri, 11 Feb 2011 21:30:42 GMT

Hi Folks,

I have a small question. I am trying to get a function module and use it to get all the entries in db table into

an internal table. I got a function module called 'RFC_GET_TABLE_ENTRIES'.

I put my db table into internal table through this module . But when I am trying to download using function module

gui_download, I am saving it into a text file in a given path in my work station.

But when I download it, I see in my text file with only 2 columns of values and rest all are showing "*###&^^" values.

I was thinking if anyone of you could help me know any good function module which could help me.

Is it the problem of my function module or internal table?

I have declared my internal table as "val(400) type c". Is this what is creating problem?

Please get me some solution to this one. I will really appreciate it.

Thank you folks,

Ravi

Former Member — Fri, 11 Feb 2011 21:40:53 GMT


> I have declared my internal table as "val(400) type c". Is this what is creating problem?

Partly - you have to parse this table and move individual fields to another work area that has the same structure as the table.

Rob

Former Member — Tue, 15 Feb 2011 16:10:08 GMT

Use FM "FC_READ_TABLE" and then GUI_DOWNLOAD. This works without any issues.

CALL FUNCTION 'RFC_READ_TABLE'

DESTINATION gv_aposys " RFC Destination APO

EXPORTING

query_table = c_apo_rba03 " '/SAPAPO/RBA03'

delimiter = '|'

TABLES

OPTIONS = lt_options

fields = lt_fields

data = lt_data

EXCEPTIONS

table_not_available = 1

table_without_data = 2

option_not_valid = 3

field_not_valid = 4

not_authorized = 5

data_buffer_exceeded = 6

OTHERS = 7.