Missing Index there Unknown indexes in ABAP Dictionary in DB02

[Former Member]

Dear All,

I am getting error in T-code DB02 >Missing Index there Unknown indexes in ABAP Dictionary.

Please find the following details.

Unknown indexes in ABAP Dictionary

DB indexes 11

MARA_MEINS

MARA_ZER

MCHA_VFDAT

VBRP_ARKTX

VBRP_CHARG

VBRP_FKIMG

VBRP_KZWI1

VBRP_MATKL

VBRP_MATNR

VBRP_SPART

VBRP_WERKS

Please suggest how to correct them and can caution we have to take before creating the

Index.

The process creating the index form se11 table and there index>database utility and than create .The same process can be use .

Regards,

[Former Member]

Hi,

Please use the below procdure:

- Goto transaction SE11

- Enter table name and press view

- Click button "Indexes..."

Please alse check with the below links for more information.

Index:

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb20446011d189700000e8322d00/content.htm

Creating Secondary Index

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb47446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/1c/252640632cec01e10000000a155106/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/c7/55833c4f3e092de10000000a114027/frameset.htm

Check with this also......[click here|;.

With Regards,

Krishna.

[Former Member]

Hi,

Indexes missing in the database

            Primary indexes                  0
            Secondary indexes                0

        Unknown indexes in ABAP Dictionary

            DB indexes                      11

DB indexes 11

MARA_MEINS
MARA_ZER
MCHA_VFDAT
VBRP_ARKTX
VBRP_CHARG
VBRP_FKIMG
VBRP_KZWI1
VBRP_MATKL
VBRP_MATNR
VBRP_SPART
VBRP_WERKS

        Optional indexes

            Too many indexes created         0

As you have suggest .

Goto transaction SE11

- Enter table name(MARA) and press view

- Click button "Indexes...

Here now I have to click on Create> new wind there table name and name of index

There I have to give MEINS than ok .

This process can be done direct in production online.

Regards,

[Former Member]

Hi,

Can you confirm us this problem comes now or from the day one.

Anil

[Former Member]

Hi

Check this link may help you

http://help.sap.com/saphelp_nw70/helpdata/en/c4/3a71e2505211d189550000e829fbbd/content.htm

Regards

Uday

[Former Member]

Hi,

No, there is performance issues and there are some z table also without index.

I am facing problem in creating index form SE14 in PRD as suggest the step are as following

1 in Tx SE14 >Table name(MARA)>EDIT>

Name MARA Transparent table

Short text General Material Data

Last changed SAP 17.05.2007

Status Active Saved

Exists in the database

-

---

But before i have done the same process form se11 on Primary & Secondary indexes

Please suggest the step to create indexes in ABAP Dictionary

,

we can create index directly on the production sever.

Regards,

[former_member185031]

Use SE14 to create an index of a table.

Regards,

Subhash