on 06-21-2007 8:39 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.