Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

updating the db

Former Member
0 Kudos

Could somebody pls tell me how to update a db table ie a zdb table

with fields from an internal table which is declared similar to the zdb table?

thanks!!

1 ACCEPTED SOLUTION

ferry_lianto
Active Contributor
0 Kudos

Hi,

You can use INSERT, UPDATE or MODIFY statement.


INSERT ZTABLE FROM TABLE ITAB.

UPDATE ZTABLE FROM TABLE ITAB.

MODIFY ZTABLE FROM TABLE ITAB.

Regards,

Ferry Lianto

6 REPLIES 6

Former Member
0 Kudos

use the sap help for the commands

INSERT

MODIFY

UPDATE

or search on here....or wait for VASU G to reply with some random links.

0 Kudos

Martin,

you comments are the only ones worth to read...

"or wait for VASU G to reply with some random links"

0 Kudos

Sad thing is, its only funny cos its mostly true.

Its a shame we see so many posts these days (the number seems to be increasing daily) where people just cut and paste their answers from a local database or something.

I personally don't see this as helping anyone, especially not the original poster.

Gareth.

0 Kudos

maybe they are all bots.

ferry_lianto
Active Contributor
0 Kudos

Hi,

You can use INSERT, UPDATE or MODIFY statement.


INSERT ZTABLE FROM TABLE ITAB.

UPDATE ZTABLE FROM TABLE ITAB.

MODIFY ZTABLE FROM TABLE ITAB.

Regards,

Ferry Lianto

Former Member
0 Kudos

hi ,

good

u can use like this

UPDATE ZTABLE FROM TABLE ITAB.

reward if usefull