SAP-CATS and BW

[Former Member]

Hello everyone,

I'm new with BI (BW/BO), so I hope to get some experienced help with starting my little project.

We, i.e. our company, wants to run CATS-reports from SAP ERP. Consequently I have to migrate all the data/tables from CATS into BW. Eventually I shall create reports with BW-or BO-tools (at the moment this is not as important as geeting the data into BW). Additionally, we have 10-year-data from a LotusNotes-software called "ProStunde" (german), which has to be migrated into BW, too.

My first question is: How can I migrate the CATS-data into BW? I believe it is more logical to think of the CATS-migration and BW-architecture at frist place, before loeading the LotusNotes-data via CSV-file into BW, right? CATS includes the modules HR, CO, PM/CS, PS and MM (including all interface-tables).

In this case, I am talking about integrating CATS in BW. Or is it better to firstly analyze the existing reports from our company (Excel) in order to know what is BW-relevant?

I know this may sound a little bit unstructured, but for now I can't say any more, sorry...

Thank you for your help!

Best,

Patrick

[mr_v · Accepted solution]

SAP has provided standard content to migrate SAP ERP CATS data. Below datasource pulls ERP data from CATSDB table. 0CA_TS_IS_1 - Timesheet Data (Approved) 0CA_TS_IS_2 - Timesheet Data (Released for approval) href="http://help.sap.com/saphelp_tm80/helpdata/en/c7/565f3ce4dd3370e10000000a114084/frameset.htm">http://help.sap.com/saphelp_tm80/helpdata/en/c7/565f3ce4dd3370e10000000a114084/frameset.htm

[Former Member · Accepted solution]

Hey,

thank you for your answer!

I am on a business-trip right now, thus unable to take a closer look at your suggestion... Sorry.

I would have to get back to you as soon as I had time to try to use the above datasource to migrate CATS-tables.

Is that okay with you?

Thanks again and bye for now

[Former Member · Accepted solution]

Hey, one quick question:

I simply tried to find the mentiones datasources, but in my BW (it is empty, since completely new) I can not find them.

You say that "SAP has provided standard content" - you referr to BI-Content?

I already activated BI-Conent...

THX!

[Former Member · Accepted solution]

Hi Patrick, Kindly refer the Personal Administration PA-OM, PA-PA InfoAreas. You can find good amount of BI content data stores like 0HR_PAO which all stores HCM-PA based data which you can model them as per your requirement. Thanks, Arun Bala

[Former Member · Accepted solution]

Thank you Arun,

right now I am facing an essential problem, which stands before generating any DataSources at all - namely to create SAP as source system. If i right-click in RSA1 in the view Source System on SAP and thus create, I get failure R3072.

I think that - before generating a generic DataSource in the SAP ERP and replicating it to BW or using standard-DataSources - I must set SAP as source system...

Can't believe that this is so difficult!

Thanks for help!

[mr_v · Accepted solution]

In source system (ECC/R3), use tcode RSA5, u can find these busines content datasources in below path.

SAP --> SAP R/3 --> 0CA --> 0CA_TS

Regarding Source System creation, you should maintain certain parameters, pls contact Basis team to fix the issue.

[Former Member · Accepted solution]

I contacted my basis-team / administrator in order to solve above SourceSystem-problem.

So much: we are creating a new system-landscape with BW, ERP-SourceSystems (3) and BO.

Thus I am waiting till everything's finished in order to start working / activating BCT for CATS.

Does anyone have experience in reporting on CATS-data?

Consequently, does anyone have good examples in BW-Queries which her/she would like to show/explain (to) me - besides BCT?

First of all real simple reports with data for customer (customer-groups-/aggregates) / user (PN) / date / year / month / project / time / place / ...

Thank you folks - bye for now.

Patrick