Selection critaria in Extractor

[Former Member]

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,

[Former Member · Accepted solution]

Hi

See the info

Assign points if useful

Thanks

N Ganesh

[Former Member · Accepted solution]

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 · Accepted solution]

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