Select options for a report

[Former Member]

Hi

I am an abaper I have a requirement in select options.

My selection screen has these fields.

Now if user may give data in any one field or 2 or more fields how can i achieve this requirement.

It should work like standard one.

SELECT-OPTIONS: S_PSPID FOR PROJ-PSPID,
                             S_KUNNR FOR PROJ-ZKUNNR,
                             S_ZUSR01 FOR PROJ-ZUSR01,
                             S_ZUSR02 FOR PROJ-ZUSR02,
                             S_ZUSR00 FOR PROJ-ZUSR00.

Moderator message : Requirement dumping not allowed, search for available information, discussion locked.

Message was edited by: Vinod Kumar

[Aashish28]

Hiii,

        What exactly you want ??? fields mandatory ???? or hide or other function ????

[yogendra_bhaskar]

hi Indu ,

Your requirement is not clear , what you really want ?

are talking about select options to be obligatory

regards ,

Yogendra Bhaskar

[Former Member]

Hi

I have 5 select options user may give input in any one of them like

he may give input in field S_PSPID FOR PROJ-PSPID,

and execute or he may give input in both fields S_PSPID FOR PROJ-PSPID,
                                                                    S_KUNNR FOR PROJ-ZKUNNR,

and execute he should get data.

I can develop code for output but my problem is with select options  .

how to use assign select option fields in where condition of select statement when one field is empty and other is input.                     

[Aashish28]

Hii,

        Such as you want to select PSPNR PSPID POST1 OBJNR ERNAM fields

thans selct statement -

select PSPNR PSPID POST1 OBJNR ERNAM from proj into table itab where psid in S_PSPID

                                                                                                       and ZKUNNR in S_KUNNR.

else you can make separate select statement also .

if S_PSPID[] is not initial and S_KUNNR[] is initial.

select PSPNR PSPID POST1 OBJNR ERNAM from proj into table itab where psid in S_PSPID.

elseif S_PSPID[] is not initial and S_KUNNR[] is not initial

select PSPNR PSPID POST1 OBJNR ERNAM from proj into table itab where psid in S_PSPID

                                                                                                       and ZKUNNR in S_KUNNR.

endif.

same for rest of your select option fields .

hope you will understand .

Just try ..... otherwise tell me .

[Former Member]

READ DOCUMENTATION FOR SELECT OPTIONS.

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb3a1f358411d1829f0000e829fbfe/content.htm