Skip to Content
author's profile photo Former Member
Former Member

Selection critaria in Extractor

Hi Gurus,

Am not much old in BW, I have developed a new Z extractor, as function module and in the structure I have made few fields as selection, which we can see as selection in RSA3, but now the problem is how to make the selection fields work, as its not filtering data right now. How can I make it to filter fetched data.

Thanks,

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 10:47 AM

    Hi

    See the info

    modifying-0fiar4-extractor-selection

    Assign points if useful

    Thanks

    N Ganesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Hitesh,

      As you have deleveloped a FM extractor, you ahve to handle in the code with the fields that you have taken in Selection .. see the Code :

      RANGES: l_r_datum FOR z_bw_es_cyt_psd-datum . "Define selections like this

      ************************************************************************

      • Data transfer: First Call OPEN CURSOR + FETCH

      • Following Calls FETCH only

      ************************************************************************

      • First data package -> OPEN CURSOR

      IF s_counter_datapakid = 0.

      • Fill range tables BW will only pass down simple selection criteria

      • of the type SIGN = 'I' and OPTION = 'EQ' or OPTION = 'BT'.

      LOOP AT s_s_if-t_select INTO l_s_select.

      CASE l_s_select-fieldnm.

      WHEN k_fn_datum. "Selection field

      MOVE-CORRESPONDING l_s_select TO l_r_datum.

      CLEAR l_r_datum-high.

      l_r_datum-option = 'GE'.

      l_r_datum-sign = 'I'.

      APPEND l_r_datum.

      WHEN OTHERS.

      ENDCASE.

      ENDLOOP.

      • Determine number of database records to be read per FETCH statement

      • from input parameter I_MAXSIZE. If there is a one to one relation

      • between DataSource table lines and database entries, this is trivial.

      • In other cases, it may be impossible and some estimated value has to

      • be determined.

      OPEN CURSOR WITH HOLD s_cursor FOR

      SELECT * FROM cdhdr

      WHERE udate IN l_r_datum. " Use your selections for Selecting the data .

      ENDIF. "First data package ?

      Hope it helps..

      Thanks,

      Krish

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.