Finding "Master Data"- DataSource

[Former Member]

Hi,

I am looking into my Cube a see a lot of InfoObjects.

Now how can I find out where each InfoObject gets his master data from, so I am looking

for the data source in ERP.

I have tried metadata repository in rsa1, but shows me only a list where this info object is used, but not

where this info object gets his master data from !?

[former_member188080 · Accepted solution]

Hi,

Check following threads

Also check datasources in RSA5,RSA6 etc for master data.

Thanks and regards

Kiran

[Former Member]

HI,

Generally we use the following tables to see,

RSISOSMAP Mapping Between InfoSources and DataSources (=OLTP Sources)

RSOSFIELDMAP Mapping Between DataSource Fields and InfoObjects

RSOSFIELDMAP: in this table don't give selection for Object Verion as A if you also want to see the mapping between inactive info objects and R/3 fields, you just give fields and execute and check. eventhough you won't get then in Business Content you can open the InfoObjects and search as per ECC Fields Descriptions and then install.

Navesh

[Former Member]

Hi,

You can use the table RSOSFIELDMAP to map objects.

Go SE11 and give RSOSFIELDMAP then click on dislay, and press Ctrl + Shift + F10 then it will diplay screen give Feild name it will display all details about that feild.

Give 0BPROLE in InfoObject and press F8, it will give following information

0BP_ROLES_ATTR ROLE 0BPROLE

Regards,

Fully_tilt

[Former Member]

Hi

Using the table RSOSFIELDMAP, find the fields from which your info objects can feed. using the fields find the suitable data source in R3 system.

Regards,

Venkatesh