Performance on BKPF & RBKP using LDB

[Former Member]

Hi,

we are fetching initial records for the program from BKPF and RBKP tables. Data retrieval is taking huge time from these tables since user does not input BELNR, retrival from secondary index like RBKP_{4 BKPF}2 is also taking huge time.

Can we increase the performance by using LDB. Will that help to increase performance anyway. What is the LDB for these table to use.

Is there any other way to increase the perfomance also.

Regards,

Karthik.k

[Former Member]

Hi,

we are fetching initial records for the program from BKPF and RBKP tables. Data retrieval is taking huge time from these tables since user does not input BELNR, retrival from secondary index like RBKP_{4 BKPF}2 is also taking huge time.

Can we increase the performance by using LDB. Will that help to increase performance anyway. What is the LDB for these table to use.

Is there any other way to increase the perfomance also.

Regards,

Karthik.k

[Former Member]

I don't think using logical databases will help.Performance may even be worse.

What fields are you selecting?

Rob

[Former Member]

1) SELECT BUKRS BELNR GJAHR BLART BLDAT BUDAT CPUDT

USNAM BVORG XBLNR STBLG WAERS BSTAT AWTYP

INTO TABLE I_BKPF

FROM BKPF

WHERE BUKRS IN S_BUKRS

AND BSTAT IN R_BSTAT

AND BUDAT IN S_BUDAT

AND BELNR IN S_BELNR

AND BLART IN S_BLART

AND CPUDT IN S_CPUDT.

2) SELECT BELNR GJAHR BLART CPUDT BUKRS LIFNR RMWWR RBSTAT

ZUONR INTO TABLE I_PARKED_LIV

FROM RBKP

WHERE RBSTAT IN R_RBSTAT

AND LIFNR IN S_LIFNR

AND BUKRS IN S_BUKRS

AND CPUDT IN S_CPUDT

AND BLART IN S_BLART

AND BELNR IN S_BELNR

AND BUDAT IN S_BUDAT .

These two selects taking huge time, I have used secondary indexes. Problem is user is not entering BELNR in the input.

Regards,

Karthik.k

[Former Member]

The SELECT on BKPF should be OK so long as S_BUKRS R_BSTAT and S_BUDAT are all aways filled with values (there's an index).

What index does ST05 show is being used?

But I don't see much that can be done with the other SELECT.

Rob

Message was edited by:

Rob Burbank

[Former Member]

hi

good

as far as your select statement is concerned you can use the move corresponding statement with it to increase the performance or else if the user knows which belnr he is going to enter then you can hard coded that belnr in your select statement to increase the performance,.

thanks

mrutyun^

[Former Member]

Hi Karthik,

The query on BKPF is ok as it will not be that huge and you are also using indexes of that table,

but querying RBKP without the full key is a concern,

The best way is to enter the key. Just make key fields mandatory or if it is not feasible then ask to run the report in background.

Regards,

Atish