topic Edit field in a Data Base Table in Application Development and Automation Discussions

Edit field in a Data Base Table

Former Member — Thu, 08 May 2008 18:47:28 GMT

Hi Everyone,

I am trying to change field VERME(available stock) in LQUA table. The requirement is whenever the value is less than zero in VERME, we should change that to 0.

I know its not good to update the DB table directly, but there is no other alternative. The scope is very limited and I am trying to write some program just for this only purpose.

Have you guys any sample program for this requirement?

Thanks

Kumar.

Re: Edit field in a Data Base Table

Sm1tje — Thu, 08 May 2008 20:15:46 GMT

select all the rows where VERME LT 0 together with the whole key in an internal table. Change the field VERME to zero.

Next use UPDATE statement like this:

UPDATE dbtable FROM TABLE db_itab.

If you have a lot of records that need to be updated, you might want to consider to select packages of a 1000 records at once.

Re: Edit field in a Data Base Table

Former Member — Fri, 09 May 2008 00:30:53 GMT

While updating any data base , You should use the Lock Object concept also. So is some one else also trying to update the same table it doesn't give you short dump.

Re: Edit field in a Data Base Table

Former Member — Fri, 09 May 2008 11:24:17 GMT

Hi,

You can update a database table by first locking the table using Function module

ENQUEUE_TABLE_E

by passing table name.

Then update record in table using statement

update LQUA set VERME = 0

WHERE VERME le 0.

After this statement unlock the database table using function module

DEQUEUE_TABLE_E.

Reward points if answer is helpfull.

Regads,

Mukul Sharma

Re: Edit field in a Data Base Table

Former Member — Fri, 16 May 2008 10:51:43 GMT

hi,

you can use the lock object concept here firsst create one lock object in se11 and

update a database table by first locking the table using Function module

ENQUEUE_En by passing table name.Then update record in table using statement

update LQUA set VERME = 0WHERE VERME le 0.After this statement unlock the database table using function module

DEQUEUE_dE.

may be useful,

regards,

dilip

Re: Edit field in a Data Base Table

Former Member — Thu, 22 May 2008 20:45:22 GMT

Closing the thread because no longer in search for that answer.