topic Re: performance tuning in Application Development and Automation Discussions

performance tuning

Former Member — Wed, 05 Dec 2007 06:01:56 GMT

how do i rewrite the following using "for all entries" to improve performance?

DATA: BEGIN OF I_MARA OCCURS 0,

MATNR LIKE MARA-MATNR,

MTART LIKE MARA-MTART,

END OF I_MARA.

DATA : BEGIN OF I_SER01 OCCURS 0,

LIEF_NR LIKE SER01-LIEF_NR,

OBKNR LIKE SER01-OBKNR,

POSNR LIKE SER01-POSNR,

BWART LIKE SER01-BWART,

END OF I_SER01.

DATA : BEGIN OF I_OBJK OCCURS 0,

OBKNR LIKE OBJK-OBKNR,

SERNR LIKE OBJK-SERNR,

MATNR LIKE OBJK-MATNR,

END OF I_OBJK.

loop at i_ser01.

SELECT b_{obknr a}matnr b~sernr FROM mara AS a INNER JOIN

objk AS b ON b_{matnr = a}matnr INTO TABLE i_objk FOR ALL ENTRIES IN i_ser01

WHERE b~obknr = i_ser01-obknr

AND b~sernr IN sernr

AND a~mtart = 'FERT'

AND a~matnr IN matnr.

endloop

Re: performance tuning

Former Member — Wed, 05 Dec 2007 09:12:06 GMT


loop at i_ser01.

SELECT b~obknr a~matnr b~sernr 
             FROM mara AS a INNER JOIN objk AS b 
             ON b~matnr = a~matnr 
             INTO TABLE i_objk 
             FOR ALL ENTRIES IN i_ser01
             WHERE b~obknr = i_ser01-obknr
             AND b~sernr IN sernr
             AND a~mtart = 'FERT'
             AND a~matnr IN matnr.

endloop

Please read the online help again, the FOR ALL ENTRIES does what a loop would do. You can skip the loop ... endloop! otherwise you have a loop in loop!

Siegfried

Re: performance tuning

Former Member — Wed, 05 Dec 2007 10:12:49 GMT

SELECT b_{obknr a}matnr b~sernr

FROM mara AS a INNER JOIN objk AS b

ON b_{matnr = a}matnr

INTO TABLE i_objk

FOR ALL ENTRIES IN i_ser01

WHERE b~obknr = i_ser01-obknr

AND b~sernr IN sernr

AND a~mtart = 'FERT'

AND a~matnr IN matnr.

Thanks

Siva Kumar

Re: performance tuning

Former Member — Wed, 05 Dec 2007 10:34:55 GMT

You can use the below code instead of INNER JOIN.

SELECT obknr

sernr

matnr

INTO t_objk

FROM objk

FOR ALL ENTRIES IN i_ser01

WHERE obknr = i_ser01-obknr

AND sernr IN sernr

AND matnr IN matnr.

SELECT matnr

INTO t_mara

FROM mara

FOR ALL ENTRIES IN t_objk

WHERE matnr = t_objk-matnr

AND mtart = 'FERT' .

LOOP AT t_objk.

READ TABLE t_mara WITH KEY matnr = t_objk-matnr .

IF sy-subrc NE 0.

DELETE t_objk.

ENDIF .

ENDLOOP .

Reward Points to helpful answers.

Thanks.

Re: performance tuning

Former Member — Wed, 05 Dec 2007 12:23:34 GMT

THANK U FOR UR VALUEBLE ANSWERS AND ALL R REWARDED.