on 09-25-2006 8:31 AM
Hi,
we did some enhancement for datasource 2lis_03_bf. When we are extracting data it is taking very long time. Its been 4 hours and it didnt extract a single record whereas the extraction checker is showing records.
How to improve the speed of extraction for the datasource???
Hi Jayanth,
theres a quite a few things which u can check. Are you sure that the extraction itself is taking more time cos u told that the RSA3 gets the records.. so if RSA3 gets records, how much time it takes? it is after all your user exit code, it fetches data and shows. So basically check the source system job, how long it runs whe u extract data. If it runs for long, then u need to worry abt the SS. Otherwise there is either problem in transfering the records or while processing the datapacket. Post for more
Sriram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jayanth,
Maybe it depends by the ABAP code you introduced. Try to use a loop, to modify all records in Package one time. Hereunder an example code for BF with loop:
CASE i_datasource.
WHEN '2LIS_03_BF'.
LOOP AT c_t_data INTO l_biw_mc03bf0.
l_tabix = sy-tabix.
SELECT SINGLE bsart reswk INTO (v_zzbsart, v_zzreswk) FROM ekko WHERE ebeln = l_biw_mc03bf0-ebeln.
IF sy-subrc = 0.
l_biw_mc03bf0-zzbsart = v_zzbsart.
l_biw_mc03bf0-zzreswk = v_zzreswk.
ENDIF.
MODIFY c_t_data FROM l_biw_mc03bf0 INDEX l_tabix.
ENDLOOP.
ENDCASE.
Ciao.
Riccardo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.