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.