topic Re: select option in function module in Application Development and Automation Discussions

select option in function module

Former Member — Mon, 02 Feb 2009 07:04:30 GMT

I have:

select-options: s_date for oijne-astdtt. in my screen.

I want to put my code in a function module, but as known that the s_date structure is

s_date-low

s_date-high

also in select statment,

select nomtk into table int_fnomtk from oijne where astdtf in s_date.

I want to pass the s_date value to the where condition in the select statment.

how i can u solve this problem.

Re: select option in function module

Sm1tje — Mon, 02 Feb 2009 07:10:54 GMT

Use this structure as your import parameter:

RSDSSELOPT

Re: select option in function module

faisalatsap — Mon, 02 Feb 2009 07:16:11 GMT

Hi,

In Tables Tab define s_date with out giving any Typeing or Associated Type and while calling function pass Select-Option ore Range and you can also use this u2018S_dateu201D just like you did in excitable Program using IN .

Hope will solve out your problem,

Kind Regards,

Faisal

Re: select option in function module

Former Member — Mon, 02 Feb 2009 07:16:29 GMT

wat u can do is to create a structure for the range or use existing strucrure....

refer structure: VDDATE_RANGE

Re: select option in function module

former_member222860 — Mon, 02 Feb 2009 07:20:58 GMT

Hi,

Say if you have two import parameters in your FM for 'date_low' and 'date_high', then this code works:

DATA: BEGIN OF ITAB OCCURS 0.
       INCLUDE STRUCTURE MARA.
 DATA: END OF ITAB.       
  
  RANGES: ERSDA1 FOR MARA-ERSDA.

  ERSDA1-LOW = ERSDA_LOW.
  ERSDA1-HIGH = ERSDA_HIGH.
  ERSDA1-SIGN = 'I'.
  ERSDA1-OPTION = 'BT'.
  APPEND ERSDA1.
 
  SELECT * FROM MARA
             INTO TABLE ITAB
             WHERE MATNR IN MATNR1.

LOOP AT ITAB.
WRITE:/ ITAB-MATNR, ITAB-ERSDA.
ENDLOOP.

Mahesh

Re: select option in function module

faisalatsap — Mon, 02 Feb 2009 07:28:26 GMT

Hi, Ali

You can use these Structures as given by Micky and TT RSDSSELOPT , VDDATE_RANGE,

But in Future if you need to use u201CFOR ALL ENTRIES INu201D than you again have to change this with no Structure type Because in this way you can send any type of Table.

Please Guide us in this way, Micky and TT.

Kind Regards,

Faisal

Re: select option in function module

former_member217544 — Mon, 02 Feb 2009 07:38:46 GMT

Hi Ali,

Check this table type: PLMT_AUDIT_RANGES_FOR_DATE.

Example code:


select-options: s_date for oijne-astdtt. in my screen.

data:  wa_data type PLMT_AUDIT_RANGES_FOR_DATE_WA.

wa_data-sign = ' I '. " (I or E based on req.)
wa_data-option = 'EQ'. (EQ or BT or Gt or GE or LE  etc. based on the req.)
wa_data-low = s_date-low .
wa_data-high = s_date-high.

Now you can pass the value wa_data as the function module input parameter.
Inside Function Module:
data: x_date type PLMT_AUDIT_RANGES_FOR_DATE.

append wa_data to x_date.

select nomtk into table int_fnomtk from oijne where astdtf in x_date.

Hope this wil help you.

Regards,

Swarna Munukoti.

Re: select option in function module

Former Member — Mon, 02 Feb 2009 07:39:32 GMT

Hi Ali,

You can use ranges,

Kindly go through the sample code below:

RANGES : r_afaber FOR anlp-afaber, " for depreciation area

r_peraf FOR anlp-peraf. " for depreciation period

&----

INITIALIZATION

&----

TO INITIALIZE ALL THE VARIABLES TO BE USED
IN THE PROGRAM

&----

INITIALIZATION.

r_afaber-sign = 'I'. " for inclusive

r_afaber-option = 'EQ'. " for equal operator

r_afaber-low = c_afaber_01. " depreciation area(low value)

APPEND r_afaber. " append values for depreciation area

r_afaber-sign = 'I'. " for inclusive

r_afaber-option = 'EQ'. " for equal operator

r_afaber-low = c_afaber_07. " depreciation area(low value)

APPEND r_afaber. " append values for depreciation area

r_peraf-sign = 'I'. " for inclusive

r_peraf-option = 'BT'. " for between operator

