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 Database table

Former Member
0 Kudos

Hi,

My requirement is to update the table EBAN(Purchase Requisition). Let us suppose that there are 3 items in the purchase requisition. If I make any changes to any of the item, the other two items need to be updated with the same changes. I am using a MODIFY....FROM <Internal Table> statement to update the changes in the database,

Now the problem is if I am making any changes in the 3rd item and press save, the database gets updated for 2nd and 3rd item only but the 1st item is not modified in the database.

If I make changes to the 1st item, then the modifications are done to 1st, 2nd and 3rd item and is working fine. The problem is when I make changes to 2nd or 3rd item then the 1st item does not get updated. I tried using update statement, locking table EBAN using ENQUEUE_E_TABLE but nothing worked.

I tried to use MODIFY...FROM <Workarea> inside a loop but it didn't work.

Kindly suggest.

Regards,

Amit Behera

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi

After modifying u append that values work area to internal table.

1 REPLY 1

Former Member
0 Kudos

Hi

After modifying u append that values work area to internal table.