Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

performance tunning

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

Former Member
Not what you were looking for? View more on this topic or Ask a question