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

Modify Query Issue

koushikking
Explorer
0 Likes
1,427

Hi Experts,

I have situation where i must use modify query inside loop( modify ztable from table itab ), in development server query is working fine but in quality when control moves modify query it is stops and no further execution is happening. Please anyone guide me on this issue.

1 ACCEPTED SOLUTION
Read only

koushikking
Explorer
0 Likes
1,392

Hi All,

Sorry for the late reply,

i found the solution, it is stopping because the table has been locked.

Thanks all for your replys

10 REPLIES 10
Read only

Former Member
0 Likes
1,392

Hi,

Can you get the screenshot of what is happening in the debugger.

May be the table (Ztable) is not transported in the quality or the data is huge to be modifies in the loop.

Hope this helps.

Read only

0 Likes
1,392

Hi,

The table is already there in quality, i have added some extra fields and then again transported.

Read only

Austin_D_Costa
Explorer
0 Likes
1,392

Hello Koushik,

Even i have faced the same problem!!! But Didn't get he solution for that.

Have you checked with the table!!!

Read only

0 Likes
1,392

Hi Austin,

I Checked and everything fine with the table.

Read only

0 Likes
1,392
Read only

0 Likes
1,392

Have you also checked, if the table really exists on the database.

Go to SE11 -> Open your table (display) -> Menu -> Utilities -> Database Object -> Database Utility

Read only

0 Likes
1,392

Hi Armin,

Yeah, i did Checked and it exists.

Read only

pranay570708
Active Contributor
0 Likes
1,392

Check DB lock in DB01 tcode.

Read only

Former Member
0 Likes
1,392

How many records are there in table LT_META_I?

Rob

Read only

koushikking
Explorer
0 Likes
1,393

Hi All,

Sorry for the late reply,

i found the solution, it is stopping because the table has been locked.

Thanks all for your replys