Delete Custom Fields created via AET in sap CRM Web UI
Base on business requirement we add custom fields in SAP CRM Web UI via AET by using that tool we can enhance standard table and store data in customized fields.
But when we need to remove unnecessary fields from standard table at that time we only remove that custom fields from screen only of CRM Web UI but that custom field still remained in standard table which occupy unnecessary space in standard table.
By using AET we can add new field in SAP CRM Web UI and if you want to remove unwanted field to be removed from database table that will not remove by AET only deletion flag is added for that unwanted field it won’t remove that custom field physically.
To remove unused custom fields from database table SAP CRM has provided on standard program to delete custom fields from standard table AXT_EXT_GENERATE.
Steps to remove custom fields added via AET in SAP web UI:
Step 1: Go to your business role and Remove screen fields which you no longer needed from CRM web UI transactions.
Step 2: Click on configuration button and click on view area
Step 3: Click on show enhancement button and click edit list and delete custom fields which you want to delete.
Step 4: once (deletion) flag is assigned at right hand side of custom field
Step 5: Note down your enhancement ID for that custom fields in which AET has assigned name.
Step 6: In SAP GUI go to SE38 transaction and run AXT_EXT_GENERATE report and add your enhancement id and execute.
Special Thanks to Ravirajsinh Jadeja for the guidance 🙂
I was wondering why can't we use the normal way of AET field deletion?. It will also delete from everywhere including tables. You don't have to come to GUI. Just delete the field and then save and generate.
It will just remark it for deletion.
After deleting it will just set a flag as deleted
But not deleting appended custom fields from table
I needed to delete an AET field and I followed the same steps as you mentioned. But it gave an error "Generation Failed". After further checking I found data element used in this field was used somewhere in the code and it was causing the generation error. I removed the code and generated again using the report. But still getting the same issue.
go to transaction AXTSHOW and check your extension for element what has failed. It may occur this type of issue when AET table was locked in other request.
hope it may solve your problem.
Thanks for your response.
i got the error in regenerating through AXTSHOW as well.
Error was showing data element was used in multiple tables and structures.
Somehow by manually deleting the append structure in which field was there( as it was the only Z structure in the error list ) and regenerating through AXTSHOW, resolved the issue.
I have two questions. Firstly,Do we need transport deleted enhancement of AET?
Secondly when i execute delete, i got generate error that it says my field is not used in a data source of interactive report. what should i do for this? To be honest, this message is not logical, because i want to delete it, i do not need it relate with any interactive report data source