r_peraf-low = c_peraf_001. " depreciation period(low value)

r_peraf-high = c_peraf_012. " depreciation period(high value)

APPEND r_peraf. " append values for depreciation period

Hope it helps you

Regrds

Mansi

Re: select option in function module

Former Member — Mon, 02 Feb 2009 10:54:30 GMT

I want to explain my Case to be clear for every body,

Right now i have selection screen and complete code that generate a report.

The new idea is to run the report logic inside FM and remove selection-option not needed.

I do not like to change the logic too much,

Let say i have this selection screen

selection-screen begin of block b1 with frame title text-001.

select-options: s_date for oijne-astdtt,

s_soldto for oijnomi-soldto

selection-screen end of block b1.

Also I have this Query.

SELECT * FROM OIJNE WHERE DATE IN S_DATE and old in s_soldto.

Q1. How I can define imports parameter for S_DATE, and used them in Query instead of S_DATE.

Q2. In case of remove the selection option s_soldto, what i should put instead of .

Re: select option in function module

SuhaSaha — Mon, 02 Feb 2009 11:06:51 GMT

Hello,

You can define a range table as an import parameter for this:


I_R_DATE TYPE ACC_T_RA_DATE

ACC_T_RA_DATE --> Ranges Table for Date

Hope this helps.

BR,

Suhas

Re: select option in function module

faisalatsap — Mon, 02 Feb 2009 11:16:48 GMT

HI, Ali.

Just Copy and Past all your Program. With Out Selection Screen Components like Parameters and

--> Select-options in the Source Code Tab of FM window.

--> Than copy past all the name of you select option in the u201CTablesu201D tab in Parameter Name Colum

--> And Past all the Parameters in the Import Tab.

--> At last you have to Create a Structure and Table Type if you want to get an internal Table from your FM.

--> For Structure and Table Type Creation you can use SE11.

Do this and tell me where you are facing problem,

Wating for you Reply,

Kind Regards,

Faisal

Re: select option in function module

Former Member — Mon, 02 Feb 2009 11:29:44 GMT

hi Suhas Saha ,

Can u please be more clear about your suggestion.

Still i can not get u.

Re: select option in function module

Former Member — Mon, 02 Feb 2009 11:43:17 GMT

HI Ali,

U can do like this also

declare s_date as from_date and to_date in import parameter of FM

and use like this

select * from onije where assdt between from_date and to_date.

it wil work.

Regards,

Azhar

Edited by: Azhar on Feb 2, 2009 5:14 PM

Re: select option in function module

SuhaSaha — Mon, 02 Feb 2009 11:44:30 GMT

 
> The new idea is to run the report logic inside FM and remove selection-option not needed.
> 
> I do not like to change the logic too much, 
> 
> Let say i have this selection screen 
> 
> selection-screen begin of block b1 with frame title text-001.
> 
> select-options: s_date for oijne-astdtt,
>                       s_soldto for oijnomi-soldto
> 
> selection-screen end of block b1.
> 
> Also I have this Query.
> 
> SELECT * FROM OIJNE WHERE DATE IN  S_DATE and old in s_soldto.
> 
> Q1. How I can define imports parameter for S_DATE, and used them in Query instead of S_DATE.
> Q2. In case of remove the selection option s_soldto, what i should put instead of .

I assume you have to use the SELECT-OPTIONS of the report in the FM.

What i suggested was create an import param to the FM as a date range, so that you can have this as your input & use for the select as well.

Correct me if i am wrong in understanding your requirement !!!

BR,

Suhas

Re: select option in function module

former_member222860 — Mon, 02 Feb 2009 11:51:10 GMT

Hi Ali.

If you want to use the structure for the Range, here is piece of example

FUNCTION Z_DATE.
*"----------------------------------------------------------------------
*"*"Local interface:
*"  IMPORTING
*"     REFERENCE(DATE) LIKE  ACC_S_RA_DATE STRUCTURE  ACC_S_RA_DATE
*"  TABLES
*"      RESULT STRUCTURE  MARA
*"----------------------------------------------------------------------

DATA: BEGIN OF ITAB OCCURS 0.
        INCLUDE STRUCTURE MARA.
DATA:  END OF ITAB.

 RANGES: ERSDA1 FOR MARA-ERSDA.

  ERSDA1-LOW = date-LOW.
  ERSDA1-HIGH = date-HIGH.
  ERSDA1-SIGN = date-SIGN.
  ERSDA1-OPTION = date-OPTION.
  APPEND ERSDA1.

  SELECT * FROM MARA
             INTO TABLE ITAB
             WHERE ERSDA IN ERSDA1.

