topic Re: update database table fields in Application Development and Automation Discussions

update database table fields

Former Member — Wed, 05 Mar 2008 04:05:17 GMT

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

former_member156446 — Wed, 05 Mar 2008 04:07:13 GMT

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.

Former Member — Wed, 05 Mar 2008 04:10:09 GMT

Try this.

update vekp set :

nambe = <ur value>

namef = <ur value>

where <ur condition if any>.

Former Member — Wed, 05 Mar 2008 04:13:39 GMT

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

i048168 — Wed, 05 Mar 2008 04:14:20 GMT

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