https://community.sap.com/t5/application-development-and-automation-discussions/performance-improvement-suggestions/m-p/6831913#M1471695 <HTML><HEAD></HEAD><BODY><P>opened new thread</P></BODY></HTML> Thu, 22 Apr 2010 13:02:32 GMT Former Member 2010-04-22T13:02:32Z https://community.sap.com/t5/application-development-and-automation-discussions/performance-improvement-suggestions/m-p/6831912#M1471694 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I need to have improvement in below program but not sure if there is any major issue in performance of this program.</P><P>as the date being selected is huge ,but need to know how much we can imrove this program as far as performance is concerned.</P><P></P><P>select 1</P><P></P><P>SELECT matnr INTO (lt_zmatloc-/bic/zcmatloc)</P><P> FROM /sapapo/matkey</P><P> WHERE matnr IN prod_sel.</P><P></P><P> itotal-mat_no = lt_zmatloc-/bic/zcmatloc.</P><P></P><P> APPEND itotal.</P><P> ENDSELECT.</P><P> SORT itotal ASCENDING.</P><P> DELETE ADJACENT DUPLICATES FROM itotal COMPARING mat_no.</P><P></P><P>select 2</P><P></P><P>LOOP AT itotal into lw_itotal.</P><P></P><P></P><P> SELECT SINGLE * INTO lw_matkey FROM /sapapo/matkey WHERE matnr = lw_itotal.</P><P> PERFORM get_lanes.</P><P> PERFORM compute_attr.</P><P></P><P></P><P> ENDLOOP.</P><P></P><P></P><P>form get lanes is as below</P><P></P><P>SELECT locfr locto matid INTO (lt_trprod-locfr, lt_trprod-locto, lt_trprod-matid)</P><P> FROM /sapapo/trprod</P><P> WHERE matid = lw_matkey-matid AND estkz = 'S'.</P><P></P><P> ilanes-locfr = lt_trprod-locfr.</P><P> ilanes-locto = lt_trprod-locto.</P><P> ilanes-matid = lt_trprod-matid.</P><P></P><P> APPEND ilanes.</P><P> ENDSELECT.</P><P></P><P></P><P>FORM compute_attr is as below</P><P></P><P>LOOP AT ilanes.</P><P></P><P> SELECT locno INTO lw_locparent FROM /sapapo/loc WHERE locid = ilanes-locfr.</P><P> ENDSELECT.</P><P> SELECT SINGLE matnr INTO lw_matnr FROM /sapapo/matkey WHERE matid = ilanes-matid.</P><P> SELECT locno INTO lw_locchild FROM /sapapo/loc WHERE locid = ilanes-locto.</P><P> ENDSELECT.</P><P> iattr-version = '000'.</P><P> iattr-zclocno = lw_locchild.</P><P> iattr-zcmatnr = lw_matnr.</P><P> iattr-zbod_lvl = low_lvl.</P><P> iattr-zbod_prnt = lw_locparent.</P><P> APPEND iattr.</P><P> MODIFY /lgc/ssbod_attr FROM iattr.</P><P></P><P> iattr-version = '000'.</P><P> iattr-zclocno = lw_locparent.</P><P> iattr-zcmatnr = lw_matnr.</P><P> iattr-zbod_lvl = high_lvl.</P><P></P><P> APPEND iattr.</P><P> ENDLOOP.</P><P> SORT iattr ASCENDING.</P><P> DELETE ADJACENT DUPLICATES FROM iattr COMPARING ALL FIELDS.</P><P> MODIFY /lgc/ssbod_attr FROM iattr.</P><P></P><P></P><P>please suggest what more performance impr can be done on this and how much will it can improve the selection or fetching from database.. by %wise</P><P></P><P>regards</P><P>Arora</P></BODY></HTML> Thu, 22 Apr 2010 11:53:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-improvement-suggestions/m-p/6831912#M1471694 Former Member 2010-04-22T11:53:41Z https://community.sap.com/t5/application-development-and-automation-discussions/performance-improvement-suggestions/m-p/6831913#M1471695 <HTML><HEAD></HEAD><BODY><P>opened new thread</P></BODY></HTML> Thu, 22 Apr 2010 13:02:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-improvement-suggestions/m-p/6831913#M1471695 Former Member 2010-04-22T13:02:32Z