topic FM in Application Development and Automation Discussions

FM

Former Member — Thu, 07 Jun 2007 09:35:06 GMT

Hi,

can we have a range for a F.M Source Code and if so may i know the steps pls

EG : SELECT-OPTION : S_VBELN FOR VBAP-VBELN,

S_POSNR FOR VBAP-POSNR.

Can you please provide an example .

Thanks,

Vind

Re: FM

Former Member — Thu, 07 Jun 2007 09:37:14 GMT

A range/select-option can be handle like an internal table by your FM.

You just have to add it in the "Table" section of your FM.

Hope this helps,

Erwan

Re: FM

Former Member — Thu, 07 Jun 2007 09:38:09 GMT

Hi ,

Can explain what is u r requirment..

Regards

Suresh.d

Re: FM

anversha_s — Thu, 07 Jun 2007 09:38:10 GMT

hi,

Ranges : r_one for mara-matnr.
Data : wa_ran like line of r_one.
 
wa_ran-sign = 'I'.
wa_ran-option = 'EQ'.
wa_ran-low  = '0018'.
append wa_ran to r_one.

wa_ran-sign = 'I'.
wa_ran-option = 'EQ'.
wa_ran-low  = '0025'.
append wa_ran to r_one.

 
Data : it_one type table of mara.
 
select *
into table it_one
from mara
where matnr in r_one. “now query will fetch only matnr 0018 and 0025.

Some tips:

What does SIGN "I" & "E" mean?

The 'I' value in the SIGN field denotes 'Include', that means to Include the values given in the LOW and HIGH fields.

U may use 'E' here to exclude these values, when u r using the range in a SELECT query.

What is OPTION?

Option can be a whole range, which includes:

EQ (Equal)

BT (Between)

CP (Contain Pattern)

Rgds

Anversha

Re: FM

Former Member — Thu, 07 Jun 2007 09:38:27 GMT

FORM GET_MULTIPLE .

Dynamically holding Field name

FIELD-SYMBOLS: <FST> TYPE STANDARD TABLE.

IF R_UNAME[] IS INITIAL.

IF NOT V_USERNAME IS INITIAL.

R_UNAME-SIGN = 'I'.

R_UNAME-OPTION = 'EQ'.

R_UNAME-LOW = V_USERNAME.

APPEND R_UNAME.

CLEAR R_UNAME.

ENDIF.

ASSIGN R_UNAME[] TO <FST>.

CALL FUNCTION 'COMPLEX_SELECTIONS_DIALOG'

EXPORTING

TITLE = 'Select Multiple Value'(059)

TEXT = 'Finish Group'(058)

SIGNED = 'X'

LOWER_CASE = ' '

NO_INTERVAL_CHECK = 'X'

JUST_DISPLAY = ' '

JUST_INCL = 'X'

TABLES

RANGE = <FST>

EXCEPTIONS

NO_RANGE_TAB = 1

CANCELLED = 2

INTERNAL_ERROR = 3

OTHERS = 4.

IF SY-SUBRC = 0.

READ TABLE R_UNAME INDEX 1.

IF SY-SUBRC = 0.

V_USERNAME = R_UNAME-LOW.

ENDIF.

ENDFORM. " GET_MULTIPLE

Re: FM

Former Member — Thu, 07 Jun 2007 09:40:05 GMT

Range or select option is nothing but holding multiple values for a field in the form a internal table

So declare a Import parameter like TABLES paramter for the fun module and use it.

declare a field like in TABLES PARAMETER

ITAB LIKE WSELKUNNR and use

Reward points for useful Answers

Regards

Anji

Re: FM

Former Member — Thu, 07 Jun 2007 09:40:31 GMT

HI,

You can use the Structure RANGE_C10 for these Select-options, if you want more length fields, use RANGE_CXX, here the XX is the length.

For Material use the Structure WSELMATNR

Regards

Sudheer

Re: FM

Former Member — Thu, 07 Jun 2007 09:41:28 GMT

Range or select option is nothing but holding multiple values for a field in the form a internal table

So declare a Import parameter like TABLES paramter for the fun module and use it.

declare a field like in TABLES PARAMETER

ITAB LIKE WSELKUNNR and use

Reward points for useful Answers

Regards

Anji