Regarding Creation of Views and Multiple Datasources.

[Former Member]

Dear All,

I hv a COreport(Cost Center Report).the data is coming from tables of CO,FI,SD,MM.

The Tables from CO are COEP,COSP,COSS,CSKS,CRHD,CSKU,CRCO,CSKB

The tables from SD are VBRK,KNA1

The Tables from MM are EKKO,LFA1.

The table from FI are SKAT,BKPF,BSIK,BSAK.

1)Can i create a view for these tables?Can a view be called a DS.

2)With these tables i hv Multiple DS's.So can i use Multiple DS's to extract data

3)Can i use FM to extract Data?If i use FM,vll i face errors during Support?

4)Please Guide me how to create Views for these tables and How to handle Multiple Datasources.

Thanks

[Former Member]

Noor,

Have you checked suitable business content datasources.

I think you have lot of options

FIrst You need to have a multiple data source

--> Check for suitable business content datasources

--> check whether these details are already available in BW through any means (through other standard datasources to ODS)

--> Create customized extractor finally as a last option

All these tables are atandard and nost probably you would find a standard datasource ( again multiple) I am sure for costing you have standard

Few or more standard datasources or already existing BW objexts with 1 or 2(rarely) customized extractor would do the purpose that you look for,....

Good Luck !!!

Regards

VJ

[Former Member]

HI VJ,

Yes i hv checked using RSA5,der r lots of DS for each f dese modules.

So can i use Multiple DS to extract Data into BW?Because i vll be using around 4DS's for these reports.Moreover,i have one Currency field WKG001,which is in COSP table.This field s nt der in any f the DS's of Controlling,So i am nt sure of using Multiple DS's.

Since im new to implementation,and u said abt Customised Extractor,Can u tell me what this is and hw to do it,Are u talking abt RSO2?

[Former Member]

Hi,

If u have a common field in all the tables u have described then u can create a view.

Using view u can create datasource in RSO2.

U can replicate the datasource and use that in cube r ods.

or

U can even use multiple datasource for one traget(ODS r CUBE)

regards,

md zubair sha