Custom Tables in System Browsing

[Former Member]

Hi everybody,

how can I get my R/3 custom tables in the tree of my system? I've tried to search for my z tables with no result. I can't find the package containing my tables as well.

I think I have to activate something but I'm not a SAP R/3 expert.

Thanks

Massimiliano

[Former Member · Accepted solution]

You can only see RFCs, when you system is connected as R/3-system.

If you use SAP Query Connector, you can see Queries on tables.

Mario

[Former Member · Accepted solution]

Mario,

thanks for your answer.

I'm trying to create a BI_SAPQ system but it doesn't work.

Must I activate something on SAP server?

Which fields must I fill?

Thanks again

Massimiliano

[Rodrigo-Giner · Accepted solution]

like mario said the VC only accept RFCs and BAPIs, for me the easiest way of doing that is with RFC. I hope that this steps help u.

1- In the r/3 system create a function (se37) and a group functions if u dont have one.

2- in attributes set access remote (RFC)

3- if u wanna past a Z table (custom) put it in tables tab.

4- in the code part make your SELECT sentence and in the INTO part put the table that u defined in step 3.

(4-b) if u wanna filter the data with user input put import parameters and add them to WHERE in the SELECT sentence. Then Test your function in r/3.

5- Be sure that the connector in portal works fine, connect to portal (in the icon traffic light must be green).

6- When u go to DATA (in VC) select the alias connector to the R/3 system that u created in portal.

7- Search for the function name that u created, it should appear and working.

To your other question, I haven't worked with BI and BW only with r/3 backend system creating RFC functions.