Renaming primary index and constraints back to agree with SAP

[Former Member]

Well I installed new hardware and from the backup system I restored a list of tables from tape. Long and short of it, I removed the secondary indexes and the primary indexes are now renamed in the operation system. I rebuilt the secondary indexes. I can not rebuild these without disturbing the business. Is there anyway to get around rebuilding them and having people locked out. One of the tables is MSEG. I could leave it until the only down time is Christmas. This is what my system look like;

Missing Primary indexes

CDCLS-0

CKMI1-0

ECMCA-0

MCIPMIS-0

MLAUF-0

MLAUFCR-0

MSEG-0

ONRQM-0

QMEL-0

QMIH-0

RFBLG-0

STXH-0

STXL-0

TBTCS-0

VBFA-0

Unknown indexes in ABAP Dictionary

Q_R3PRDDATA_CDCLS_MANDANT_0000

Q_R3PRDDATA_CKMI1_MANDT_00002

Q_R3PRDDATA_ECMCA_RCLNT_00002

Q_R3PRDDATA_MCIPMIS_MANDT_0000

Q_R3PRDDATA_MLAUF_MANDT_00002

Q_R3PRDDATA_MLAUFCR_MANDT_0000

Q_R3PRDDATA_MSEG_MANDT_00002

Q_R3PRDDATA_ONRQM_MANDT_00002

Q_R3PRDDATA_QMEL_MANDT_00002

Q_R3PRDDATA_QMIH_MANDT_00002

Q_R3PRDDATA_RFBLG_MANDT_00002

Q_R3PRDDATA_STXH_MANDT_00002

Q_R3PRDDATA_STXL_MANDT_00002

Q_R3PRDDATA_TBTCS_JOBNAME_0000

Q_R3PRDDATA_VBFA_MANDT_00002

[Former Member]

Dunke Volker

Unfortunately we are true 7/24 and we have no downtime. Last year we only had 3 hours total when the system was not up. The only day I have to rebuild these primary indexes is Christmas.

Will having a different name for this primary index effect anything else, like support packs?

[Former Member]

Hi Anthony,

not that I know of any issues there ....

I would say: no issue at all !

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member]

Hi Anthony,

that sounds like on old bug in B5R3 without PTFs ;-((

It is not critical, but "un-nice" ...

Unfortunately, you cannot rename this back. You have to delete the wrong one and recreate the new one. As this has temporary not PK then, you need to STOPSAP for that. As CDCLS & MSEG sound big, it might take some time.

You can do that with WRKPFCST ...

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de