Question Re: Data source and table mapping in Additional Q&A

Data source and table mapping

former_member554246 — Thu, 07 Nov 2013 13:30:49 GMT

Hi Experts,

I want to map all the data sources created in my system with the tables attached to it.

So can i know the table name from which i can get the above data?

For Example :

Data source1 have tables table1 and table2

Data source 2 have tables table3 and so on..

Thanks in advance.

Regards,

Vinay

Re: Data source and table mapping

Former Member — Mon, 11 Nov 2013 21:12:10 GMT

Dear Vinay,

As this is a particular detail of each Data Source you create, the only standard option available is "Data Source Business Rule Assignment". In order to map the data sources with tables, you will need to create a custom report for this matter.

Thank you,

Fernando

Re: Data source and table mapping

Former Member — Wed, 13 Nov 2013 21:46:41 GMT

Fernando is correct, you'll have to write a custom report. The challenge is, since data sources are HR Infotypes, it is not very easy to figure out which tables hold that information!

You message says you're on PC 10.0, but in PC 10.1 there is an alternative. There is a utility in SPRO for exporting/importing CCM content to local XML files. These XML files contain the entire definition of data sources, from which it might be easier to extract what you need (at least, as compared to the effort of writing a custom report on HR Infotypes).

Re: Data source and table mapping

sharad_parasher — Thu, 14 Nov 2013 05:50:58 GMT

Agree with Atul that using the export feature of 10.1 is a good way to extract this information. However if upgrade is not an option , this information can be fetched from infotype 5342. ( Database table HRP5342).

Field source table has the table name .You need to know the object ID of the data sources though, which you can extract from HRP1000 based on object type corresponding to a datasource.

Re: Data source and table mapping

former_member554246 — Tue, 19 Nov 2013 15:25:04 GMT

Thanks Sharad..

Re: Data source and table mapping

former_member554246 — Tue, 19 Nov 2013 15:25:40 GMT

Thanks Atul...

Re: Data source and table mapping

former_member554246 — Tue, 19 Nov 2013 15:26:22 GMT

Thanks Fernando..

Re: Data source and table mapping

Former Member — Thu, 15 May 2014 13:52:17 GMT

Hi Sharad,

Can you please tell me the info type for PC Business rules so that it would be easy to download the details.

Many thanks.

Regards,

Amit