2012 Jul 06 10:51 AM
Hi,
Any idea, how can I get all the BW reports available in ISU?
Thanks,
Twinkle
2012 Jul 06 11:05 AM
Hello Twinkle,
Check, the t-code SISU
Navigate via- SAP Menu --> Information System --> Report Selection --> you will get bloew nodes.
Check which one is reuired for you.
Scheduling
Master Data
Device Management
Validation
Meter Reading
Billing
Billing Master Data
Billing Execution
Invoicing
Contract Account Receivable
Account
Payments
Documents
Security Deposits
Installment Plan
Reconcillation
Closing Preparation
Data for Extrnals
Payment Card Organizations
Customer Service
Work Management
Hope this answers your query.
Regards
Sachin
2012 Jul 06 11:11 AM
Hi,
Thanks for the reply.
In the below path I get the access to these reports, I needed a consolidated list of BW reports in ISU like report name, report id, so that they can be tracked back in BW system also for further details.
Any idea, if there is any ISU table or repository which holds these reports name?
Best Regards,
Twinkle
2012 Jul 06 11:16 AM
2012 Jul 06 11:19 AM
Hi Twinkle,
I could not understand your requirement fully.
There are BW extractors in ISU which transfer the data from ISU to BW, which gets stored in the info cube level (normally) in the BW side, from where it is retrieved to generate custom reports.
The standard extractors in finance space are-
(a) FPCIBW (For Cleared Items)
(b) FPBW (For open Items)
Also there are mass trasnctions which update the data in the delta queue, like EBW_DQ_SS or FPOP etc.
Once the data goes into the BW space, you can generate custom reports out of them.
Hope it helps in answering your query.
Thanks,
Amlan
2012 Jul 07 6:22 AM
Dear Amlan
Currently I am trying to fetch the data in 0FC_INVDOC_00 in RSA 3 but zero records are getting extracted. In my system 2710 event I can see and is in active mode.
Is there any more setting required to activate the same function 2710?
Is there any steps are in ISU to extract 0FC_INVDOC_00 datasource data? I have gone thru posts and found there is some settings in SPRO in the Implementation Guide for Contract Accounts Receivable and Payable under Integration --> Invoicing in Contract Accounts Receivable and Payable ---> Invoicing Processes ---> Define Invoicing Processes.
http://fmis.minfin.bg/help/EN/43/20db420d472be9e10000000a1553f7/frameset.htm
In my ECC 6.0 in spro I didnt find Define Invoicing Processes under integration...
What could be the resone.?
Appreciate your help on invoicing.
2012 Jul 09 5:31 AM
Hi Amlan,
Thanks for your reply.
There is a requirement to exctract all the SAP ISU standard BW reports' names available in ISU. There was a similar requirement in CRM also. In CRM there is one table 'CRMC_BI_REPORTS' which contains the name of the available BW reports in CRM. For example, It contains the Report ID: 0CP_SLSCA_Q0017(example), Report Type: QU and Report Key: 0CP_SLSCA_Q0017. So that BW team can track down these reports in BW system. Although I am not sure how BW works with these reports.
So, I was wondering whether there is any way in ISU to extract the names of the BW reports available in SAP ISU.
Hope I could clarify my query.
Thanks,
Twinkle
2013 Aug 08 1:19 AM
Hi Amian,
Im new to ISU Space, I got couple of questions
1.Is the extraction of Data Sources from ISU to SAP BW process is same as ECC?
2. What do you mean by Data Getting stored at Cube level? The Data Flow would be same as we have in Finance
like: Activate the Data Source [in ECC] and Replicate it in SAP BW. In SAP BW the flow would be----PSA-DSO-Info Cube?
regards
Raj