data updation in ztable

[Former Member]

hi,

by using following code I uploaded data into ztable but if one time we inserted data in ztable we can't change that

( insert ZPHYSICALSTOCK from table itab accepting duplicate keys.)

but i want if data will be changed in itab ,ztable have to be chaged means previous data must have to overwrite

with latest data .

plz reply me earliest

thanx ,

Jyotsna

[Former Member]

hi,

by using following code I uploaded data into ztable but if one time we inserted data in ztable we can't change that

( insert ZPHYSICALSTOCK from table itab accepting duplicate keys.)

but i want if data will be changed in itab ,ztable have to be chaged means previous data must have to overwrite

with latest data .

plz reply me earliest

thanx ,

Jyotsna

[Former Member]

Hi there,

I think you can using field symbols.

and modify .

thanks

Edited by: BrightSide on Dec 3, 2008 9:54 AM

[Former Member]

for that you have to use modify statement.

if data is already there in the ztable for the key fields, use

modify ztable from internal-table.

[Former Member]

hi,you can use

modify ztable from internal table.

thanks

[Former Member]

Hi ,

Use this

UPDATE ZPHYSICALSTOCK SET REV_RMZHL = WF_CONF_COUNT

REV_MBLNR = WL_SPACE

STOKZ = WL_SPACE

GR_RFLAG = WL_SPACE

STATUS = TEXT-020

USNAM = SY-UNAME

ERDAT = SY-DATUM

CPUTM = SY-UZEIT

WHERE RUECK EQ FS_TAB_CNTRL-RUECK AND

RMZHL EQ FS_TAB_CNTRL-RMZHL AND

MBLNR EQ FS_TAB_CNTRL-WABLNR.

the above syntax will update the already existing record in z-table with the changed values.

Hope this will help.

Regards,

Rohan.

Edited by: Rohan on Dec 3, 2008 12:30 PM

[Former Member]

hi reshma rimpa & BrightSide ,

my problem has been solved .

thanx a lot to all of u.

ragards,

Jyotsna

[Former Member]

Hi Jythsna,

Its always suggested to use MODIFY instead of UPDATE and INSERT !!

keep this thing remember when u r working fruther more !!

Regards

sAS

[Former Member]

hi rohan,

Thanx 4 reply but I didn't got ur code so , plz reply in detail.

regrads,

jyotsna

[Former Member]

Hi,

Anywayz your problem is solved ....

So cheers...

Rohan.