topic Re: RFC Enabled Function module to read DDIC tables & its values in Application Development and Automation Discussions

RFC Enabled Function module to read DDIC tables & its values

Former Member — Wed, 10 May 2006 10:43:10 GMT

Kindly let me know which RFC enabled function module has been used to extract DDIC tables & its values from the target system.

If not exist suggest me the code to achieve the same.

This is quiet urgent, quick response would be appreciated.

cheers

Alexander

Re: RFC Enabled Function module to read DDIC tables & its values

Former Member — Wed, 10 May 2006 10:45:31 GMT

RFC_READ_TABLE

and

RFC_GET_TABLE_ENTRIES

These rfc function modules would let you read the data in the table you specify in the exporting parameters.

Regards,

Ravi

Re: RFC Enabled Function module to read DDIC tables & its values

naimesh_patel — Wed, 10 May 2006 10:47:59 GMT

Hello,

Use, FM : 'RFC_READ_TABLE' to read the table contents.

DATA: I_OPT LIKE RFC_DB_OPT OCCURS 0 WITH HEADER LINE,

I_FLD LIKE RFC_DB_FLD OCCURS 0 WITH HEADER LINE,

I_DATA LIKE TAB512 OCCURS 0 WITH HEADER LINE.

L_TAB = 'TFDIR'.

CONCATENATE 'FUNCNAME' '=' '''' INTO I_OPT-TEXT SEPARATED BY ' '.

CONCATENATE I_OPT-TEXT 'RFC_READ_TABLE' ''''

INTO I_OPT-TEXT.

APPEND I_OPT.

CLEAR I_OPT.

I_FLD-FIELDNAME = 'FUNCNAME'.

I_FLD-OFFSET = '000000'.

I_FLD-LENGTH = '000030'.

APPEND I_FLD.

CLEAR I_FLD.

CALL FUNCTION 'RFC_READ_TABLE' DESTINATION RFCDEST

EXPORTING

QUERY_TABLE = L_TAB

TABLES

OPTIONS = I_OPT

FIELDS = I_FLD

DATA = I_DATA.

Regards,

Naimesh

Re: RFC Enabled Function module to read DDIC tables & its values

Former Member — Wed, 10 May 2006 10:48:19 GMT

Hi,

Unless you are planning on reading couple of tables, RFC_READ_TABLE is not the ideal choice as you will to call the same one multiple times.

If you are trying to fetch some transactional data, try writing a custom RFC and call that.

Regards,

Ravi

Note : Please mark the helpful answers

Re: RFC Enabled Function module to read DDIC tables & its values

Former Member — Wed, 10 May 2006 11:09:43 GMT

Hi,

you can use RFC RFC_READ_TABLE for both the cases.

for first case give the table name as <b>DD02L</b> to get all the tables, and for getting the table info then use that table name only.

Regards

vijay