AUFK table partly active

[Former Member]

Hi All,

As part of a user exit implementation, I tried to add 2 custom fields and i standard field AUFPL in customizing include CI_AUFK of database table AUFK. Since then it is not getting completely activated. I even tried to Adjust the database using database utility.

Any pointers in this regards are highly appreciated.

Thanks & Regards,

Shreya

Edited by: Rob Burbank on Apr 21, 2010 3:58 PM

[Former Member]

hi,

you can also use append structure to add new fields in AUFK table

thanks

shivraj

[Former Member]

Make sure that the fields you had added are not containing the data element - domain which is not initial. Or if data is not important then you can try delete and adjust database in data base utility

[Former Member]

Hi All,

I have found the solution to this issue. The runtime object of AUFK was getting deleted for unknown reasons. That is why it was not even getting activated and adjusted using Database utillity (SE14).

Solution: - Login to SAP Client 000 (Master Client) with DDIC and run database utility there. Try to activate and adjust the database table from there only. It will reset it according to the SAP standards and will activate it.

Also, if in process of adjusting it you have deleted the database table, though the data can be recovered using back up and re-do logs, the views and secondary indices also get deleted and wont get created even by adjusting it with DDIC id in client 000. In this case, use transaction DB02 to carry out the checks between Data - Dictionary and Database. You will find missing objects in database here. Go to se14 and create each object separately. Failing to do so can result in dumps in standard transaction. (Deleting table method is highly not recommended, should be the last option when everything else is failed).

Hope this information will be of some help to you.

Cheers,

Shreya

[aabhas_wilmar]

Generally a table goes partly active when you try to enhance the table with append structures that contain data elements / domains not consistent or inactive themselves. Another reason would be when you import a transport request but it fails for some of the many possible reasons.

A word of caution, I don't think it is a good idea to retrieve it's status from 000 as this might undo all the user enhancements to the table done previously.

I would analyse the root cause and activate related objects one by one to activate and adjust a partly inactive table.

Sometimes it just take a bit of time and reactivating a table makes it fully active after sometime.

Cheers,

Aabhas