‎2009 Apr 27 3:53 PM
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.
‎2009 Apr 27 4:02 PM
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
‎2009 Apr 27 4:29 PM
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.