Skip to Content
0
Former Member
Jun 15, 2012 at 07:36 AM

Performance issue fetching data from REGUP table

246 Views

Hi All,

I am fetching data from table REGUP for field laufd (Date on Which the Program Is to Be Run) using BELNR, GJAHR, BUKRS,BUZEI.

Apart from these fields I have LIFNR,AUGBL and also AUGDT in my source table.

Below is my select statement which is taking long time to execute some times may short dump(time exceeds).

SELECT belnr
gjahr
bukrs
buzei
laufd
FROM regup
INTO TABLE lt_regup

FOR ALL ENTRIES IN LT_DATA

WHERE bukrs = lt_data-bukrs

and belnr = lt_data-belnr

and gjahr = lt_data-gjahr

and buzei = lt_data-buzei.

Please help in to fetch the data for field laufd (Date on Which the Program Is to Be Run) field.

Thanks,

Jwala