How to creat Data source from Multiple Tables in SAP BI ?

[Former Member]

Hi Experts,

1. For Finance & Payments MIS tables are u2013 BSEG, BSIS,BSAS,PYAR ,BKPF

2. For Inventory tables are : MSEG MKPF.

3. For Invoices MIS tables are - RBKP & RSEG.

4. For Taxation MIS tables are u2013 J_1IEXCHDR, J_1IEXCDTL, J_1IPART2, J_1IPART1

5. For Master data tables are - : MARA, MAKT, LFA1, J_1IMTCHID

How to creat individual Datasource for 1.Finance & Payemnt Mis , 2. Inventory, 3. Invoices, 4. Taxation , 5. Mater data. ?

[Former Member]

Hi,

Go for the generic data sources.

1. first create the view on all the tables.

You can only use join conditions but not Union.

you can specify one table as primary table based on your requirement.

2. build the data source based on the view.

Regards,

Siva

Edited by: sivaramakrishna on Feb 2, 2012 3:54 PM