BSIS index

[Former Member]

Hi

Can somebody tell me what could be the best combination for BSIS index? what is the meaning of it if it is not showing any index when I click on indexes button? Does it not have any index by default?

[Former Member]

Hi

Can somebody tell me what could be the best combination for BSIS index? what is the meaning of it if it is not showing any index when I click on indexes button? Does it not have any index by default?

[Former Member]

The only SAP index for BSIS is the primary key. What fields did you have in mind?

Rob

[Former Member]

hi,

BSIS -

---

>Accounting: Secondary Index for G/L Accounts.

regards,

Ashokreddy.

[Former Member]

This is what is my requirement BUKRS = TSAKO-BUKRS

HKONT = TSAKO-HKONT

GJAHR IN GJAHX

BELNR IN DOCNR

BUDAT IN POSTDATE

XOPVW EQ CHAR_X.

, and the program is failing continously for DBIF_RSQL error. But does this mean that since the description says its a secondary index table it does not require separate index???

[Former Member]

That should be ok. Are there other details (an error and description of the error) in the dump?

Rob

[Former Member]

As usual the snapshot too old.

[Former Member]

Is it taking a long time to execute? It really shouldn't because you are passing the first two fields of the primary key. Are there a lot of entries for this particular GL?

Rob

[Former Member]

Maybe the database is getting fooled by the other fields in the where clause. Try:

SELECT *
  FROM bsis
  WHERE bukrs = tsako-bukrs
    AND hkont = tsako-hkont.

Then delete the records you don't want.

Rob

[Former Member]

This is the standard program SAPF124. So I dont think I have much room to play around.

[Former Member]

You should have said this at the beginning. There are a number of notes related to the performance of this program.

Rob

[Former Member]

Sorry Rob, you are correct. But is there any clues on this one now?

[Former Member]

Well, the forum can't really help changing standard SAP code or tables. You should make sure all applicable notes are applied and if the problem persists, open an OSS message. If it's an SAP problem, SAP should take care of it.

Rob

[Former Member]

Rob

I am not asking the changes in the program but relevant OSS Notes if known off hand.

Thanks

[Former Member]

I don't know - you have to look at them to see which are already in your system and which of the rest seem applicable.

Rob

[Former Member]

Hi,

You can force the sql statement to use a particular index by using %_HINTS parameter.

For eg:

SELECT carrid connid cityfrom

FROM spfli INTO (xcarrid, xconnid, xcityfrom)

WHERE carrid = 'LH ' AND cityfrom = 'FRANKFURT'

%_HINTS ORACLE 'INDEX("SPFLI" "SPFLI~001")'.

WRITE: / xcarrid, xconnid, xcityfrom.

ENDSELECT.

Refer to the SAP Note #129385 and related notes for further information.

Thanks

Ashok Reddy