Hi Experts,
I have developed a report for shipment but it is timing out in production due large ammount of data.Please help as to what else can i do to improve performance. <removed_by_moderator>
START-OF-SELECTION.
*Subroutine for Delivery Due Index.
PERFORM sub_get_delivery_data.
*Subroutine for getting item data
PERFORM sub_get_itm_data using git_vepvg
CHANGING git_vbap.
Subroutine for SD document: Delivery Item data
PERFORM sub_get_del_itm_data using git_vbap
CHANGING git_lips.
Subroutine for Plant Data for Material
PERFORM sub_get_plnt_dtls using git_vbap
CHANGING git_marc.
Subroutine for storage location details
PERFORM sub_get_str_dtls using git_marc
CHANGING git_mard.
Subroutine for getting the Material Description
PERFORM sub_select_makt USING git_marc
CHANGING git_makt.
Subroutine for combining the data for display
PERFORM sub_build_final Changing git_vbap
git_vepvg
git_mard
git_vbep
git_lips
git_marc
git_makt
git_final.
*in error analysis it says to check below form.*
FORM sub_get_itm_data USING xt_git_vepvg TYPE gty_t_vepvg
CHANGING xyt_git_vbap TYPE gty_t_vbap.
REFRESH xyt_git_vbap.
IF NOT xt_git_vepvg[] IS INITIAL.
SELECT vbeln
posnr
matnr
brgew
vbelv
posnv
werks FROM vbap INTO TABLE xyt_git_vbap
FOR ALL ENTRIES IN xt_git_vepvg
WHERE vbeln = xt_git_vepvg-vbeln
AND posnr NE space.
SORT xyt_git_vbap BY vbeln.
ENDIF.
ENDFORM. " sub_get_itm_data
please help.
Thanks and Regards,
S.Ahmed.
Edited by: Julius Bussche on Sep 16, 2008 3:43 PM