topic Export RANGES to function module in Application Development and Automation Discussions

Export RANGES to function module

Former Member — Thu, 16 Apr 2009 07:14:23 GMT

Can anyone tell, how to pass RANGES to function module.

i have report program in ,

DATA : BEGIN OF ITAB OCCURS 0,

MATNR LIKE MARA-MATNR,

END OF ITAB.

SELECT-OPTIONS : S_MATNR FOR MARA-MATNR.

I want all the values in S_MATNR in ITAB.

Note that S_MATNR has any value( Include, Exclude,Between, Equal etc.)

Re: Export RANGES to function module

Sandeep_Panghal — Thu, 16 Apr 2009 07:37:14 GMT

You can use table type/structure for MATNR as range table for apssing to FM.

e.g WSELMATNR ==> Range Table for Material Number

Re: Export RANGES to function module

Former Member — Thu, 16 Apr 2009 07:39:36 GMT

Hello


TABLES: MARA.
DATA : BEGIN OF ITAB OCCURS 0,
MATNR LIKE MARA-MATNR,
END OF ITAB.
DATA: IMARA LIKE MARA OCCURS 0 WITH HEADER LINE.

SELECT-OPTIONS : S_MATNR FOR MARA-MATNR.
SELECT * FROM MARA INTO TABLE IMARA WHERE MATNR IN S_MATNR.

LOOP AT IMARA.
  ITAB-MATNR = IMARA-MATNR. APPEND ITAB.
ENDLOOP.

Re: Export RANGES to function module

Former Member — Thu, 16 Apr 2009 07:51:45 GMT

1) Dictionary Structure SELOPT : Transfer Structure for Select Options.

2) Use it in the Import Parameters in Function Module.

3) Pass S_MATNR to the Function Module in your program.

Regards,

Gurpreet

Re: Export RANGES to function module

Former Member — Thu, 16 Apr 2009 08:05:26 GMT

Hi,

Define a type in the global data declaration of the function module as follows :


TYPES : BEGIN OF t_range_matnr,
        sign(1) TYPE c,
        option(2) TYPE c,
        low TYPE mara-matnr,
        high TYPE mara-matnr,
END OF t_range_werk.

" Define a table type
types matnr_tab type t_range_matnr occurs 0.

Once done, define the importing parameter of t_matnr in the function modules signature, lets call it matnr

In your program where you would call the function, lets say you have the select option as follows


SELECT-OPTIONS matnr FOR ekpo-matnr.

" In the call function simply pass matnr[]

call function 'select_mara'
 exporting 
   matnr = matnr[].

Done.

P.S. Do not forget the square brackets.

regards,

Advait

Edited by: Advait Gode on Apr 16, 2009 10:05 AM

Re: Export RANGES to function module

Former Member — Thu, 16 Apr 2009 08:12:51 GMT

thank you all

Re: Export RANGES to function module

pravinkumar_lokhande — Mon, 28 May 2012 12:33:06 GMT

Hi Guys,

This is working to pass the rage to function module

DATA t_matnr TYPE WSELMATNR OCCURS 0 WITH HEADER LINE.

DATA : p_labst TYPE mard-labst.

t_matnr-SIGN = 'I'.

t_matnr-OPTION = 'EQ'.

t_matnr-LOW = matnr-LOW.

t_matnr-HIGH = matnr-HIGH.

APPEND t_matnr.

select sum( labst ) from mard into p_labst

where matnr in t_matnr and werks = plant.

but i have problem in when i am pass nothing in material ( t_matnr ) and plant = '1010' at that time query returns zero . I want summation of all stock in 'MARD' against the plant as the query if we run in the report.

Thanks ..........

Re: Export RANGES to function module

Kartik2 — Mon, 28 May 2012 12:38:21 GMT

Hi,

To achieve this you may use the standard table type 'EFG_TAB_RANGES'. Hope it helps. Thank you.

Regards,

kartik

Re: Export RANGES to function module

pravinkumar_lokhande — Mon, 28 May 2012 13:06:10 GMT

Hi Kartik,

i am not getting can you please explain little more

Thanks..........

Re: Export RANGES to function module

Kartik2 — Mon, 28 May 2012 13:41:50 GMT

Hi,

You can create an importing parameter for your function module of type 'EFG_TAB_RANGES' and send select options to it.

Regards,

kartik