topic Re: Performance --- BSID table in Application Development and Automation Discussions

Performance --- BSID table

former_member212005 — Thu, 30 Apr 2009 06:49:29 GMT

Hi,

I am creating a data fix program for BSID database table, where my selection screen parameter are

BUKRS (Company Code)

BELNR (Document Number)

BLART (Document Type)

ZLSCH (Payment Method)

using these selection screen parameter I am fetching entries from database table BSID...

However its taking lot of time to fetch data....

Is there any alternative approach.....other than creating Indexes..

Re: Performance --- BSID table

Sandeep_Panghal — Thu, 30 Apr 2009 06:52:18 GMT

As you mentioned that you have laready tried using secondary index with the selection paramters , now it depends on the number of entries for this selection group.

May you can tyr using CURSOR with package size say 50000.

Re: Performance --- BSID table

Former Member — Thu, 30 Apr 2009 06:57:15 GMT

Can u write ur query , how r u fetching the data.

Re: Performance --- BSID table

former_member212005 — Thu, 30 Apr 2009 07:05:45 GMT

SELECT bukrs

kunnr

gjahr

belnr

buzei

zfbdt

zbd1t

zlsch

zlspr

FROM bsid

INTO TABLE gt_bsid

WHERE bukrs EQ p_code "A

AND belnr IN so_belnr

AND blart IN so_blart

AND zlsch IN so_zlsch.

Re: Performance --- BSID table

Former Member — Thu, 30 Apr 2009 07:21:14 GMT

Hi Vin,

try this FM

FM_READ_BSID

Regards,

Amit

Re: Performance --- BSID table

former_member212005 — Thu, 30 Apr 2009 07:26:10 GMT

Sorry Amit....

Unable to find such a function module.......

Re: Performance --- BSID table

former_member435013 — Thu, 30 Apr 2009 07:45:59 GMT

Hi,

for fetches with BUKRS and BELNR you should use Table BKPF first.

Regards

Walter Habich

Re: Performance --- BSID table

former_member212005 — Thu, 30 Apr 2009 07:55:31 GMT

Walter, even if I use BKPF database table it will not solve my problem...

My requirement is that I have to fetch all the documents which are entered in the selection screen parameter and update a particular field......

Its when fetching it takes lot of time...

Re: Performance --- BSID table

Sandeep_Panghal — Thu, 30 Apr 2009 07:58:20 GMT

hmm...

few options you may try:

1. create secondary index if possible.

2. Create a FM and write this select in that , call this FM in background task and within teh FM use CURSORs.

Re: Performance --- BSID table

SuhaSaha — Thu, 30 Apr 2009 08:01:44 GMT

Hello Vin,

This is going to be a very expensive SELECT b'coz w/o the "Fiscal Year" in the selection-screen (BSID-GJAHR) you are trying to fetch all the Vendor "Open Items" from "Ad infinitum".

Is this what you want functionally? Or, can you restrict the selection by adding "Fiscal Year" in the selection-screen?

Plz revert back.

BR,

Suhas

Re: Performance --- BSID table

former_member212005 — Thu, 30 Apr 2009 08:11:39 GMT

Suhas.....

I tried the select statement by adding 'Fiscal year'....however the performance is more or less the same...

Alternatively....when I select data using KUNNR...the result is very fast.....

Re: Performance --- BSID table

SuhaSaha — Thu, 30 Apr 2009 08:16:31 GMT

Hello,

If i were in your position i will like to have the following params as MANDATORY in the selestion-screen:

Comp. Code: BSID-BUKRS,

Customer: BSID-KUNNR,

Fiscal Year: BSID-GJAHR.

Rest other fields are "good to have" & can be used based on your funstionality.

BR,

Suhas

Re: Performance --- BSID table

former_member212005 — Thu, 30 Apr 2009 08:20:31 GMT

Suhas,

I have already suggested the Business to replace the selection screen parameter (BELNR) with KUNNR....So that everything goes smoothly....

Thanks for the Reply....

Re: Performance --- BSID table

SuhaSaha — Thu, 30 Apr 2009 08:22:32 GMT

Hello,

I will suggest have "Fiscal Year" in the selection-screen as well. It will reduce the "selection" times as well )

BR,

Suhas

Re: Performance --- BSID table

former_member212005 — Tue, 12 May 2009 11:33:50 GMT

The Selection Screen parameter has been changed! hurray

Re: Performance --- BSID table

Former Member — Tue, 12 May 2009 13:43:11 GMT


>     I am creating a data fix program for BSID database table, where my selection screen parameter are

A data fix program for BSID??

Rob