Generic Extraction

[Former Member]

Hi everyone,

Please can anyone provide me woth details on generic extraction extraction.

what i require is when do we use it, why to use it, how delta is performed in generic extraction, various options avialable......

thank you,

sam

[Former Member · Accepted solution]

hey guys your reply have helped me a lot.

as san said real time examples would be

1. Master Record creation like customer ID creation

2. Timesheets in SAP PS

3. Invoive details / Sales Order Details.

can you please provide me with a small case study on same or a more brief descriprion on any generic extraction and how delta was used in it.

thanks

sam

[Former Member · Accepted solution]

Hey Sam,

One generic delta extractor we have built here is the Measurement Documents in PM. We do not have any delivered content that would not fulfil our needs. So, we built a custom transactional data source. We can not have document number as the delta field (Numeric Pointer)as the changes to the document would not be reflected. So, we made the time stamp in the standard table as the delta field. Whenever the document is changed, the time stamp also gets changed and this is picked up by the delta. This is working fine. One thing you need to consider while choosing the delta field is that, can the changes be recognised by the system based on that field you have chosen.

You know the steps to create the data source. Don't you? Let us know if you have any further doubts. Hope this helps.

Thanks and Regards

Subray Hegde

[Former Member]

Hi Sam,

chk these links

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

To learn more about Generic Extraction pls read BW350 book. Gereric Extraction can be done in 3 ways.

If you go to transaction RSO2 in R/3 side, provide tech name for data source and click create.

you will get the 3 options.

1)From a DB Table

2)From a DB View

3)From Functional module/ Infoset Query

in first option you can directly give a standard or custom build talbe name. in second option you can select the necessary fields from more than one talbe(eiter standard or custom). In third option you will create a function module or Query to extract data. When creating function modules you can use standard function modules as a template e.g. RSAX_BIW_GET_DATA_SIMPLE.

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

If you want to enable delta for generic extractor you choose the option delta and provide necessary settings.

Generic extraction is when your extraction is not satisfied by either BC or LIS/LO. It can be using a view / query/table/FM

Here the changed records can be isentified by :

1. Based on the date of creation or last change ( Delta based on 0Calday)

2. Based on the record number ( Numeric Pointer )

3. Based on time of change ( Timestamp)

real time examples would be

1. Master Record creation like customer ID creation

2. Timesheets in SAP PS

3. Invoive details / Sales Order Details.

[Former Member]

Hi Sam,

We use generic extraction when the standard extractors provided by SAP does not fulfil our needs.

You can create a generic extractor based on a table/view, infoset or function module. The choice you make between these depends upon your requirement and feasibilities.

Steps to create a generic extractor (using a view):

1. Create a view in transaction SE11.

2. Create a generic datasource using transaction RSO2. You can enable delta here based on the field that is available for delta.

3. Edit the data source in RSA6 to make necessary changes.

4. Replicate in BW and it is available for you to use.

Hope this helps. Feel free to ask any doubts you have.

Thanks and Regards

Subray Hegde