topic Re: update syntax in abap in Application Development and Automation Discussions

update syntax in abap

Former Member — Wed, 10 Jan 2007 14:49:17 GMT

Hi ,

I would like to update a record in a table...

Please help me.

Re: update syntax in abap

Former Member — Wed, 10 Jan 2007 14:52:57 GMT

Which table? Intenal or dictionary table?

- Internal table

LOOP AT ITAB.

MODIFY ITAB.

ENDLOOP.

- Dictionary

SELECT * FROM <TABLE>.

MODIFY <TABLE>.

ENDSELECT.

Max

Re: update syntax in abap

Former Member — Wed, 10 Jan 2007 14:56:33 GMT

CHK THIS FROM sap HELP


PARAMETERS p_carrid TYPE scarr-carrid. 

DATA scarr_tab TYPE SORTED TABLE OF scarr 
               WITH UNIQUE KEY carrid. 

DATA: idx TYPE sy-tabix, 
      scarr_wa TYPE scarr. 

SELECT * 
       FROM scarr 
       INTO TABLE scarr_tab. 

READ TABLE scarr_tab 
     WITH TABLE KEY carrid   = p_carrid 
     TRANSPORTING NO FIELDS. 

idx = sy-tabix. 

scarr_wa-currcode = 'EUR'. 

MODIFY scarr_tab INDEX idx FROM scarr_wa 
       TRANSPORTING currcode.

Re: update syntax in abap

Former Member — Wed, 10 Jan 2007 21:46:00 GMT

Hello Sathya,

If u want to update a database table u can use any one of the Command.

Insert - Inserts a new record to the table

Modify - Modify already existing record mainly thro internal table

Update - Update already existing record mainly thro work area

If useful reward

Vasanth