cancel
Showing results for 
Search instead for 
Did you mean: 

Create Info objects after extracting ds from ecc

Former Member
0 Kudos

Hi All,

I have replicated ds from ecc to bi and executed the infopackage. Now the data is upto psa level. How to create info objects after loading data to psa level to load the info objects to data targets like infocubes and dso. I have done to sucessfully to a flat file.

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

RamanKorrapati
Active Contributor
0 Kudos

Hi,

Based on your data source fields, try to find related bw info objects.

Use them into your targets. if there is no standard one then create same info object type and length of ecc field.

Try to check table RSOSFIELDMAP, try to see EC fields and related bw objects.

Might be helpful.

Thanks

Former Member
0 Kudos

Hi Phani,

Im using OFI_GL_14. Its a FI data source. It has the fields like ANLN1(asset), AUFNR (order no), BELNR (document no) etc...

After successful replication and infopackage at psa level and when i navigate to

bicontent tab -> Info object types - > infoobject -> select obejcts a pop appears with objects. After searching for anln1 its shows /RWC/CANLN1    main asset number.

Now after selecting it should i transfer it and install it?

How to check in rsodfieldmap?

RamanKorrapati
Active Contributor
0 Kudos

open table RSOSFIELDMAP,

Try to see the display data.

in field name  - enter ANLN1 and hit display .

it will shows bw objects in info objects column.

Even you can enter OLTP source as data source name and see ecc fields and bw objects in different columns.

if you see table you will find what you need. later you can install them from bi content.

Field      bw info obejcts

ANLN1 - 0ASSET_MAIN

AUFNR - 0CCORDER

Former Member
0 Kudos

Hi Raman

I went tcode se11, i have the options database table, view, data type etc. How see rsosfieldmap.

RamanKorrapati
Active Contributor
0 Kudos

Hi,

Go to SE11 in bw server.

Select table radio button and enter RSOSFIELDMAP.

Later click on contents icon on tool bar and see.

if you don't no then ask ABAP consultant help and do it.

Thanks

Former Member
0 Kudos

Hi raman,

done the same ,

Databasetable -> rsosfield map in the text box -> display -> contents -> oltpsource filed given OFI_GL_14 and fieldnm ANLN1 -> execute

It gives message no table entries found for specific key.

RamanKorrapati
Active Contributor
0 Kudos

with abaper help, do it again.

Even i shared bw info objects in above reply. please install them.

Answers (3)

Answers (3)

sander_vanwilligen
Active Contributor
0 Kudos

Hi Sudhir,

It will depend on your system and DataSource where the DataSource field assignments to InfoObjects can be found. It is dependent on the data staging technology used. Nowadays Business Content is often migrated to 7.x and you can find the assignments in other tables.

3.x DataSource:

T/code SE16

Table RSOSFIELDMAP

7.x DataSource:

T/code SE16

Table RSTRAN and RSTRANFIELD

In table RSTRAN you must select the field TRANID based on OBJVERS = 'D', SOURCETYPE = 'RSDS' and SOURCENAME = 'OFI_GL_14*' (note the wildcard * at the end).

You can find the assignments in table RSTRANFIELD using the TRANID. There are groups of DataSource field and InfoObject based on RULEID.

Best regards,

Sander

former_member976
Active Contributor
0 Kudos

Hi,

if your loading the data form ECC to BW is yes,

after replicating the data source check the data source fileds tab- check the object length and type.

ex-  ECC field- MATNR - BW info object 0MATERIAL

no need to create the info object use the standard busines object - it is better option.

if business content object not avaliable create the custome info objects.

as raman said use the table RSOSFIELDMAP for standard objects.

-Phani.

Former Member
0 Kudos

Hi Sudir,

After replication the datasource from source system to Bw system

1)Check whether the info objects are available in BI content(RSORBCT) if it is there then you install in Bi content else Create your own

Check the source field name with Bw field name in RSOSFIELDMAP transaction code.

sander_vanwilligen
Active Contributor
0 Kudos

Hi Sudhir,

You can go into 2 directions: use as much as possible Business Content InfoObjects or use custom InfoObjects. A combination is also possible.

Especially in conjunction with SAP ECC extractions the Business Content InfoObjects are a safe choice. However, please consider the advantages it can have to use custom InfoObjects.

If you would like to go into the direction of custom InfoObjects, then I suggest reading the following blogs:

  • ;
  • .

Best regards,

Sander