Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to Query data from the table

manoj_goyal2
Participant

‎05-09-2008 7:20 PM

0 Kudos

As a ABAP developer I need to verify a report data with the data in a table. I am dealing with table having field A and FieldB. I need to find out all records from the table where field A is NOT EQUAL to field B. What tool I can use to do this with little effort.

Thanks,

mini

4 REPLIES 4

Former Member

‎05-09-2008 7:25 PM

0 Kudos

Try using SQ01.

Former Member

‎05-09-2008 7:26 PM

0 Kudos

itabC is final internal table.

Loop at itabB.

read table itabA where itabA <> itabB.

move corresponding itabA to itabC.

endloop.

Regards,

Dara.

manoj_goyal2
Participant

‎05-09-2008 7:31 PM

0 Kudos

I wish to verify data in report with the data in the database table, and not in internal table. Sorry for confusion. Also this table is in development box.

Former Member
In response to manoj_goyal2

‎05-09-2008 8:09 PM

0 Kudos

what is the difference between them as u collect the data from database table to internal table