topic Re: Performance Issue While Fetching Record From MBEW Table in Application Development and Automation Discussions

Performance Issue While Fetching Record From MBEW Table

Former Member — Thu, 01 Nov 2007 08:25:07 GMT

Hi,

We are fetching records from mbew table using key fields matnr,bwkey.

When we use for all entries option in select statement the system gets hang.

So we are using concept of package size to increase the performance.

It works fine for minimum no of records but for large no of records it doesnt work.

Kindly guide us thru efficient way to resolve this issu.

The code is attached herewith for your reference

SELECT * FROM mard

INTO TABLE it_mard_temp package size 400

FOR ALL ENTRIES IN it_s033

WHERE matnr EQ it_s033-matnr

AND werks EQ it_s033-werks.

IF sy-subrc EQ 4.

MESSAGE e002(sy) WITH 'Record not found'.

ENDIF.

IF it_mard_temp[] IS NOT INITIAL.

SELECT matnr

bwkey

verpr FROM mbew

INTO TABLE it_mbew_temp

FOR ALL ENTRIES IN it_mard_temp

WHERE matnr = it_mard_temp-matnr

AND bwkey = it_mard_temp-werks.

ENDIF.

append lines of it_mard_temp to it_mard.

append lines of it_mbew_temp to it_mbew.

refresh: it_mard_temp,it_mbew_temp.

endselect.

With Regards

***************************Point is assured **********************

Re: Performance Issue While Fetching Record From MBEW Table

Former Member — Thu, 01 Nov 2007 08:35:10 GMT

HI...

Try using OPEN CURSOR..CLOSE CURSOR...command .

Praveen

Re: Performance Issue While Fetching Record From MBEW Table

Former Member — Thu, 01 Nov 2007 08:41:08 GMT

Nope,

Try to use Logical Database, if u cant find then let me know then i would give u correct LDB to use. LDB's are way more faster then using our queries. Sorry i dont have the system now. I will also let u know how to fetch data dynamically and with static attribute.

Thanks,

Usman Malik

Re: Performance Issue While Fetching Record From MBEW Table

Former Member — Thu, 01 Nov 2007 08:42:25 GMT

hi,

use the function module below it resets the runtime.

SELECT * FROM mard

INTO TABLE it_mard_temp package size 400

FOR ALL ENTRIES IN it_s033

WHERE matnr EQ it_s033-matnr

AND werks EQ it_s033-werks.

IF sy-subrc EQ 4.

MESSAGE e002(sy) WITH 'Record not found'.

ENDIF.

CALL FUNCTION 'ARCH_ANA_PROGRESS_INDICATOR'

EXPORTING

TEXT = 'Processing'.

IF it_mard_temp[] IS NOT INITIAL.

SELECT matnr

bwkey

verpr FROM mbew

INTO TABLE it_mbew_temp

FOR ALL ENTRIES IN it_mard_temp

WHERE matnr = it_mard_temp-matnr

AND bwkey = it_mard_temp-werks.

ENDIF.

append lines of it_mard_temp to it_mard.

append lines of it_mbew_temp to it_mbew.

refresh: it_mard_temp,it_mbew_temp.

endselect.

Re: Performance Issue While Fetching Record From MBEW Table

Former Member — Wed, 23 Jan 2008 06:35:35 GMT

thanks shiv . point has given