cancel
Showing results for 
Search instead for 
Did you mean: 

Extracting data from R/3 Ztables to SAP BW

Former Member
0 Kudos

Hi,

Thanks for your replies Ajay and Srinivas.

But my question is how to extract data from R/3 Ztables to sap bw.

To extract from standard tables we have predefined programs and functions,

but to extract from ZTABLES what is the procedure.

Let me know

Thaks in advance,

Kishore

Accepted Solutions (1)

Accepted Solutions (1)

former_member186445
Active Contributor
0 Kudos

in rso2 create a generic extractor. put your table in the field "table/view". when you save you can choose the fields that you want for selection. afterwards your new datasource will be available in rsa6 and when you replicate in bw you will see it there too

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Kishore,

Create generic datasource ( RSO2) and choose method extraction via table.

Select input field/delta field as per requirement .

Save datasource.

Replicate datasource to BW.

Create info object if required to map to ztable fields

Create infosource

Assign datasource to infosource

Create transfer rules

CReate ODS/ Cube

Create update rule

Create info package.

Schedule data (after activating all objects).

Hope that helps.

Regards

Mr Kapadia

Assigning points is the way to say thanks in SDN.

Former Member
0 Kudos

Hello,

You can also test your datasource using transaction RSA3 in R/3 side.