LOOP AT ITAB.
MOVE ITAB TO RESULT.
APPEND RESULT.
ENDLOOP.

ENDFUNCTION.

Give the values for date-low and date-high in 'Char' format.

Check if it works for ur case.

thanks\

Mahesh

Re: select option in function module

faisalatsap — Mon, 02 Feb 2009 12:09:02 GMT

Hi, Ali

Have a look at the Calling Program whic call a FM and Pass a Select-Option and Get a Internal Table from the Funtion with the name of the EMP.

Calling Program.

REPORT test_fm.
TABLES: pa0001.

DATA: it_pa0001 TYPE zfsl_test_tt WITH HEADER LINE.

SELECT-OPTIONS sopernr FOR pa0001-pernr.

CALL FUNCTION 'ZFSL_TEST'
  TABLES
    pernr_range = sopernr
  CHANGING
    itab        = it_pa0001[].

FUNCTION zfsl_test.
*"----------------------------------------------------------------------
*"*"Local Interface:
*"  TABLES
*"      PERNR_RANGE
*"  CHANGING
*"     REFERENCE(ITAB) TYPE  ZFSL_TEST_TT
*"----------------------------------------------------------------------

DATA: it_pa0001 TYPE zfsl_test_tt WITH HEADER LINE.

SELECT pernr ename FROM pa0001
  INTO CORRESPONDING FIELDS OF TABLE it_pa0001
  WHERE endda = '99991231'
    AND pernr IN pernr_range.

itab = it_pa0001[].

ENDFUNCTION.

Hope above will solve out your problem,

Please Reply if any Issue,

Kind Regards,

Faisal

Re: select option in function module

Former Member — Mon, 02 Feb 2009 12:44:04 GMT

Hi Faisal Altaf ,

I think your solution more suitable for my case.

In my old report i used subroutines, Where i should write those in FM, and where i should call them.

Re: select option in function module

Former Member — Tue, 03 Feb 2009 04:53:05 GMT

Hi Faisal,

you said that

--> Select-options in the Source Code Tab of FM window.

Can you explain more about this step.

You help will be appreciated.

Regard,

Ali

Re: select option in function module

faisalatsap — Tue, 03 Feb 2009 04:58:45 GMT

Hi,

*"----------------------------------------------------------------------
*"*"Local Interface:
*"  TABLES                                  ' Here in the Tables' Tab you can give the name of your select Option and use it in you code area as IN.
*"      PERNR_RANGE
*"  CHANGING
*"     REFERENCE(ITAB) TYPE  ZFSL_TEST_TT
*"----------------------------------------------------------------------

Please Reply if not clear.

Kind Regards,

Faisal

Re: select option in function module

SuhaSaha — Tue, 03 Feb 2009 05:09:12 GMT

Hello,

I think what i had suggested yesterday fits your requirement:

TABLES: bkpf.

DATA: it_bkpf TYPE STANDARD TABLE OF bkpf.

SELECT-OPTIONS:
s_bukrs FOR bkpf-bukrs,
s_budat FOR bkpf-budat.

START-OF-SELECTION.

* Get BKPF data
  CALL FUNCTION 'Z_GET_BKPF'
    EXPORTING
      i_r_bukrs     = s_bukrs
      i_r_date      = s_bukrs
    TABLES
      e_tab         = it_bkpf
    EXCEPTIONS
      no_data_found = 1
      OTHERS        = 2.
  IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
  ENDIF.

The code for the FM 'Z_GET_BKPF' is as follows:

FUNCTION Z_GET_BKPF .
*"----------------------------------------------------------------------
*"*"Local Interface:
*"  IMPORTING
*"     REFERENCE(I_R_BUKRS) TYPE  FAGL_RANGE_T_BUKRS
*"     REFERENCE(I_R_DATE) TYPE  ACC_T_RA_DATE
*"  TABLES
*"      E_TAB STRUCTURE  BKPF
*"  EXCEPTIONS
*"      NO_DATA_FOUND
*"----------------------------------------------------------------------

  SELECT *
  FROM bkpf
  INTO TABLE e_tab
  WHERE bukrs IN i_r_bukrs
  AND   budat IN i_r_date.

  IF sy-subrc NE 0.
    RAISE no_data_found.
  ENDIF.


ENDFUNCTION.

I think this will be of some help.

BR,

Suhas