on 03-06-2015 1:25 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.