topic Re: Different data types in Application Development and Automation Discussions

Different data types

Former Member — Fri, 16 May 2008 09:11:16 GMT

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.

Re: Different data types

Sm1tje — Fri, 16 May 2008 09:17:10 GMT

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.

Re: Different data types

Former Member — Fri, 16 May 2008 09:30:20 GMT

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.

Re: Different data types

Former Member — Mon, 19 May 2008 07:19:20 GMT

Thanks for your answer.

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

Re: Different data types

Former Member — Mon, 19 May 2008 07:59:29 GMT

Thanks for your reply

Please can explian clearly