Unable to create table due to missing entries.

[Former Member]

Hi Guys,

We are trying to delete a setup table in ECC PRD but it is deleting table from database and is failing at the stage where it is to be created .

When checked the table MC03BF0SETUP in SE14, the option of create database is enabled however it gives a dump as follows:

Request: Create Table MC03BF0SETUP (BASIS/05.03.13/14:48)

Process: KECCQA_10

Entry in table IAORA missing

Entry in table IAORA missing

Error in code generation for creating table MC03BF0SETUP in the DB

Compare module DD_DECIDE ended with error(s)

Request for MC03BF0SETUP could not be executed

Similar issue exists in ECC QUA

When checked further , data class for the table MC03BF0SETUP in DEV is APPL1 and  it is USR02 in QUA and PRD. The USR02 doesn’t exist in IAORA table. Pls suggest how do i proceed.

Best Regards,

Madhura

[former_member188883]

Hi Madhura,

Similar issue exists in ECC QUA 
When checked further , data class for the table MC03BF0SETUP in DEV is APPL1 and  it is USR02 in QUA and PRD. The USR02 doesn’t exist in IAORA table. Pls suggest how do i proceed.

Could you share IAORA and TAORA entries from DEV and QAS.

Regards,

Deepak Kori

[Former Member]

Hello Sir,

I am unable to insert images here due to some error on SDN. Can i have your email id so that il send the screenshots...

Thankyou

Best regards,

Madhura

[Former Member]

Hello Sir,

The entry of USR02 is not present in either DEV or QUA IAORA / TAORA tables.

But this table MC03BF0SETUP is pointing towards USR02 which is not present in the tables now.

Pls suggest.

Best regards,

Madhura