on 04-01-2008 12:53 PM
hey BI gurus!!,
i have created a data source in RSO2 through a function module..
i have written the necessary code to populate the data in the fields.
now when i go to RSA3 and give the data source name and click on extraction m getting an error
"The extraction program does not support object <Data Source Name>"
Can somebody help me out please?
its very urgent
thanks & appreciated
Edited by: Vinit Dedhia on Apr 1, 2008 1:53 PM
Hi,
Check this code:-
Check DataSource validity
CASE i_dsource.
WHEN 'XXXXXX'.
WHEN OTHERS.
IF 1 = 2. MESSAGE e009(r3). ENDIF.
this is a typical log call. Please write every error message like this
log_write 'E' "message type
'R3' "message class
'009' "message number
i_dsource "message variable 1
' '. "message variable 2
RAISE error_passed_to_mess_handler.
ENDCASE.
Check if u have supplied correct data source name in the code.
Regards,
Rubal Kalra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Example: DataSource for table SFLIGHT
TABLES: eban,vttk,vfkp.
Auxiliary Selection criteria structure
DATA: l_s_select TYPE srsc_s_select.
DATA : itab_eban TYPE TABLE OF eban WITH HEADER LINE.
DATA: BEGIN OF itab_vttk OCCURS 0,
route LIKE vttk-route,
datbg LIKE vttk-datbg,
daten LIKE vttk-daten,
tknum LIKE vttk-tknum,
END OF itab_vttk.
DATA: BEGIN OF itab_vfkp OCCURS 0,
rebel LIKE vfkp-rebel,
ebeln LIKE vfkp-ebeln,
ebelp LIKE vfkp-ebelp,
lblni TYPE vfkp-lblni,
END OF itab_vfkp.
DATA : itab TYPE TABLE OF ztestproj10.
DATA : witab TYPE STANDARD TABLE OF ztestproj10 WITH HEADER LINE.
DATA: cnt TYPE i.
Maximum number of lines for DB table
STATICS: s_s_if TYPE srsc_s_if_simple,
counter
s_counter_datapakid LIKE sy-tabix,
cursor
s_cursor TYPE cursor,
s_cursor2 TYPE cursor,
s_cursor3 TYPE cursor.
Select ranges
RANGES: L_R_CARRID FOR SFLIGHT-CARRID,
L_R_CONNID FOR SFLIGHT-CONNID.
Initialization mode (first call by SAPI) or data transfer mode
(following calls) ?
IF i_initflag = sbiwa_c_flag_on.
************************************************************************
Initialization: check input parameters
buffer input parameters
prepare data selection
************************************************************************
Check DataSource validity
CASE i_dsource.
WHEN '0SAPI_SFLIGHT_SIMPLE'.
WHEN 'ZEBAN2'.
WHEN OTHERS.
IF 1 = 2. MESSAGE e009(r3). ENDIF.
this is a typical log call. Please write every error message like this
log_write 'E' "message type
'R3' "message class
'009' "message number
i_dsource "message variable 1
' '. "message variable 2
RAISE error_passed_to_mess_handler.
ENDCASE.
APPEND LINES OF i_t_select TO s_s_if-t_select.
Fill parameter buffer for data extraction calls
s_s_if-requnr = i_requnr.
s_s_if-dsource = i_dsource.
s_s_if-maxsize = i_maxsize.
Fill field list table for an optimized select statement
(in case that there is no 1:1 relation between InfoSource fields
and database table fields this may be far from beeing trivial)
APPEND LINES OF i_t_fields TO s_s_if-t_fields.
ELSE. "Initialization mode or data extraction ?
************************************************************************
Data transfer: First Call OPEN CURSOR + FETCH
Following Calls FETCH only
************************************************************************
First data package -> OPEN CURSOR
IF s_counter_datapakid = 0.
SELECT route datbg daten tknum
FROM vttk INTO TABLE itab_vttk.
SELECT rebel ebeln ebelp lblni FROM vfkp
INTO TABLE itab_vfkp.
OPEN CURSOR WITH HOLD s_cursor FOR
SELECT * FROM eban.
ENDIF. "First data package ?
Fetch records into interface table.
named E_T_'Name of extract structure'.
FETCH NEXT CURSOR s_cursor
APPENDING CORRESPONDING FIELDS
OF TABLE itab
PACKAGE SIZE s_s_if-maxsize.
IF sy-subrc <> 0.
CLOSE CURSOR s_cursor.
RAISE no_more_data.
ENDIF.
LOOP AT itab INTO witab.
cnt = 1.
WHILE cnt = 1.
READ TABLE itab_vfkp WITH KEY
ebeln = witab-ebeln
ebelp = witab-ebelp
lblni = witab-lblni.
IF sy-subrc = 0.
witab-tknum = itab_vfkp-rebel.
IF itab_vfkp-rebel IS NOT INITIAL.
READ TABLE itab_vttk WITH KEY tknum = itab_vfkp-rebel.
IF sy-subrc = 0.
witab-route = itab_vttk-route.
witab-datbg = itab_vttk-datbg.
witab-daten = itab_vttk-daten.
ENDIF.
ENDIF.
ENDIF.
APPEND witab.
ENDLOOP.
e_t_data[] = witab[].
s_counter_datapakid = s_counter_datapakid + 1.
ENDIF. "Initialization mode or data extraction ?
ENDFUNCTION.
Hi,
This error is generated in following code.
If ur data source name is not ZEBAN2 then u have to change it in below code.
CASE i_dsource.
WHEN '0SAPI_SFLIGHT_SIMPLE'.
WHEN 'ZEBAN2'.
WHEN OTHERS.
IF 1 = 2. MESSAGE e009(r3). ENDIF.
this is a typical log call. Please write every error message like this
log_write 'E' "message type
'R3' "message class
'009' "message number
i_dsource "message variable 1
' '. "message variable 2
RAISE error_passed_to_mess_handler.
ENDCASE.
Please check it and if data source name is ZEBAN2 then write the exact error not <Data source name> etc. and post it.
Rubal Kalra
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.