cancel
Showing results for 
Search instead for 
Did you mean: 

query on infoset

Former Member
0 Kudos

Hi all,

I'd like to know if we can make use of SAP query to compare 2 tables fields values instead of writing an ABAP,

e.g. select matnr from tableA where tableA.matnr <> tableB.matnr.

could we add such where condition somewhere in the coding part in the infoset?

Please advise. Thanks!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi ,

You can do this in the infoset .

In SQ02 , t-code where we create infoset , in the first screen there is a tab for mentioning data source .

Over there select first option i.e. 'Table Join using basis table' and enter table name for example Table 'A'.

Then you will get one Join defination screen where in you need to insert another table (shift+F1) and enter table name 'B'.

System will automatically join Table A matnr with Table B matnr using inner join and your purpose will get solved without need for any coding.

Please let me know if it suffices your requirement.