Infoset Query Selection Screen Issue

[jogeswararao_kavala]

Dearf Experts,

I am a SAP-PM functional area. (Do know very little about technical sideof SAP)

I am working on SQ03/SQ02/SQ01 for the first time to create an Infoset query.

The output screen is incontrol and showing all the fields as per my specifications.

My problem is the Selection Screen. This is displaying to many things not desired by me.

1. Two tabs (I do not expect any tabs)

2. Many Screen areas, repeating the fields (1000,0100,0101,0102,0103)

The screen area of my specified fields in at the bottom.

My expectations about the selection screen is - just like simple one as in the case of SQVI.

Please help me in getting through this problem.

Regards

Jogeswara Rao

[former_member194416]

Hi,

Most probably your infoset is using a logical database as a data source. And tabs and selection fields are coming from this logical database. There may be possibilities to deactivate selection fields depending on the logical database that is used. Could you check if logical database is used and yes name of it ?

Regards,

[jogeswararao_kavala]

Gungor Ozcelebi,

Thank you very much for responding,

Exactly as you said, I am using Notifications logical database.

(I was suspecting this reason)

Infact I found about 8 fields (Perhaps related to Date fields, checkboxes etc) are automatically selected from the LDB.

My trials to delete them were invain. They reappear while saving.

I would be very thankful, if you help me in this case.

Regards...

[Former Member]

if you dont need so many thing in selection screen, then dont go for LDB. just create your own selection set with SQ01.

[jogeswararao_kavala]

Selection set you are referring, has to be from either an LDB and/or any Table/s. I am having to use LDB, to get the field 'System Status'. Otherwise VIQMEL table was satisfying the needs.

For my needs, deactivating the unwanted fields of LDB, as suggested by Gungor Ozcelebi, seems to be appropriate.

OR

Is there any other way to get the system status into the query?

Request your inputs accordingly.

Regards...

[former_member194416]

Hi,

LDB can be copied into a custom LDB (Also query must use this new LDB) using TCODE SE36 and selection fields can be closed. Also it is possible to solve the issue without LDB, system status can be choosen from JEST or using FM 'STATUS_READ'. I checked this LDB normally in HR it is possible to customize selection screen for LDB but I could not find any options for that in notifications.