cancel
Showing results for 
Search instead for 
Did you mean: 

How to find right datasource in ECC for master data extraction

Former Member
0 Kudos

Friends,

I need to extract master data from r3 for the objects 0KAPPL, 0COUNTRY, 0SALESFORCE. How to find which datasources in r3 I find data for them.i could not find in Controlling. If it is 0customer we can easily understand to find in LO, but in cases where it is difficult to find the right datasource, what is the criteria to search.

Accepted Solutions (1)

Accepted Solutions (1)

mr_v
Active Contributor
0 Kudos

0COUNTRY_TEXT --Table -- T005T

0COUNTRY_ID_TEXT --Table -- T005T

Former Member
0 Kudos

Mr. V,

Please explain in details how to map 0country to table T005T and how to find tables for each object?

mr_v
Active Contributor
0 Kudos

0COUNTRY_TEXT is standard datasource based on table -- T005T.

In ECC system (RSA5) activate datasource and replicated that to BI.

In BI create transformation between 0COUNTRY (infoobject)0COUNTRY_TEXT and create DTP.

create infopackage for 0COUNTRY_TEXT to load data.

Former Member
0 Kudos

Thanks very much. I still want to know if there is a way to figure out the matching datasource for any given object. how to find the appropriate table for any infobject.

Former Member
0 Kudos

I guess you'll need to apply for a job in Walldorf then

There is still not an "easy" way to find a DataSource for whatever object you have in your source system. You can search in various ways:

- source system: transaction RSA5

- source system: table ROOSOURCE

- BI system: metadata repository

- internet: http://help.sap.com or http://sdn.sap.com

- a lot of common sense (and a bit knowledge of German might help too... for ECC most of the table field names are abbreviations in German).

This to say there's not a real answer to your question...

Answers (2)

Answers (2)

former_member205352
Active Contributor
0 Kudos

Hey give you target names in help.sap.com.

This is an easy method.

Hope this helps.

Former Member
0 Kudos

Praveen,

can you send the link please.

Former Member
0 Kudos

did you try looking in the metadata repository?

Former Member
0 Kudos

RafB,

i found it, in metadata repository, under an infosource(used by). But that is a transaction data datasource 2lis_11_vakon. can I map it?