cancel
Showing results for 
Search instead for 
Did you mean: 

extraction program does not support the object

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

hey rubal!!

thnks for rplying..

i had also written exactly the same code which u posted.

but m getting tht error..

wat might be the reason????

Edited by: Vinit Dedhia on Apr 1, 2008 2:25 PM

Former Member
0 Kudos

Can u paste ur code here?

Former Member
0 Kudos
  • 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.

Former Member
0 Kudos

Hi Vinit,

Please provide the exact error which u r getting from RSA3.

Rubal Kalra.

Former Member
0 Kudos

the error is

"The extraction program does not support object <Data Source Name>"

m using ECC 6.0..

i tried it in the training server its working fine..

m gettin this error in the client n/w..

Former Member
0 Kudos

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