topic Re: Delete fields in infoset in Application Development and Automation Discussions

Delete fields in infoset

Former Member — Mon, 21 Dec 2009 20:44:13 GMT

Hi.

I want to delete a field of an infoset but i can't because the system says that it is used in a query of the infoset. But the field is not used in the queries of the infoset. This field has domain values. How can i delete the field of the infoset.

Thanks.

Re: Delete fields in infoset

Former Member — Mon, 21 Dec 2009 21:01:05 GMT

I believe u need to delete the query

Max

Re: Delete fields in infoset

Former Member — Mon, 21 Dec 2009 21:20:33 GMT

Hi.

I don't know what query is.

Thanks

Re: Delete fields in infoset

Former Member — Tue, 22 Dec 2009 05:03:13 GMT

Hi,

Go to transaction SQ01 and view the list of queries which are built using this infoset. Then delete te query.

Thanks,

Harini

Re: Delete fields in infoset

Former Member — Tue, 22 Dec 2009 05:52:12 GMT

hi Jose,

There are three things related to query.

1. User group. transaction SQ03.

2.Infoset Transction SQ02. Each Infoset will have one user group.

3. Query Transaction SQ01. You can create Query just like you create your report program.you have to write the code in the infoset and can display the output layout in the query area (SQ01).each query is associated with one infoset and one user group..

Now if you want to delete any data field from the infoset then that data field should not be present in the Query so you need to delete that field from the query then only you can delete the field from infoset.

Hope this will solve your problem

thanks

tanmaya

Re: Delete fields in infoset

Former Member — Sat, 26 Dec 2009 05:57:40 GMT

Hi ,

1. Goto transaction code SQ02.

2. Then click on Goto menu and select query directoty (Shift+F8) .

3. Enter the name of the infoset and click on execute and you will get all the queris associated with that infoset.

Now you need to first delete the required field (i.e field which you want to delete) from these queris and then you will be able to delete it from infoset also.

Please let me know if this resolves your problem .

Regards,

Priya Bhat.

Re: Delete fields in infoset

Former Member — Mon, 14 Mar 2011 18:15:44 GMT

I've been trying to do this since I'm facing with same kind of issue. I found all the queries associated with this infoset.Deselected 'ListField' and 'Selection Fields' and saved the queries. Went back to the infoset and tried to delete the field group and fields and the table,but it did not let me to do that.

Thanks,

Raneetha

Re: Delete fields in infoset

Former Member — Fri, 01 Apr 2011 11:06:20 GMT

You want to delete the whole field group? I believe you should delete the fields of the field group first. You should deselect these fields from the queries, then save the query (SQ01).When all the fields are gone in the filed group (right hand pane) then you can delete the field group(SQ02).

Re: Delete fields in infoset

mohd_uzairhussain — Tue, 09 Aug 2011 15:30:06 GMT

Hi Raneetha,

Plz follow these steps to solve your problem

1. T code SQ01 - go to your Query in change mode

2. click on "Next Screen" icon on the "Change Query: Title Format" screen

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

4. Uncheck the fields that you want to delete from the Query and save

5. Go to SQ02 - change mode of Infoset - under section "Field Group/Data fields" expand the field group and delete the fields you want.

6. Generate Infoset and Save

Hope this helps

Regards,

Uzair Hussain

Re: Delete fields in infoset

Former Member — Wed, 28 Dec 2011 19:35:59 GMT

Delete the field groups and then go into Join and delete table. How about those apples?

Re: Delete fields in infoset

pratapbhat — Wed, 11 Oct 2023 05:00:44 GMT

Thank you Uzair Hussain !

I had been struggling with this part, and had been deleting the entire query earlier due to lack of a solution.

Regards,

Pratap.

Re: Delete fields in infoset

mohd_uzairhussain — Thu, 18 Apr 2024 19:12:33 GMT

Hi Pratapbhat,

I am happy to know that my response, given almost 12 years ago to some SAP consultant, was found useful to you as well..

Thanks,

Uzair Hussain Mohammed