Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Function module for DB records

Former Member
0 Likes
456

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
405

>

> 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

2 REPLIES 2
Read only

Former Member
0 Likes
406

>

> 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

Read only

Former Member
0 Likes
405

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

  • Read data from APO table /SAPAPO/RBA03

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.