topic Re: Multiple value parameter.... in Application Development and Automation Discussions

Multiple value parameter....

Former Member — Thu, 25 Oct 2007 03:01:56 GMT

Hi All,

I developed a Function Module where I have to pass a parameter with mulitple values.....similar to the one we use in Data Browser (SE16) for multiple values.

For example,

I want to select records from a table depending on the document type of the record.

The user will pass the document types which can be one type or two or any number of types.If its two then the FM should return all the records with those Document types.

The document types and the number of Document types to be passed are dynamic and are not consistent.

Help me to achieve this.

Thanks in advance.

Daniel.

Re: Multiple value parameter....

Former Member — Thu, 25 Oct 2007 03:09:53 GMT

Hi daniel,

There are tow ways,

Either declare it as of table type and pass the table to the FM.

Or declare it of select option type and pass that to FM.

Regards,

Atish

Re: Multiple value parameter....

Former Member — Thu, 25 Oct 2007 03:18:04 GMT

I tried that too.there are two problems in it,

(1) In Function Module I am not able to declare Select-Options

(2) Even if possible select options takes only continuous multiple values i.e. as a range between From value and To value.But i want to pass discrete values.

When I pass a table as a parameter to where clause,I get a error message that only table with range or select option structure can be used in where clause with "IN" in it.

Re: Multiple value parameter....

Former Member — Thu, 25 Oct 2007 03:21:38 GMT

Hi,

For which field you want select-option. There are lots of structure of type select option. If you can tell me field I can tell you if one availble.

For eg see ROIO_SEL

regards,

Atish

Re: Multiple value parameter....

Former Member — Thu, 25 Oct 2007 03:22:19 GMT

You just need to pass the parameter of type ROIO_T_SEL.

Regards,

Atish

Re: Multiple value parameter....

harimanjesh_an — Thu, 25 Oct 2007 03:27:10 GMT

hi daniel,

Select-options takes discrete values. U can specify range or even enter different values and then use IN clause in the where condition.

example :

Data : w_werks type marc-werks.

select-options : s_werks for w_werks.

s_werks-sign = c_i.

s_werks-option = c_eq.

s_werks-low = c_1017.

APPEND s_werks.

s_werks-low = c_1051.

APPEND s_werks.

s_werks-low = c_1018.

APPEND s_werks.

s_werks-low = c_1019.

APPEND s_werks.

s_werks-low = c_1070.

APPEND s_werks.

CLEAR s_werks.

See in this example, we are passing different plant values to select-options.

Then u can use,

SELECT * FROM marc WHERE werks IN s_werks.

<REMOVED BY MODERATOR>

Harimanjesh AN

Edited by: Alvaro Tejada Galindo on Feb 22, 2008 4:23 PM

Re: Multiple value parameter....

Former Member — Fri, 22 Feb 2008 21:06:53 GMT

Thanks. I am closing this thread