topic Re: Reading table from r/3 using rfc ? in Application Development and Automation Discussions

Reading table from r/3 using rfc ?

former_member5350 — Fri, 20 Apr 2007 08:53:59 GMT

Hi all,

how can i read tables from another r/3-system within an abap report ? what are the steps necessary ? can you provide me with some sample code/instructions, please ?

Thank you!

Re: Reading table from r/3 using rfc ?

Former Member — Fri, 20 Apr 2007 08:56:24 GMT

YOu can use the RFC fm RFC_READ Table.

For advanced requirements, you can have a look at this blog.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f50dcd4e-0501-0010-3596-b686a7b51492

sample usage:

fld-fieldname = 'OBJ_NAME'.

APPEND fld.

CONCATENATE 'Object = ' '''FORM''' INTO str.

opt-text = str.

APPEND opt.

CALL FUNCTION 'RFC_READ_TABLE'

destination TDEST "Create a destination in sm59 for the other system

EXPORTING

query_table = 'TADIR'

TABLES

OPTIONS = opt

fields = fld

data = dat

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.

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Message was edited by:

Ravi Kanth Talagana

Re: Reading table from r/3 using rfc ?

former_member5350 — Fri, 20 Apr 2007 08:57:59 GMT

thank you, but i am on 4.6c! how about that ?

Re: Reading table from r/3 using rfc ?

Former Member — Fri, 20 Apr 2007 09:00:04 GMT

Is that FM not available in 4.6c??

Re: Reading table from r/3 using rfc ?

Laxmana_Appana_ — Fri, 20 Apr 2007 09:10:46 GMT

Hi,

Create an RFC enabled function module in destination system and call it from source system with RFC destination.

Like :


  CALL FUNCTION 'READ_DEST_TABLE'
    destination DEST 
TABLES
  X_TABLE LIKE SPFLI.

Function code like:

   select * from spfli
         into table x_spfli.

Regards

L Appana