topic Re: inserting fields in Application Development and Automation Discussions

inserting fields

Former Member — Wed, 11 Jul 2007 11:08:02 GMT

Hi all,

i have two internal tables.

one table have Mandt key extra comparing to other internal table.

and both have remaining all the fields same.

Now i want to insert all the fields from the internal table which dont have mandt key to another internal table which have mandt key.

i dont want to use loop.

how can i insert the fields.???

Regards,

CSR.

Re: inserting fields

Former Member — Wed, 11 Jul 2007 12:53:51 GMT

Hi CSR,

You can use following syntax,

1) ITAB1[] = ITAB2[].

or 2) move ITAB2[] to ITAB1[].

Please reward if helpful.

Regards.

Srikanta Gope.

Re: inserting fields

Former Member — Wed, 11 Jul 2007 12:56:09 GMT

see the below code which is inserting data from work area to internal table .


DATA: BEGIN OF connection, 
        cityfrom TYPE spfli-cityfrom, 
        cityto   TYPE spfli-cityto, 
        distid   TYPE spfli-distid, 
        distance TYPE spfli-distance, 
      END OF connection. 
 
DATA connection_tab LIKE SORTED TABLE OF connection 
                    WITH UNIQUE KEY cityfrom cityto 
                                    distid distance. 
 
SELECT cityfrom cityto distid distance 
       FROM spfli 
       INTO connection. 
  INSERT connection INTO TABLE connection_tab. 
ENDSELECT.

reward points if it is usefull....

Girish

Re: inserting fields

che_eky — Wed, 11 Jul 2007 13:00:19 GMT

I don;t think you can do this without a LOOP statement as both tables have different structures.