topic Re: Problem with inserting new data record into internal table in Application Development and Automation Discussions

Problem with inserting new data record into internal table

Former Member — Mon, 27 Apr 2009 14:53:32 GMT

Hi experts,

I have one problem can you solve in one please

itab having 3 fields.database table having 2 fields.

i have to insert diff types of new constant data to 3 field of itab.

How to insert?

SELECT * FROM dbase table INTO corresponding fields of

TABLE itab.

SORT itab.

READ TABLE itab WITH KEY "mandt = sy-mandt

field1 = '20'

BINARY SEARCH TRANSPORTING field2.

IF sy-subrc = 0.

"here I HAVE TO ADD ONE CONSTANT new dataTO EXISTING itab."

IF itab -field2 IS INITIAL. "

itab -field2= 'X' .

MODIFYitab TRANSPORTING field2 WHERE

field1 = '20'

ENDIF.

Re: Problem with inserting new data record into internal table

Former Member — Mon, 27 Apr 2009 15:02:13 GMT

Hi,

write this format....


SELECT * FROM dbase table INTO corresponding fields of
TABLE itab.

SORT itab.


loop at itab wher field1 = '20'
IF itab -field2 IS INITIAL. "
itab -field2= 'X' .
MODIFY itab index sy-tabix.
ENDIF.
endloop.

Regards,

Prabhudas

Re: Problem with inserting new data record into internal table

Sm1tje — Mon, 27 Apr 2009 15:29:43 GMT

No need to do a LOOP pass at all. Try this instead:

DATA: lwa_itab like line of itab.

lwa_itab-field2 = 'X'.

MODIFY itab FROM lwa_itab TRANSPORTING field2

WHERE field1 = '20'

AND field2 IS INITIAL.