Index creation in BKPF table

[Former Member]

Hello Gurus,

I have a bad performance in IDCP transaction, i read the sap note 511819 and this recommend create an index in BKPF table with fields:

'MANDT'

'BUKRS'

'XBLNR'

But i see in the system the table have an index with fields:

MANDT

BUKRS

BSTAT

XBLNR

Is necessary the index creation if already exists one index with this fields?

The table have 150 million rows and 9 indexes.

What is your suggestion?

Best regards,

Ernesto Castro.

[Former Member · Accepted solution]

HI,

If you have already index 001 with MANDT BUKRS BSTAT XBLNR

fields than it's not necessary to create another index with MANDT BUKRS XBLNR fields.

you need to create index 001 on following table only as described in note.

table : VBRK fields : MANDT XBLNR

table : LIKP fields: MANDT XBLNR

also activate this index only during the least critical time ( when maximum free resources available )

regards,

kaushal