Skip to Content

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

/wp-content/uploads/2015/07/crm_web_ui_1_749057.png

Step 3: Click on show enhancement button and click edit list and delete custom fields which you want to delete.

/wp-content/uploads/2015/07/crm_web_ui_2_749058.png

Step 4: once (deletion) flag is assigned at right hand side of custom field

/wp-content/uploads/2015/07/crm_web_ui_3_749059.png

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.

/wp-content/uploads/2015/07/crm_web_ui_4_749060.png

Special Thanks to Ravirajsinh Jadeja for the guidance 🙂

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. 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.

     

    Thanks,

    Faisal

    (0) 
    1. naresh kabar 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

       

      Regards,

      Naresh

      (0) 
  2. Vibhash Kumar

    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.

    (0) 
    1. naresh kabar 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.

      (0) 
      1. Vibhash Kumar

        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.

        (0) 
  3. Sanchez Wang

    Hi,

     

    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

    (0) 

Leave a Reply