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: 

Module Pool - SAVE_ALL takes 5 - 60 minutes

Former Member
0 Kudos
44

Hello SAPions,

Issue: SAVE_ALL takes lot of time. 5-60 minutes based on number of entries.

Version:ECC6.0

1. Screen ONE has selection screen.

once we execute(F8)

2. we get Screen TWO, with table control populated based on selection. with two buttons: CONDITIONS & SAVE ALL

2.1when CONDITIONS is Clicked, THIRD screen with some 72 lines in table control is generated with many validations.

2.2when SAVE_ALL is clicked all items in the second screen are looped and the necessary conditional data is populated. and saved one by one for each item.

i.e

LOOP AT IT_ITEM INO IS_ITEM.

IF condition1

Perform 1......

IF Condition2

Perform2.(with select statements....)

Perform3.

Perform4.

Endif.

Endif.

Perform SAVE. (with modify dbtab from itab statement.)(everytime ITAB will have 72 lines)

ENDLOOP.

NOW, when we click SAVE_ALL this is taking lot of time.5 - 60 minutes.

IF little data like 10items, it takes hardly 10seconds.

mostly... we have data like: 1500(items) * 72 = 108000 lines

Now.... I dont want to disturb the existing logic by taking select statements out of the performs etc.

Can someone suggest me something?

Can we push this to background processing ? or any other way.....

if yes, pls guide me.

Thanks,

Ashwin.

1 REPLY 1

Former Member
0 Kudos
25

closing the thread.