Hi MDM gurus,
I'm quite new to the MDM JCo API, and I'm trying to do do a search based on two tables.
E.g. I have two tables
Table A has fields F1(key), F2 (foreign key)
Table B has fields F2(key), F3
Is it possible to do 'One single search' on these tables where F1 = F1value
but getting results: AF1, AF2, B~F3 in a ResultSet?
Currently the only way I know to do this is first Search Table A where F1 = F1value.
Loop through the results and Search Table B.
This is very inefficient coding where in SQL or in ABAP you can do this with one line of code.
Any help would be appreciated! Code would be a bonus!