Join 2 SAP tables from VB code

[eyalisr]

Hi , I am able to read the content of SAP tables from VB using RFD_READ_TABLE command.
The problem is that I have 2 tables that I want to Join (like in SQL).
does anybody have any idea how ?

any help would be appriciated.

 

[SkipVought]

RFC_READ_TABLE

I don't believe you can do this in R/3 from Visual Basic without having soeone write a custom query in an R/3 Function Module.

What you really are looking for is an r/3 abap query.

RFC_READ_TABLE will only read single tables.

Another way, if your tables are not huge, is to query the tables separately and join them external to SAP. Build a DB on the fly, create two tables, populate with each tables data, join and get the resultset.

Skip,
[sub]
Just traded in my old subtlety...
for a brand NUANCE![/sub]

 

[eyalisr]

Thanks,
I don't have any abap skils and there for I will try building a DB on the fly and join the fields there ...

thank you !