Application Development and Automation 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: 
Read only

update database table fields

Former Member
0 Likes
645

hi,

i need update table vekp-NAMBE and VEKP-NAMEF. using my work area valuses wa_E1EDL37 how to do this, pls help me give me the sample code.

regards,

jai

4 REPLIES 4
Read only

former_member156446
Active Contributor
0 Likes
607

hi updating manually, with ur work area is not a good proactice.. either use a transaction which does the same purpose or write a BDC..

if still you want to use.. use modify update insert and after doing it use Commit work and wait statement.

Read only

Former Member
0 Likes
607

Try this.

update vekp set :

nambe = <ur value>

namef = <ur value>

where <ur condition if any>.

Read only

Former Member
0 Likes
607

Hi,

Try to use the FM V51P_XVEKP_YVEKP_UPDATE to update the field values in in table VEKP. Dont forget to give IF_UPDKZ = 'U'.

Rgds,

Bujji

Read only

i048168
Product and Topic Expert
Product and Topic Expert
0 Likes
607

Hi,

To update the database table fields using work area, use

UPDATE databasetablename FROM workarea.

This statement will overwrite the line of the databasetable which has the same primary key as the workarea.

Make sure,

the line type of the work area is exactly the same as the structure of the database table.

Regards

Vadi