Skip to Content
Author's profile photo naresh kabar

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 🙂

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Your welcome

      Author's profile photo Faisal PC
      Faisal PC

      Hi Naresh,


      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.




      Author's profile photo naresh kabar
      naresh kabar
      Blog Post Author

      It will just remark it for deletion.

      Author's profile photo naresh kabar
      naresh kabar
      Blog Post Author

      Hi Faisal,


      After deleting it will just set a flag as deleted /wp-content/uploads/2015/07/crm_web_ui_5_749062.png


      But not deleting appended custom fields from table




      Author's profile photo Former Member
      Former Member

      Hi Naresh,


      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.

      Any suggestion.

      Author's profile photo naresh kabar
      naresh kabar
      Blog Post Author

      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.

      Author's profile photo Former Member
      Former Member

      Hi Naresh,


      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.

      Author's profile photo Sanchez Wang
      Sanchez Wang



      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


      BR Sanchez