Default Fields for Selection in Custom Table

[PS_1978]

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

[Former Member]

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.

[PS_1978]

Hi Aparna,

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

Best Regards,

Phani

[Former Member]

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.

[Former Member]

Hi Phani Kumar,

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

Regards,

Sanket.

[Former Member]

Hi

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.