Inserting data from workarea to custom table

[Former Member]

how to insert certain fields from work area to custom table.

[Former Member]

Hi,

Do like this,.

Itab-f1 = wa-f1

itab-f2 = wa-f2

...........

...........

append itab.

clear itab.

insert into Ztab from Itab.

Regards,

Anji

Message was edited by:

Anji Reddy Vangala

[Former Member]

hi,

you fill those fields of the work area and append that field string to table.

in any case if like to fill the remaining fields u again by using update statement ,u modify that row

if u want an example reply me i send an example.

Message was edited by:

sunil kumar

Message was edited by:

sunil kumar

[Former Member]

hi

there r multiple ways 2 insert data into custom table into work area few being

APPEND, INSERT and evenn using select queries u can populate the custom table .

DATA:

BEGIN OF FS_AIRLINE,

CARRID(5) TYPE C, " Carrier id

FLICONNID(4) TYPE N, " Connection id

FLITDATE LIKE SY-DATUM, " Flight date

END OF FS_AIRLINE.

"----

---

• Internal table to hold Flight details *

"----

---

DATA:

T_AIRLINE LIKE

STANDARD TABLE

OF FS_AIRLINE

WITH NON-UNIQUE KEY FLICONNID.

PERFORM POPULATE_TABLE.

PERFORM DISPLAY_TABLE.

&----

---

*& Form POPULATE_TABLE *

&----

---

• This subroutine populates the internal table with flight details. *

----

---

• There are no interface parameters to be passed to this subroutine. *

----

---

FORM POPULATE_TABLE.

CLEAR FS_AIRLINE.

FS_AIRLINE-CARRID = 'AA'.

FS_AIRLINE-FLICONNID = '0017'.

FS_AIRLINE-FLITDATE = '19991212'.

APPEND FS_AIRLINE TO T_AIRLINE.

CLEAR FS_AIRLINE.

FS_AIRLINE-CARRID = 'DL'.

FS_AIRLINE-FLICONNID = '1984'.

FS_AIRLINE-FLITDATE = '20000506'.

APPEND FS_AIRLINE TO T_AIRLINE.

CLEAR FS_AIRLINE.

FS_AIRLINE-CARRID = 'AA'.

FS_AIRLINE-FLICONNID = '0026'.

FS_AIRLINE-FLITDATE = '19990804'.

APPEND FS_AIRLINE TO T_AIRLINE.

CLEAR FS_AIRLINE.

FS_AIRLINE-CARRID = 'UA'.

FS_AIRLINE-FLICONNID = '0941'.

FS_AIRLINE-FLITDATE = '20001111'.

APPEND FS_AIRLINE TO T_AIRLINE.

CLEAR FS_AIRLINE.

FS_AIRLINE-CARRID = 'LH'.

FS_AIRLINE-FLICONNID = '1699'.

FS_AIRLINE-FLITDATE = '20000201'.

APPEND FS_AIRLINE TO T_AIRLINE.

CLEAR FS_AIRLINE.

FS_AIRLINE-CARRID = 'LH'.

FS_AIRLINE-FLICONNID = '0026'.

FS_AIRLINE-FLITDATE = '19770901'.

APPEND FS_AIRLINE TO T_AIRLINE.

ENDFORM. " POPULATE_TABLE

&----

---

*& Form DISPLAY_TABLE *

&----

---

• This subroutine displays the contents of internal table. *

----

---

• There are no interface parameters to be passed to this subroutine. *

----

---

FORM DISPLAY_TABLE.

LOOP AT T_AIRLINE INTO FS_AIRLINE.

WRITE:

/10 FS_AIRLINE-CARRID,

20 FS_AIRLINE-FLICONNID,

50 FS_AIRLINE-FLITDATE.

ENDLOOP. " LOOP AT T_AIRLINE...

SKIP.

LOOP AT T_AIRLINE INTO FS_AIRLINE.

IF FS_AIRLINE-FLITDATE EQ '19990804'.

WRITE:

/10 FS_AIRLINE-CARRID,

20 FS_AIRLINE-FLICONNID,

50 FS_AIRLINE-FLITDATE.

ENDIF.

ENDLOOP. " LOOP AT T_AIRLINE...

SKIP.

LOOP AT T_AIRLINE INTO FS_AIRLINE.

IF FS_AIRLINE-CARRID EQ 'LH'.

WRITE:

/10 FS_AIRLINE-CARRID,

20 FS_AIRLINE-FLICONNID,

50 FS_AIRLINE-FLITDATE.

ENDIF.

ENDLOOP. " LOOP AT T_AIRLINE...

SKIP.

LOOP AT T_AIRLINE INTO FS_AIRLINE.

IF FS_AIRLINE-FLITDATE GT '20000501'.

WRITE:

/10 FS_AIRLINE-CARRID,

20 FS_AIRLINE-FLICONNID,

50 FS_AIRLINE-FLITDATE.

ENDIF.

ENDLOOP. " LOOP AT T_AIRLINE...

try the above code and let me know if it meets ur requirement.

if u have field string with fields f1,f2,f3,f4,f5.

and if u want 2 insert only certain fields from work area 2 table then append those fields 2 table from work area other fields r filled with initial values depending on the data type.

regards,

kiran kumar k

Message was edited by:

kiran kumar kamati

[Former Member]

Hi,

DATA: wa TYPE scustom.

wa-id = '12400177'.

wa-name = 'Robinson'.

wa-postcode = '69542'.

wa-city = 'Heidelberg'.

wa-custtype = 'P'.

wa-discount = '003'.

wa-telephone = '06201/44889'.

INSERT INTO scustom VALUES wa.

Regards,

Sruthi

[Former Member]

Hi,

Let us suppose that work area is:"work_area" and the fields are a,b,c,d,e,f,g, and h

And internal table is itab1(with header line) and fields are a,b,c, and d only.

Now you do the following steps.

itab1-a = work_area-a

itab1-b = work_area-b

itab1-c = work_area-c

itab1-d = work_area-d

append itab1.

Your problem is done.

Regards,

Balakrishna.N