table deleted unfortunately

[Former Member]

hi experts i am new to abap, when i was working with

abap dictionary using MARA table , i have used append structure,

while doing that unfortunately, the table got locked. i has given

one information saying that i have to readjust table.

i went to SE14 and did that and i relesed lock.

then the MARA table got deleted from database

(but it is there in data dictionary)

is there any way to create only one table in

data base.

thamks in advance

chandra

[former_member204746 · Accepted solution]

what is your database? Oracle? maybe MARA exists under another temporary name at DB level.

[former_member204746]

chandra, you should close this topic and give 10 points to Fidel Vales .

[Former Member]

Hello,

I'm not sure what exactly you did. But if you add fields to a table ( via append structure or directly on the definition ) the table has to be adjusted.

If the table has already data it is converted:

-> table is renamed to QCMMARA

-> New table is created with the "new" structure ( QCM8MARA )

-> data is copied from old table to new table

-> indexes are created

-> "new" table is renamed ( QCM8MARA -> MARA )

-> "old" table is deleted.

Check if you have any of this qcm tables.