cancel
Showing results for 
Search instead for 
Did you mean: 

Generic Extraction from Database View.

Former Member
0 Kudos

Dear Friends,

I have to extract data from two tables using Generic extraction.

Please can you help me the following issues.

1: There two tables Tab1 and Tab2. How can I link them in view and based on what Keys.. there many same fields existing in both.

2: In Tab2 there are some fields which does not exist in Tab1 , how can I do that in view.

3: I have almost 4000 records from the tables may be We have to pull every week in to BW. As records are very less is it possible to do Full Update every time or still we required Delta in Generic...

4: Please can you also let me know the steps to do Full Update if so.

Thanks,

Sudha...

Accepted Solutions (0)

Answers (2)

Answers (2)

RenjithKumar
Advisor
Advisor
0 Kudos

Hi ,

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/84bf4d68-0601-0010-13b5-b062adbb3e33">Here</a> is the step by step doc you asked

Best Regards

Renjith Kumar

(Assign Points If useful )

RenjithKumar
Advisor
Advisor
0 Kudos

Hi ,

The two tables will have primary and foreign key relation you must take that sort of table only .

Eg :

VBAK : SD Header , Primary Key : VBELN

VBAP : SD Item , Foreign Key : VBELN

So view condition must be

VBAK-VBELN = VBAP-VBELN

After you create view , You create data source in SBIW. Creating Generic data extraction . There you give the name of view and the selection field and delta method.

Next in BW side replicate the data source and then create infocube and assign infopackage and schedule to get data .

Renjith Kumar