Generic Extraction-example

[Former Member]

hello EXPERTS

I am trying to give one presentation about 'Generic Extraction using View'...I know how to explain the process.But as I donot have project experience,I have never worked with Generic Extraction.

Can any one give an example where they used generic extraction(by view) on SAP standard tables.Its enough if you can mention the fields you used and from which tables you took these fields?

Thanks

S

[Former Member · Accepted solution]

Hi

I have done generic extraction using view for partner functions for sales, table is VBPA(Partner funtion) in which we created a view to link table VBAK( Sales order header) based on document number (vbeln) to get sales organisation and company code.

Is this information is enough or you want more ?

Regards

YuvaraajP

Edited by: YuvaraajP on Nov 3, 2009 12:42 PM

[Former Member · Accepted solution]

Think of generic exractor as something a developer creates depending on the demand of the report. Sap provides extractor but sometimes they dont answer or provide the right fields for reporting.

when creating generic extractor we can use Views from Se11, function modules se38. our generic extracotrs could be master data or transaction data, can be made delta or full through RSO2. once extractor is created as in data source, you replicate it in BW, then do your regular development there.

hope that helps.

you can use the define example of VBAK tables or cocp tables or just join 2 tables in a view and bring in some fields in yoru view , create a data source and volla there is your generic extractor, make sure you have a developers key....

[Former Member]

thanks Yuvraaj.its enough.

[Former Member]

Hi,

Processing steps for creating the Generic Datasource by useing View:

1.Goto RSo2.

Datasource can be created for

a). Transaction Data

b). Master data Attributes

c). Master data Text

2.Specify Application component(SD/MM..)

3.There are three extraction methods to fill datasource.

i).Transparent table or Database view

ii).InfoSets of the SAP query

iii).Using a Function Module

4.Select extraction method extracts the data from a transparent table or database view.

5.select Extraction from View, then we have to create the View.

a).specify the view name.

b).choose the view type (Database view) from bellow mentioned views.

Database view.

projection view.

maintainance view.

help view.

6. Specify Tables and Join Conditions and define view fields.

7. Assign View to Datasource

8. Once you specify view in Data source, the extract structure willgenerate.

9. then select the filds in selection column.

10. Specify Delta-Specific Field and type.

11. Specify Safety Interval and Delta Type and select Save button.

12. Testing the Generic extraction.

Select Datasource option from menu bar-->select Test Extraction or you can check in RSA3.

Regards,

Suman.