topic Re: Function Module in Application Development and Automation Discussions

Function Module

Former Member — Tue, 04 Jul 2006 12:59:41 GMT

hi friends,

iam declaring company code as import parameter in function module. later on iam calling that fuction module in report. but i declared company code as select-options. it is giving error. if iam declaring company code as a parameter then it is working.

pls, let me know how to declare it as select-options.

chandu

Re: Function Module

Former Member — Tue, 04 Jul 2006 13:01:45 GMT

Use below code

Select bukrs from t001 into i_t001 where bukrs in s_bukrs (ur select option.

check sy-dbcnt gt 0.

Loop at i_t001.

call function 'UR FUNCTION'

exporting

bukrs = i_t001-bukrs

Endloop.

Re: Function Module

RichHeilman — Tue, 04 Jul 2006 13:03:50 GMT

Defining as a select-option, you are giving the user the opportunity to enter mulitple company codes and ranges or even excluding. Do you want to fire this function module for all company codes which are valid for the select-option? If so, then you need to get all of the company codes in the SO, and loop thru that table.

data: it001 type table of t001 with header line.
select-options: s_bukrs for it001-bukrs.

select * into table it001 from t001
         where bukrs in s_bukrs.

loop at it001.
* Call your function module with 
* the company code in this table.
*  IT001-bukrs.
endloop.

Regards,

Rich Heilman

Re: Function Module

Former Member — Tue, 04 Jul 2006 13:04:30 GMT

do like this:

data: begin of it_t001 occurs 0,

bukrs type bukrs,

end of it_t001.

select bukrs

from t001

into it_t001

where bukrs in s_bukrs.

loop at it_t001.

call function '<func mod name>'

exporting <comp code> = it_t001-bukrs.

endloop.

Regards,

Ravi

Re: Function Module

Former Member — Tue, 04 Jul 2006 13:05:41 GMT

Hi chandra,

1. in the FM,

pass the parameter in

TABLES (not IMPORT)

2. and make it like this.

<b>BUKRS LIKE RNG_BUKRS</b>

(In TABLES Tab of se37)

<b>NOTE:

RNG_BUKRS is nothing but a RANGE for BUKRS,

which is nothing but copy of

select-option for bukrs field.</b>

3. then while calling the FM,

pass the select-option (eg. MYBUKRS)

using TABLES (and not EXPORTING)

4. In this way, in your FM,

u shall be able to fire query

IN BUKRS

(similar to select-option)

regards,

amit m.

Re: Function Module

Manohar2u — Tue, 04 Jul 2006 13:08:08 GMT

1. Select company code entries into ITAB.

2. change FM's signature as

import to tables for company code.

3. Pass the table to FM

4. Change the logic in FM to handle for multiple company codes.

Regds

Manohar

Re: Function Module

Former Member — Tue, 04 Jul 2006 13:21:08 GMT

Hi chandra,

Instead of using IMPORT use TABLES in the FM created by you.

IMPORT is used when only one value has to be passed.

Since you are using select-option, there will be n number of entries

You will need to use a LOOP in your FM and change the code accordingly.

Regards,

Sameena