topic Re: Compare data between a Database table and an internal table in Application Development and Automation Discussions

Compare data between a Database table and an internal table

ejas_nazeerutheen87 — Tue, 14 Jun 2022 19:33:33 GMT

Hi guys,

I want to compare two columns from an internal table (Specification number and Material Number) to the same two columns in a database table (ESTMJ). The specification number and material number assignment in the internal table should be the same as the specification number and material number assignment in the database table. I am pretty new to ABAP. How do i go about this comparison?

Should I pull the data from the db table and then compare it with the internal table? or can i directly compare the two columns of both tables?

Thanks in advance 🙂

Best regards

Ejas.

Re: Compare data between a Database table and an internal table

Alterman — Tue, 14 Jun 2022 20:37:41 GMT

Version 1:

Your internal table is ITAB1.

//declare a 2nd internal table

table I_ESTMJ_2 like ESTMJ.

//load this 2nd internal table

select * from ESTMJ into table i_ESTMJ_2.

//compare

loop at ITAB1.

read table i_ESTMJ_2 where/with {material number assignment, aka, whatever you specifically looking for}

if sy-subrc <> 0.

/*do whatever you wanted if records don't match or don't exist*/

endif.

endloop.

Version 2, delete what's extra:

loop at ITAB1.
delete i_ESTMJ_2 where {I_STMJ_2 material number assignment} ne {ITAB1-material number assignment}.
endloop.

Re: Compare data between a Database table and an internal table

ejas_nazeerutheen87 — Tue, 14 Jun 2022 20:59:48 GMT

Thanks a lot Mikhail. Much appreciated 🙂

Re: Compare data between a Database table and an internal table

former_member808116 — Wed, 15 Jun 2022 08:36:56 GMT

You can: Select Inner join two data table.