Inserting data into append structure

[Former Member]

Hiee friends ,

I inserted a append strucuture into spfli table. I inserted carrname which is of scarr-carrname type .

Now my requirement is to insert corresponding values in carrname in spfli table from the scarr table .

For that i got the corresponding values of spfli-carrname in my internal table . I tried to insert it with insert command but its showing some error ..i.e column type not equal

Friends any ideas how to insert the carrname values into the spfli append strucutre.

Edited by: lokesh pattnayak on Jan 23, 2009 1:59 PM

[matt]

Why not help us and help yourself, by showing us the actual ABAP you tried, (wrapped in tags), and the specific error you are getting.

[Former Member]

Here is my code that i am using to insert values into carrname field.

NB- YSPFLI and YSCARR are copies of tables of spfli and scarr with the respective datas resp.

REPORT  zappend_structure.
TABLES : yspfli, yscarr.

DATA: BEGIN OF wa,
         carrid TYPE yspfli-carrid,
         carrname TYPE yscarr-carrname,
      END OF wa.

DATA itab LIKE STANDARD TABLE OF wa.


SELECT  c~carrname
       INTO CORRESPONDING FIELDS OF TABLE itab
       FROM  yspfli AS p
         INNER JOIN yscarr AS c ON c~carrid   = p~carrid.


LOOP AT itab INTO wa.
  WRITE:/ wa-carrname.
  INSERT into yspfli values wa.
ENDLOOP.

ERROR : --- When i am checking the syntax it shows that "The work area wa is not alligned correctly" .

Edited by: lokesh pattnayak on Jan 23, 2009 3:58 PM

[Former Member]

I tried with the update table but still the same error is coming .

i.e "The workarea "WA" is not aligned correctly".

REPORT  zappend_structure.
TABLES : yspfli, yscarr.

DATA: BEGIN OF wa,
         carrid TYPE yspfli-carrid,
         carrname TYPE yscarr-carrname,
      END OF wa.

DATA itab LIKE STANDARD TABLE OF wa.


SELECT  c~carrname
       INTO CORRESPONDING FIELDS OF TABLE itab
       FROM  yspfli AS p
         INNER JOIN yscarr AS c ON c~carrid   = p~carrid.


LOOP AT itab INTO wa.
  WRITE:/ wa-carrname.
  update yspfli from  wa.
*  INSERT into yspfli values wa.
ENDLOOP.

Friends any ideas how to insert the values into the carrname field from the workarea .

thanking you lokesh.

Edited by: lokesh pattnayak on Jan 24, 2009 3:49 AM

[Former Member]

REPORT zappend_structure.

TABLES : yspfli, yscarr.

DATA: BEGIN OF wa,

include structure yspfli, workarea should be like that of database table (it should contain all fields) *

data: END OF wa.

DATA itab LIKE STANDARD TABLE OF wa.

SELECT c~carrname

INTO CORRESPONDING FIELDS OF TABLE itab

FROM yspfli AS p

INNER JOIN yscarr AS c ON c_{carrid = p}carrid.

LOOP AT itab INTO wa.

WRITE:/ wa-carrname.

update yspfli from wa.

• INSERT into yspfli values wa.

ENDLOOP.

[Former Member]

Hi,

REPORT zappend_structure.

TABLES : yspfli, yscarr.

DATA : itab LIKE STANDARD TABLE OF yspfli.

DATA : wa_itab like line of yspfli.

SELECT c~carrname

INTO CORRESPONDING FIELDS OF TABLE itab

FROM yspfli AS p

INNER JOIN yscarr AS c ON c_{carrid = p}carrid.

insert yspfli from table itab.

[Former Member]

Hi,

For SQL statements, the work area or rows of the internal table must be at least as long as the database structure and the alignment must match.

So, declare another for inserting in database.

DATA : WA2 TYPE SPFLI.

LOOP AT itab INTO wa2.

   INSERT into spfli VALUES wa2.

ENDLOOP.