topic Re: how to make input parameter with multiple values in function module? in Application Development and Automation Discussions

how to make input parameter with multiple values in function module?

Former Member — Wed, 14 Jan 2009 07:21:54 GMT

Hello Experts,

I want to create a function module which takes input as material number.

but how to make input parameter for material as it can take multiple material number at the time?

Regards

Re: how to make input parameter with multiple values in function module?

faisalatsap — Wed, 14 Jan 2009 07:26:41 GMT

Hi,

Use Select Options like the following and from the extension button you can give multiple values,

SELECT-OPTIONS: soregio FOR kna1-regio NO INTERVALS OBLIGATORY.

Replay if any Problem,

Kind Regards,

Faisal

Edited by: Faisal Altaf on Jan 14, 2009 12:27 PM

Re: how to make input parameter with multiple values in function module?

Former Member — Wed, 14 Jan 2009 07:30:01 GMT

create a range

DATA: r_matnr TYPE RANGE OF mara-matnr.

Re: how to make input parameter with multiple values in function module?

Former Member — Wed, 14 Jan 2009 07:32:14 GMT

Use TABLES Parameter instead of IMPORT Parameter for multiple input.

Re: how to make input parameter with multiple values in function module?

faisalatsap — Wed, 14 Jan 2009 07:33:13 GMT

Hi,

For more detail about the select option have a look at the following code.

TABLES: kna1.

SELECT-OPTIONS: soregio FOR kna1-regio NO INTERVALS OBLIGATORY.

data: it_kan1 like STANDARD TABLE OF kna1 WITH HEADER LINE,
      wa_it_kna1 like kna1.

select * from kna1
  into CORRESPONDING FIELDS OF TABLE it_kan1
  WHERE regio in soregio. "if you will give two region using the extension buttion it will select the all records have these two regions

Kind Regards,

Faisal

Re: how to make input parameter with multiple values in function module?

SuhaSaha — Wed, 14 Jan 2009 07:54:36 GMT

Hello Ronny,

how to make input parameter for material as it can take multiple material number at the time?

For this you need to have a range table for Material No.(MATNR).

SAP has provided a range table for MATNR - RANGE_T_MATNR(Range Table for Data Element MATNR). You can define your input parameter for material as import param:

R_MATNR TYPE RANGE_T_MATNR

Hope this will help.

BR,

Suhas

Re: how to make input parameter with multiple values in function module?

faisalatsap — Wed, 14 Jan 2009 07:56:49 GMT

Hi,

Declare and fill the range as under and then pass it to function module

ranges: rkunnr for kna1-kunnr.
rkunnr-sign = 'I'. rkunnr-option = 'EQ'.
  select kunnr from zsdo into rkunnr-low
     append rkunnr to rkunnr.
  endselect.

Use it just like Select-Option

select * from kna1
  into CORRESPONDING FIELDS OF TABLE it_kan1
  WHERE kunnr in rkunnr.

Define this Range in the "Tables" Tab in Function Module.

King Regards,

Faisal

Edited by: Faisal Altaf on Jan 14, 2009 2:19 PM