Skip to Content
author's profile photo Former Member
Former Member

Generic Extraction

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2008 at 05:30 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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,

  • Posted on Jan 17, 2008 at 05:32 AM

    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

    Customer and Generic extraction difference ?

    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-b062adbb3e33

    generic-extractor---delta

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.