cancel
Showing results for 
Search instead for 
Did you mean: 

Selection critaria in Extractor

Former Member
0 Kudos
90

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,

View Entire Topic
Former Member
0 Kudos

Hi

See the info

Assign points if useful

Thanks

N Ganesh

Former Member
0 Kudos

Hi Ganesh,

Thanks but mine is not a standard extractor, and its a function module. and my problem is not of making the selection field appear, but how to make it work and filter the data.

Thanks,

Former Member
0 Kudos

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