Purchasing Report help
I need to create a report from EKKO,EKPO,KOMV,MSEG & LIFNR table....I found the related data sources as 2LIS_02_ITM, 2LIS_11_VAKON /2LIS_13_VDKON, 2LIS_03_BF & 0VENDOR_ATTR. Now my doubt is what are the key fields I should take to consolidate the data from above data sources in to a ODS / Cube /Multi Prov....
Is this a good idea to use all above data sources? Or Can I just create a view on top of these tables and create a Data source so that I dont need to create multiple ODS/data sources....Please advice