DTP taking long time
I am loading data from PSA to DSO .In the transformation we have written four field routines.
For 3 info objects we are fetching data from Billing DSO with the following code.But its taking long time to for loading.
Billing DSO table has 552394 records target DSO Condition data has around 800000 records.
Condition DSO has around 1600 Data packages.
data netval_inv1 type tys_TG_1-netval_inv.
select single netval_inv from /bic/ads_bil00 into netval_inv1 where
bill_num = SOURCE_FIELDS-VBELN and bill_item = SOURCE_FIELDS-POSNR.
if sy-subrc = 0.
RESULT = netval_inv1.
data stor_loc type tys_TG_1-STOR_LOC.
select single stor_loc from /bic/ads_bil00 into stor_loc where bill_num
= SOURCE_FIELDS-VBELN and bill_item = SOURCE_FIELDS-POSNR.
RESULT = stor_loc.
data GT_EXNUM1 type tys_TG_1-GT_EXNUM.
select single GT_EXNUM from /bic/ads_exdcs00 into GT_EXNUM1 where
/BIC/ZC_RDOC = SOURCE_FIELDS-VBELN .
RESULT = GT_EXNUM1.
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
INPUT = SOURCE_FIELDS-BSTNK_VF
OUTPUT = RESULT.
translate RESULT to upper case.
The processing time for a sample Data package is given below.
Data Package 1112 ( 5001 Data Records ) 11min 23 sec.
Extraction DataSource 2LIS_13_VDKON : 5001 Data Records 6min 57.
RSDS 2LIS_13_VDKON HDSCLNT130 -> ODSO 0SD_O06 : 5001 -> 5001 Data Records 4 min 25 sec.
Please give a solution to reduce the processing time.
Edited by: dharmatejandt on May 13, 2011 5:58 AM