Skip to Content
0
Former Member
Apr 22, 2010 at 11:53 AM

performance improvement suggestions

31 Views

Hi

I need to have improvement in below program but not sure if there is any major issue in performance of this program.

as the date being selected is huge ,but need to know how much we can imrove this program as far as performance is concerned.

select 1

SELECT matnr INTO (lt_zmatloc-/bic/zcmatloc)

FROM /sapapo/matkey

WHERE matnr IN prod_sel.

itotal-mat_no = lt_zmatloc-/bic/zcmatloc.

APPEND itotal.

ENDSELECT.

SORT itotal ASCENDING.

DELETE ADJACENT DUPLICATES FROM itotal COMPARING mat_no.

select 2

LOOP AT itotal into lw_itotal.

SELECT SINGLE * INTO lw_matkey FROM /sapapo/matkey WHERE matnr = lw_itotal.

PERFORM get_lanes.

PERFORM compute_attr.

ENDLOOP.

form get lanes is as below

SELECT locfr locto matid INTO (lt_trprod-locfr, lt_trprod-locto, lt_trprod-matid)

FROM /sapapo/trprod

WHERE matid = lw_matkey-matid AND estkz = 'S'.

ilanes-locfr = lt_trprod-locfr.

ilanes-locto = lt_trprod-locto.

ilanes-matid = lt_trprod-matid.

APPEND ilanes.

ENDSELECT.

FORM compute_attr is as below

LOOP AT ilanes.

SELECT locno INTO lw_locparent FROM /sapapo/loc WHERE locid = ilanes-locfr.

ENDSELECT.

SELECT SINGLE matnr INTO lw_matnr FROM /sapapo/matkey WHERE matid = ilanes-matid.

SELECT locno INTO lw_locchild FROM /sapapo/loc WHERE locid = ilanes-locto.

ENDSELECT.

iattr-version = '000'.

iattr-zclocno = lw_locchild.

iattr-zcmatnr = lw_matnr.

iattr-zbod_lvl = low_lvl.

iattr-zbod_prnt = lw_locparent.

APPEND iattr.

MODIFY /lgc/ssbod_attr FROM iattr.

iattr-version = '000'.

iattr-zclocno = lw_locparent.

iattr-zcmatnr = lw_matnr.

iattr-zbod_lvl = high_lvl.

APPEND iattr.

ENDLOOP.

SORT iattr ASCENDING.

DELETE ADJACENT DUPLICATES FROM iattr COMPARING ALL FIELDS.

MODIFY /lgc/ssbod_attr FROM iattr.

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

regards

Arora