RSAX_BIW_GET_DATA_SIMPLE - The extraction program does not support object

[Former Member]

Having problems with Function Module RSAX_BIW_GET_DATA_SIMPLE when trying to create an extract datasource.

Created a Z version of above FM and modified the table parts.

Created a structure to be used by the FM (specifying it in RSO2 and creating in SE11).

When testing extraction, I get an error - The extraction program does not support object ZSTRUCTURE.

Wondering if anyone has any specific tips on the format of the structure or knows exactly what the above message is referring to.

I am also getting the same problems when using standard one and the SFLIGHT table.

Can anyone offer some advice?

Thanks in advance.

[Former Member · Accepted solution]

Hi Stephen,

welcome to the BW forum.

Your issue is not that easy to locate. If possible, please post your fm here.

regards

Siggi

[Former Member · Accepted solution]

I won't post the source code for RSAX_BIW_GET_DATA_SIMPLE as it is SAP standard and can be seem from SAP and it will make my post unreadable.

I guess all I need to understand is what does this error message relate to and whether I am using the right extract structure.

I have tried both using the standard FM and modifying it for the structure I require. Both don't seem to work and suffer the same error.

The extract structure I have specified when using the standard is ZSFLIGHT. This is based upon table SFLIGHT. I suspect the problems lies here somewhere, but finding documentation is proving very difficult.

As a sanity check, I need to understand what format the extract structure should take and is whether what I have done is correct or incorrect.

Thanks again.

[Former Member · Accepted solution]

Hi Stephen,

please check out this thread.

regards

Siggi

[Former Member · Accepted solution]

Siggi,

Thanks for the link.

Read this, but still don't understand why I am getting this error message - 'The extraction program does not support object ZTEST (Extract Name)'

Lets take using the sample and unmodded FM RSAX_BIW_GET_DATA_SIMPLE.

I was just trying to get this extract working (using ZSFLIGHT structure based on tab SFLIGHT) before customizing my own version just to prove it works, but even this does not work.

Do you have any ideas what my be causing this and have you ever had this problem?

Thanks again,

Steve

[Former Member · Accepted solution]

Stephen,

so now we will go step by step.

1. Check your fm with transaction se37. Call it twice. 1st with the init flag set to 'X' and 2nd without init flag. Just provide a default request no. In the second step the table e_t_data has to be filled.

2. If 1. was successful check your datasource again. The setting has to be extraction via fm and you have to enter the name of your fm as well as the name of the structure of your data (this is the structure of e_t_data). Generate the ds again and run it in rsa3. Let us know the result.

Btw: what is zstructure?

Siggi

Message was edited by: Siegfried Szameitat

[Former Member · Accepted solution]

Siggi, I'm new this this and appreciate your assistance.

Ran FM 1st time with i_initflag set to 'X' and I_REQUNR

= '1'. Exception 'ERROR_PASSED_TO_MESS_HANDLER' raised.

Ran FM 2nd time with i_initflag set to space and I_REQUNR

= '1'. Data is retrieved into structure E_T_SOURCE_STRUCTURE_NAME but nothing in E_T_DATA.

E_T_DATA has no DDIC entries. Am I right in assuming the structure I provide in RSO2 (currently ZSFLIGHT based on tab SFLIGHT) when specifying the FM name will become E_T_DATA in FM?

ZSTRUCTURE was the name of my other datasource to use when I had got the standard FM working. Unfortunately, I haven't got this far yet.

Thanks.

[Former Member · Accepted solution]

Hi Stephen,

ok, I think we come closer to the issue. First: Check the source code of your fm. Specially look for RAISE ERROR_PASSED_TO_MESS_HANDLER. This normally occurs if the name of the DS is incorrect. Second: The name of the return table has to be e_t_data but the structure should be like your defined structure e.g. zsflight. So just replace sflight with zsflight in the tables definition.

""Lokale Schnittstelle:

*" IMPORTING

*" VALUE(I_REQUNR) TYPE SRSC_S_IF_SIMPLE-REQUNR

*" VALUE(I_DSOURCE) TYPE SRSC_S_IF_SIMPLE-DSOURCE

