Using corresponding statement

[Former Member]

Hi All,

I am working on a report... in that particular report there are many places where the code has been written as follows:

SELECT  *
         APPENDING CORRESPONDING FIELDS OF TABLE t_zztest
         FROM   zztest
    where lgort = s_lgort.
sort t_zztest by lgort.

DATA BEGIN OF T_ZZtest OCCURS 0.
       INCLUDE STRUCTURE ZZtest.

SO I was just wondering if rather than using the appendind statment...

can I write like this..

SELECT  *
         APPENDING TABLE t_zztest
         FROM   zztest
    where lgort = s_lgort.
sort t_zztest by lgort.
binary search.      " can I add this

Thanks,

Rajeev

[former_member156446]

if table t_zztest and DB table zztest are of same structure you can do that..

another altenative... append lines of itab1 to itab2... itab1 and 2 need to be of same structure... least performance cost.

[Former Member]

yes,move corresponding is used when there is type mismatch in the structure of db table and internal talble...or you just want to move some fields of db table to some field of internal table...

if this is not cse and both have ame structure..avoid move corresponding

[Former Member]

Rather than asking the forum (you haven't given enough information), you should just try it.

Rob

[faisalatsap]

Hi,

I think it will be more efficient if you use like following,

Data: it_zztest  LIKE STANDARD TABLE OF zztest with header line.

SELECT  *  INTO CORRESPONDING FIELDS OF TABLE it_zztest
         FROM   zztest
    where lgort = s_lgort.

Kind Regards,

Faisal