topic Selection screen fields in SAP Query in Application Development and Automation Discussions

Selection screen fields in SAP Query

Former Member — Wed, 09 Jul 2008 09:17:29 GMT

HI friends,

I have to make the seletion screen field as mandatory in SAP-Query.

Please let me know the procedure to make field as mandatory or Let me know how to validate the selection-screen field in Query.

Thanks in Advance,

Ravi

Re: Selection screen fields in SAP Query

Former Member — Wed, 09 Jul 2008 09:20:25 GMT

report ztest message-id zmsg.

tables :mara .

select-options:s_matnr for mara-matnr .

data: v_matnr like mara-matnr.

at selection-screen.

select matnr from mara into v_matnr where matnr in s_matnr.

if sy-subrc ne 0.

message e000 with 'enter a valid material number'.

endif.

Re: Selection screen fields in SAP Query

Former Member — Wed, 09 Jul 2008 09:22:35 GMT

Hi,

U can write:

select-options : field like type OBLIGATORY

This will make field mandatory.

Re: Selection screen fields in SAP Query

Former Member — Wed, 09 Jul 2008 09:35:18 GMT

To make a field mandatory in Sap query (SQ01) create a variant and in that variant make the field as required field (set the check box Required field). Use this variant whenever u execute the query.

Regards,

Joy.

Re: Selection screen fields in SAP Query

Former Member — Mon, 24 Sep 2012 11:13:49 GMT

Go to SQ02

Select your Infoset-->Change

On next Screen.

Select GoTo->Code->Initialization.

Write there code

LOOP AT SCREEN.
IF screen-name EQ 'SP$00004'.
screen-required = 1.
MODIFY SCREEN.
ENDIF.
ENDLOOP.

Re: Selection screen fields in SAP Query

jim_donahue — Fri, 31 May 2024 20:12:31 GMT

Thank you, this works, however it removes SELECTION BLOCKS. Which the users do not like.
I'm working on another solution. If you have an enhancement to this process, please share. I will share when the solution is found.