topic Re: Default Fields for Selection in Custom Table in Application Development and Automation Discussions

Default Fields for Selection in Custom Table

PS_1978 — Fri, 05 Sep 2008 15:36:29 GMT

Hi,

I have created a custom table with 10 fields. If I click on Contents (Ctrl + Shift + F10) push button, all the fields are displayed as selection criteria for checking the values in table. But I want to give only 4 fields as default selection.

In general we can do it by using the menu option Settings --> Fields for Selection and chosing the necessary fields. But these are user specific and we can not transport these to other systems.

Is there any other way to achieve this?

Thanks & Best Regards,

Phani Kumar. S

Re: Default Fields for Selection in Custom Table

Former Member — Fri, 05 Sep 2008 16:14:26 GMT

I am not sure if this can be done in SE16...lets wait for other inputs....but we can definately do this using SQVI or ABAP query. You can choose the fields for input and output and ask users to run this query for this table instead of se16.

Re: Default Fields for Selection in Custom Table

Former Member — Sat, 06 Sep 2008 07:03:35 GMT

Hi Phani Kumar,

Just do it once Settings --> Fields for Selection and choosing the necessary fields, after transporting to other system.

Regards,

Sanket.

Re: Default Fields for Selection in Custom Table

PS_1978 — Mon, 08 Sep 2008 10:21:02 GMT

Hi Aparna,

Thanks for the reply. Could you please let me know how it can be achieved through ABAP Query?

Best Regards,

Phani

Re: Default Fields for Selection in Custom Table

Former Member — Thu, 11 Sep 2008 12:09:33 GMT

Hi Phani,

Here are the steps to create query

1) creare a infoset using sq02.

While creating infoset specify desired table

2) Using the infoset create a query in sq01.

While creating a query specify the fields required by you for selection.

3) assign the transaction to the query using se93.

Use the following link which explains you step by step.

http://help.sap.com/saphelp_46c/helpdata/en/d2/cb43b2455611d189710000e8322d00/frameset.htm

But you need to transport query as well.

Thanks,

Naveen Kumar.

Re: Default Fields for Selection in Custom Table

Former Member — Fri, 12 Sep 2008 12:11:32 GMT

if the fields for selection which u want are fix then simply create selection screen for those screen.

also create selection screen with more fields in case fields are not fixed and enter data only in fields u want.