topic Re: Update Table in Application Development and Automation Discussions

Update Table

Former Member — Thu, 22 Nov 2007 08:33:49 GMT

Hi all,

If i do this I am not inserting a new line on table ADR6? I need to update this table with one new entry. How can i do that?

The code bellow is not working.

LOOP AT lt_xvbpa.
UPDATE adr6
SET addrnumber = lt_xvbpa-adrnr
flgdefault = c_mark
home_flag = c_mark
WHERE .
COMMIT WORK AND WAIT.

Thanks a lot

Best regards

Re: Update Table

Former Member — Thu, 22 Nov 2007 08:34:42 GMT

update table dbname.

insert new line

DATA scarr_wa TYPE scarr.

scarr_wa-carrid = 'FF'.

scarr_wa-carrname = 'Funny Flyers'.

scarr_wa-currcode = 'EUR'.

scarr_wa-url = 'http://www.funnyfly.com'.

INSERT INTO scarr VALUES scarr_wa.

Re: Update Table

Former Member — Thu, 22 Nov 2007 08:37:36 GMT

Hi,

If u dont have any conditions in WHERE clause just remove it.

LOOP AT lt_xvbpa.
UPDATE adr6
SET addrnumber = lt_xvbpa-adrnr
flgdefault = c_mark
home_flag = c_mark.

COMMIT WORK AND WAIT.

ENDLOOP.

The above code will do.

Tnx,

Re: Update Table

former_member386202 — Thu, 22 Nov 2007 08:39:22 GMT

Hi,

Refer this code.

&----

*& Form SUB_READ_UPDATE_BSEG

&----

text

----

FORM sub_read_update_bseg.

IF NOT it_final[] IS INITIAL.

LOOP AT it_final INTO wa_final.

UPDATE bseg SET zuonr = wa_final-ccnum

WHERE bukrs EQ wa_final-bukrs

AND belnr EQ wa_final-vbeln

AND rfzei EQ wa_final-rfzei

AND saknr NE ' '.

ENDLOOP.

*--Message data updated successfully

MESSAGE i888 WITH text-002.

LEAVE LIST-PROCESSING.

ELSE.

*--Message No data found

MESSAGE i888 WITH text-003.

LEAVE LIST-PROCESSING.

ENDIF.

ENDFORM. " SUB_READ_UPDATE_BSEG

Regards,

Prashant

Re: Update Table

Former Member — Thu, 22 Nov 2007 08:39:30 GMT

here one more thing is addrnumber is a primary key field...which will not allow your updates..i hope....

anyhow try this....

LOOP AT lt_xvbpa.

UPDATE adr6

SET addrnumber = lt_xvbpa-adrnr flgdefault = c_mark home_flag = c_mark where addrnumber = '30938'.

COMMIT WORK AND WAIT.

Message was edited by:

Muthurajan Ramkumar

Re: Update Table

Former Member — Thu, 22 Nov 2007 08:45:06 GMT

Hum, i see your point Muthurajan Ramkumar.

I can't insert new lines in table ADR6 because I have addrnumber like a primay key field.

I tried all the examples and didn't worked. So I am not able to insert new lines in this table.

Thanks all.

Re: Update Table

Former Member — Thu, 22 Nov 2007 08:48:31 GMT

Hi,

If u want insert new entry, then try with INSERT command.This will insert a new line if there is no matching record found else it updates the table.

Tnx,