fbpx

Deleting a Field from the Query(SQ01)

One of the common issue that we face during the creation/ Modifcation of the Querry is to delete the fields from the Querry ( SQ01).

Every time  you try to remove the field from the data field group in SQ02 you will get the below message

Message no. AQ606
Diagnosis
You attempted to delete a field used in queries from the functional area.

In case if you face the issue , then kindly follow the below steps.

  • Go to the Transaction code => SQ01 Enter Your query Name and Hit the change Icon
  • Click on “Next Screen” icon( or F6)  on the “Change Query: Title Format” screen
  • Select or check “Field groups” ( select the field group to which fields to be deleted are assigned) to edit and click again on “Next Screen” icon only.
  • Kindly Uncheck the fields that you want to delete from the Query and save
  • Go to SQ02 –  change mode of Infoset – under section “Field Group/Data fields”  expand the field group and delete the fields you want.
  • Generate Infoset and Save

Hope this helped you , do leave a comment.
 
 

Spread the love

Leave a Comment