*" OPTIONAL

*" VALUE(I_MAXSIZE) TYPE SRSC_S_IF_SIMPLE-MAXSIZE

*" OPTIONAL

*" VALUE(I_INITFLAG) TYPE SRSC_S_IF_SIMPLE-INITFLAG

*" OPTIONAL

*" VALUE(I_READ_ONLY) TYPE SRSC_S_IF_SIMPLE-READONLY

*" OPTIONAL

*" TABLES

*" I_T_SELECT TYPE SRSC_S_IF_SIMPLE-T_SELECT OPTIONAL

*" I_T_FIELDS TYPE SRSC_S_IF_SIMPLE-T_FIELDS OPTIONAL

*" E_T_DATA STRUCTURE <your struc name> OPTIONAL

*" EXCEPTIONS

*" NO_MORE_DATA

*" ERROR_PASSED_TO_MESS_HANDLER

Let me know the results then.

regards

Siggi

[Former Member · Accepted solution]

Siggi,

Created a copy of RSAX_BIW_GET_DATA_SIMPLE, modded the code to include structure as below...

function zrsax_biw_get_data_simplesfli.

*"----

---

""Local interface:

*" IMPORTING

*" VALUE(I_REQUNR) TYPE SRSC_S_IF_SIMPLE-REQUNR

*" VALUE(I_DSOURCE) TYPE SRSC_S_IF_SIMPLE-DSOURCE

*" OPTIONAL

*" VALUE(I_MAXSIZE) TYPE SRSC_S_IF_SIMPLE-MAXSIZE

*" OPTIONAL

*" VALUE(I_INITFLAG) TYPE SRSC_S_IF_SIMPLE-INITFLAG

*" OPTIONAL

*" VALUE(I_READ_ONLY) TYPE SRSC_S_IF_SIMPLE-READONLY

*" OPTIONAL

*" TABLES

*" I_T_SELECT TYPE SRSC_S_IF_SIMPLE-T_SELECT OPTIONAL

*" I_T_FIELDS TYPE SRSC_S_IF_SIMPLE-T_FIELDS OPTIONAL

*" E_T_DATA STRUCTURE ZSFLIGHT OPTIONAL

*" EXCEPTIONS

*" NO_MORE_DATA

*" ERROR_PASSED_TO_MESS_HANDLER

E_T_DATA has entires in when running in SE37 test tool. RSO2 test extraction still derives the same error message though :(.

Thanks.

Message was edited by: Stephen Dunne

[Former Member · Accepted solution]

Stephen,

well, it looks like we made some progress. Now please let me know how you setup the datasource and the name of it. It must be the same as in the coding at

CASE I_DSOURCE.

WHEN '<your datasoure name>'.

WHEN OTHERS.

I think we will get it to work soon.

Siggi

PS: please assign some points to all guys helping you. It is the way to say thanks in SDN.

Message was edited by: Siegfried Szameitat

[Former Member · Accepted solution]

Siggi,

Looks like it has worked, changed the source code in FM under CASE I_DSOURCE ammending the datasource statement to match 'ZTEST' and records are now present in the test extraction. Also modded my other extract to obtain data from table CDPOS and this also works too.

A result, I think I would say.

A big Thank You for your patience tutoring me through this.

[Former Member · Accepted solution]

This helped me as well! thanx a lot!!

I'd like to assign some points, but unfortunatelly could not find out how to do so

Update: Uups, it seems only the Post Creator is able to give any points thanks anyway!

Edited by: Artem Sukhanov on Oct 4, 2010 10:20 AM

Edited by: Artem Sukhanov on Oct 4, 2010 10:25 AM

[BERCIWO · Accepted solution]

Very helful thank you - always make sure in function CASE i_dsource WHEN ' name of datasource' you don't put structure name 🙂

[Former Member]

Hi,

Could any say me which function module suports or i have to write a logic for my problem,

Problem:

I got data in R/3 table ,this table contains Parent Child Relationship and i want to load this Relatinal data in an info cube with all its Basic node,Child nodes,Postable node,Non postable nodes .

Waiting for early responce.

Regards,

Azee.