Question Re: Generic DS in Technology Q&A

Generic DS

Former Member — Wed, 24 May 2006 05:11:13 GMT

HI All,

I need to create a new cube, FI/ CO related.

1. I need to create Generic Extractor via view But we can’t create a view using Cluster tables.

2. We have to write an Abap Query or Function module and defined in RSO2. How to do this? and

How to create Extract structure & Data source in that case?

Can anyone give an idea? documentation on this?

Thanks in Advance.

Sri

Re: Generic DS

edwin_harpino — Wed, 24 May 2006 05:19:32 GMT

hi Sri,

you can create structure/view/table with SE11.

then create function module with SE37.

use 'RSAX_BIW_GET_DATA_SIMPLE' as sample,

take a look Siggi's weblog

/people/siegfried.szameitat/blog/2005/09/29/generic-extraction-via-function-module

and attach the extract structure to datasource with RSO2.

hope this helps.

Re: Generic DS

Former Member — Wed, 24 May 2006 05:23:33 GMT

Hi sri,

To extract Data from Cluster Table U need to create A Data source using FM in RSO2.

U can create Extract structure from SE11

U can see the blog Generic Extraction via Function Module

/people/siegfried.szameitat/blog/2005/09/29/generic-extraction-via-function-module

and this is a sample FM 'RSAX_BIW_GET_DATA_SIMPLE'

Regards

Ajay

Re: Generic DS

Former Member — Wed, 24 May 2006 06:14:51 GMT

Hi A.H.P/Ajay,

Thanks to you both.

For example: If I get another similar (Generic-FM-RSO2) Development, We can use same function rsax_biw_get_data_simple and apply code for that development?

Please provide some sample code, to get an idea.

Thanks & Regards,

Sri

Re: Generic DS

Former Member — Wed, 24 May 2006 06:31:41 GMT

Hi Sri,

U can not use the function module rsax_biw_get_data_simple for the generic data source created by you .

instead u can use copy it to ur own custom defined FM and change the Code accordingly

as an example see my code but U have to define the extract structure in se11 also when creating FM U have to include few type pools in ur top include in ur function group that for used in ur FM importing and exporting parameter list.

and U have to specify the FM name and extract structure name when U have created the data source

If U need some sample code mail me ur mail id I will send U

hope this helps U

Regards

Ajay

Re: Generic DS

Former Member — Wed, 24 May 2006 08:58:55 GMT

Hi Ajay,

Thanks to you for your help.

So, goto SE37 --> ZFM --> paste code of RSAX_BIW_GET_DATA_SIMPLE in ZFM.

My Mail id is: lk.narayana@tcs.com

Thanks,

Sri

Re: Generic DS

Former Member — Thu, 25 May 2006 05:03:00 GMT

Hi Sri,

Please refer the previous posts also . Iam attaching a link

That will be useful

Regards

Ajay

Re: Generic DS

Former Member — Thu, 25 May 2006 05:08:46 GMT

Hi sri,

One More thing I for got to tell U if U need to get the delta data for Ur generic data source plse use this function module as templete 'RSVD_BW_GET_DELTA_DATA'

Regards

Ajay