Different data types

[Former Member]

Hi

I want retrive data 2 tables using forall entries. and tables are EQUI and AUSP.

EQUI table primary key is EQUNR

here EQUNR is equal to AUSP table OBJEK

My problem is here EQUNR and OBJEK have different data types.

Please tell me how to retrive data using for all entries.

[Sm1tje]

The internal table for retrieving the data should be extended with an additional column. This column you have to define the same as EQUNR. Now move all entries from AUSP to this new column and use that as comparison in FOR ALL ENTRIES.

[Former Member]

Hi

Thanks for your answer.

I am not clear about this one. can you please give an example.

[Former Member]

hi,

do this way ... take a new field in internal table OBJEK_N of type OBJEK in the internal table holding EQUI table details ...

loop at it_equi.
  itab-objek_n = it_equi-equnr.
  modify it_equi index sy-tabix transporting objek_n.
endloop.
if not it_equi[] is initial.
   select * from ausp into it_ausp 
    for all entries in it_equi
    where objek = it_equi-objek_n and 
             <conditions>
 endif.           

[Former Member]

Hi

Thanks for your reply

Please can explian clearly