Generic Extraction

[Former Member]

Hi All, I would like to learn about Generic Extraction, Please send me if any of you have Step by Step process to fully understand the procedure, thanks all in advance.

Frankie

[former_member345199]

Hi,

Generic extraction

1. When the standard extractors are not supporting the extraction what you need.

2. If you create a custom object say by combining certain base tables in R3 say custom tables ZTAB1 and ZTAB2. These two tables are not SAP provided tables and there will not be any standard extractors. So cases like this you will have to go for generic extractors.

3. FI-SL requires generic extractors.

If SAP does not have a standard extractor for your need to get data from R3, you would have to go for generic extractor.

You have to use RSO2 transaction and you can also set delta based on, one of the three characteristics such as timestamp, calday or pointer (a sequence no).

once you create it and activate it. The extractor will be available in ROOSOURCE - (table in R3 where all the data sources are available).

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

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/d3219af2-0c01-0010-71ac-db

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/84bf4d68-0601-0010-13b5-b0

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/84bf4d68-0601-0010-13b5-b0

http://help.sap.com/saphelp_nw04/helpdata/en/3f/548c9ec754ee4d90188a4f108e0121/content.h

http://help.sap.com/saphelp_nw04/helpdata/en/3f/548c9ec754ee4d90188a4f108e0121/content.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/84bf4d68-0601-0010-13b5-b06...

Steps

Log on sap R/3.

Step 1; create a table or view for generic extraction in se11.

Step 2; then goto RSO2 t-code.

Step 3; Here u have to decide whether to extract transaction data or master data attributes or texts.

Step 4; suppose if u have opted for transaction data,then give name in the column ex:ztd_m(data source name)

Step 5; select create button,this will take u to another screen.

Step 6; Here u have to decide from which application component u r extacting data.Ex: SD,MM,..

Step 7; in this screen u have to fill short disciption,medium,long( these r mandatory).

Step 8; then U have to Table name or view name which u have created in se11.

Step 9; I f u want to maintain generic delta then u can select generic delta in top left hand side corner.

Step 10; in next screen u have to give some field which is primary key.

step 11; here u to specify whether time stamp or cal day or numeric pointer depending on u r requirement.

step 12; then u have to specify whether new status for changed records or additive delta.

If u choose additive delta ,then u have to load data to infocube or ods object.

If u choose new status for changed records, then u to load data to ods object only.

Step 13; then save it.

Step 14; then logon to sap bw ,then replicate the data source then as usuall.

Thanks,

JituK

[Former Member]

Hi,

First you should know waht is the data required and in which table or view the same can be obtained.

Oncce you know the table or view, you can go to Tcode RSO2 to create generic datasources, here you have options like the type of datasource, Transaction data ot Master data attribute, Text . Give a generic techinical name in the relevant type of datasource and click on create,

next give an application component node under wich the data souce should appear in the datasource hierarchy.

Next give the table or View name and then save the datasource.

Now you would have created a generic data source with full upload mode,

\You can also make the datsource as delata capable provided you have some relevant fields that can capture / track the delta.

assign points if tha above was useful.

Regards

Venkata Devaraj

[Former Member]

Thanks Venkata Devaraj, I will follow those instructions which have passed to me, but I am just wondering if I can get screen shots or anything to ease this work, as I don't like bw350 at all.

thanks,