topic Re: Select options for a report in Application Development and Automation Discussions

Select options for a report

Former Member — Tue, 24 Jul 2012 05:44:38 GMT

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

Re: Select options for a report

Aashish28 — Tue, 24 Jul 2012 05:51:23 GMT

Hiii,

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

Re: Select options for a report

yogendra_bhaskar — Tue, 24 Jul 2012 05:52:36 GMT

hi Indu ,

Your requirement is not clear , what you really want ?

are talking about select options to be obligatory

regards ,

Yogendra Bhaskar

Re: Select options for a report

Former Member — Tue, 24 Jul 2012 06:15:03 GMT

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.

Re: Select options for a report

Aashish28 — Tue, 24 Jul 2012 06:22:21 GMT

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 .

Re: Select options for a report

Former Member — Tue, 24 Jul 2012 06:25:22 GMT

READ DOCUMENTATION FOR SELECT OPTIONS.

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