SAP BW Generic Source enhancement in ECC

[Former Member]

Hi Experts,

We have requirement for new reports where currently using ECC ABAP report. They all customized reports...They normally run the reports in ECC and then export into Excel and then merge these reports with their Budget, forecast etc..

Now they have requirement where they want to build these reports into BW so they have centralized data base and build reports what they doing manually...

As they are running report in ECC (Z transaction) ABAP reports built...

Can I use ABAP progamme directly to build Generic data source like using Function module ( do i need to create function module for these programms) or do I need to create View again for all the tables which are used in this programme again..

Thanks.

[RamanKorrapati]

Hi,

if you have table at source side then you can go with generic data source based on table/view.

If have more tables then go with function module based generic data source.

About generic data source steps you can get from google search.

Thanks

[KodandaPani_KV]

Hi,

do you need to create the FM based on the program/source table.

after create the data source based on the FM

if you create the view you will get performance issue better create the FM.

check the data in the RSA3 and replicate to BW system.

-Phani.