Fetching data from MSEG table

Former Member — Wed, 16 Dec 2009 10:13:47 GMT

Dear Abap Gurus ,

I am trying to prepare a vendor Rating Report . There are particular 2 queries which have perfomance issues .The requirement is such that this report has to be executed for the whole financial year .

1st Query :

SELECT BELNR GJAHR BLDAT BUDAT CPUDT FROM EKBE INTO CORRESPONDING FIELDS OF TABLE T_ekbe

WHERE BUDAT IN S_SRDATE

AND BEWTP = 'E'

AND WERKS IN S_PLANT .

Question 1: Is there any additional parameter which i can add in the where clause for getting data from ekbe for vendor rating .

Above query gives 98,000 records .

After This , another below query is taking 12 minutes to get executed which takes data from MSEG . T_EKBE has 98,000 records .

SELECT MBLNR ZEILE CHARG ABLAD EBELN EBELP MATNR MENGE WERKS ABLAD LIFNR FROM MSEG INTO CORRESPONDING FIELDS OF TABLE T_MSEG

FOR ALL ENTRIES IN T_ekbe

WHERE MBLNR = T_ekbe-BELNR

AND MJAHR = T_ekbe-GJAHR

AND MATNR IN S_MATNR

AND WERKS IN S_PLANT

AND BWART = '101'

AND LIFNR IN S_VENDCD .

Question 2 : How to increase speed of this query for MSEG .

Thanks In advance ,

Devendra Singh

Re: Fetching data from MSEG table

Former Member — Wed, 16 Dec 2009 10:59:43 GMT

hi,

there are various ways you can increase speed:

1) process a few number of records each time say 10000 using parallel processing then automatically the total time will be reduced bt 1/10

2) second query fetch the record based on open cursor approach

3) you declare types in place of doing move corresponding and alos sort the table after 1st query deleting adajcent duplicates

topic Fetching data from MSEG table in Application Development and Automation Discussions

Fetching data from MSEG table

Re: Fetching data from MSEG table