on 2007 Jan 09 10:26 AM
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.