Parameter ET_DATA as list of results

[former_member793811]

How do i retrieve the content of the ET_DATA parameter into Excel using RFC_READ_TABLE

prior code used func = fns.add("RFC_READ_TABLE")

end retrieved the rows data from func.Tables("DATA").Columns("WA").Value(n)

This is now Blank.
I can see the function is returning data as the TRC file contains >>Exporting ... ET_DATA and shows rows = 1 when having just one hit on the query.

difference is that new FM only Exports "ET_DATA" when query is successful. Therefore cannot obtain object prior to the call of the FM.

Func.Imports("ET_DATA") is accessible but only contains "Item" class with no "Value"

I believe i must Read the RFC_TABLE data, but i don't know the method i have to use to get the "LINE" data that is evident in the SE37 results.

[rlhays]

Did you ever get an answer to this question? Looks like NetWeaver 7.4 is the only release with ET_DATA. Neither 7.3 nor 7.5 have the parameter.

[former_member793811]

7.53 netweaver uses the parameter.
you only see the parm when you have data returned.

**** Trace file opened at 2022-03-11 08:29:26.910113 UTC-06:00 (Central Standard Time), Encoding UTF-8

NW RFC Library: Kernel variant, Release 750 Patch Level 5, Compiled on Oct 16 2019 02:13:53

CPIC library: 753.2019.02.22 version 3, NI library: 40, Kernel Release: 753 Patch Level 513

2022-03-11 08:29:41.527721 [18012] >> RfcGetFunctionDesc

RfcGetFunctionDesc(RFC_READ_TABLE) via handle 211810184

Repository::queryFunctionMetaData(RFC_READ_TABLE) via handle 211810184 returns function meta 076625B0

name=RFC_READ_TABLE (origin=P47) with 10 parameters

parameter 0 (ET_DATA, RFCTYPE_TABLE, RFC_EXPORT, 8, 8, 0, 07649C60, , , 00000000)

parameter 1 (DELIMITER, RFCTYPE_CHAR, RFC_IMPORT, 1, 2, 0, 00000000, SPACE, Sign for indicating field limits in DATA, 00000000)

parameter 2 (GET_SORTED, RFCTYPE_CHAR, RFC_IMPORT, 1, 2, 0, 00000000, , , 00000000)

parameter 3 (NO_DATA, RFCTYPE_CHAR, RFC_IMPORT, 1, 2, 0, 00000000, SPACE, If <> SPACE, only FIELDS is filled, 00000000)

parameter 4 (QUERY_TABLE, RFCTYPE_CHAR, RFC_IMPORT, 30, 60, 0, 00000000, , Table read, 00000000)

parameter 5 (ROWCOUNT, RFCTYPE_INT, RFC_IMPORT, 4, 4, 0, 00000000, 0, , 00000000)

parameter 6 (ROWSKIPS, RFCTYPE_INT, RFC_IMPORT, 4, 4, 0, 00000000, 0, , 00000000)

parameter 7 (DATA, RFCTYPE_TABLE, RFC_TABLES, 512, 1024, 0, 0764A2E8, , Data read (out), 00000000)

parameter 8 (FIELDS, RFCTYPE_TABLE, RFC_TABLES, 103, 206, 0, 0764A380, , Names (in) and structure (out) of fields read, 00000000)

parameter 9 (OPTIONS, RFCTYPE_TABLE, RFC_TABLES, 72, 144, 0, 0764AE30, , Selection entries, "WHERE clauses" (in), 00000000)

RfcGetFunctionDesc(RFC_READ_TABLE) via handle 211810184