How to search Info objects for corresponding fields in the R/3

[Former Member]

Hi,

i have sevral fields in the Source System ex: Delivery Schedule for Sales Order, Procurement Source, Primary Resource for material, Data Changed Status etc. I have technical details of these fields in R/3. How can i search the Info Objects corresponding fields.

Thanks in Advance.

Regards,

Nagesh.

[Former Member · Accepted solution]

Hi dear,

if you are talking about EXISTING mapping in BW between IO and R/3 fields you can look at RSISOSMAP table (in BW), while if you are talking about POTENTIAL mapping between your R/3 fields and BW IOs, look in R/3 in table ROOSFIELD !!!

Hope it helps!

Bye,

Roberto

[Former Member · Accepted solution]

Hi Roberto,

i couldn't find any infoobjects, i could see version several properties of Data Source in RSISOSMAP table(BW). I could see technical field names of R/3 in table ROOSFIELD TABLE.

can you elabore it. i couldn't see any Info Objects corresponding to that field names. With the help of these i want map in Transfer rules, i need to create a custom cube. I need to model the extraction scenario. I finalized the source of data. i need to design in bw.

Regards,

Nagesh.

Message was edited by: Nagesh Ganisetti

[Former Member · Accepted solution]

Sorry !

In BW you have to look at RSOSFIELDMAP table !

In ROOSFIELD, put your R/3 field in FIELD. Then retrieve OLTPSOURCE name and search in help on line on which IOs these fields are mapped !

Hope now is clearer...

Bye,

Roberto

[Former Member · Accepted solution]

Thank you Roberto. I will check it out. i will get back you afterwards.

i will assign points.

Regards,

Nagesh.

[Former Member]

Go to BW system and SE11 and look into table RSTSFIELD give the R/3 field name you will get the InfoObject used in BW system if you don't get anything that means it hasn't been mapped with any InfoObject in BW yet.

Hope this helps.

BK

[Former Member]

Hi,

I checked the two tables .i.e. TSTSFIELD and RSOSFIELDMAP. i couldn't find info objects for my fields. I will tell you how i added the fields. In Lo customizing SAP has selected some fields by default in the Extract Structure. in the right side we could see the fields i selected those fields to extract structure. I couldn't find the info Objects for that.

Please guide me. Is it possible to search info objects by field name(R/3 field name).

Thanks and Regards,

Nagesh.

[Former Member]

Nagesh;

I think we are missing something here, If you didn't find any InfoObject for this R/3 field in table RSTSFIELD, then it means you still have to do the mapping. I understand you have added the field into the extract structure that does not mean you have the infoObject already mapped with this field in BW system. You have to find a suitable InfoObject for this field or if you don't find any create one in RSD1 and map this new InfoObject to the new R/3 field in your transfer structure (InfoSoure)

Also you need to add this new InfoObject into your comm. structure and cubes as well.

Hope this helps you.

Regards:

BK

[Former Member]

Hi,

those fields also provided by SAP in Extract Structure Maintenance. i didn't enhance the extract Structure(i just maintained the Extract Strucre in LO settings i added some fields from left side to right side what SAP has provided). at that time also do i need to create the Info Objects.

I think SAP will provide the infobjects for those. Please guide me.

Regards,

Nagesh.

[Former Member]

Yes; you still need to map the infoObject for the fields in transfer structures.

Please assign points if any of this answers is helpful to you.

thanks.

Regards:

BK

[Former Member]

BK,

If I understood right, I think you are looking for info objects to assign to the fields coming from R/3. If it is so. Go to RSD1 and select the 'All info objects' option and click display. This gives you all the infoobjects available, you can then scroll down and compare the type and length of the field with the info objects.

Hope this helps....

[Former Member]

Nagesh,

all our suggestions are not useful, since you still have to map your added fields !

First of all, if you insert the name of your fields in help on line it's possible that you can see some of your required IOs...otherwise let us know datasource and fields so we can do the search for you !

Bye,

Roberto

[Former Member]

Hi roberto,

i'm trying to find in the BC. my DS name: 2lis_03_bf, fields: i think some i mentioned info objects can u confirm these.

Primary resource for material

Procurement Source

Data Changed Statis

Item in material document: 0MAT_ITEM (i'm expecting)

Profitability segment number (CO-PA): 0ME_REVO_PA

Number of material document: 0MAT_DOC

Movement indicator: 0OI_FTIND

Delivery schedule for sales order :

Delivery costs in local currency : 0DLV_COSTS

Routing number for operations in the order : 0ROUTE

Conversion factor from base uom to KG_AI

Conversion factor from base uom to KG_LT

Conversion factor from base uom to LB_AI

Conversion factor from base uom to LB_GL

regards,

Nagesh.

[Former Member]

Better technical names !

[Former Member]

ZKG_AI Conversion factor from base uom to KG_AI

ZKG_LT Conversion factor from base uom to KG_LT

ZLB_AI Conversion factor from base uom to LB_AI

ZLB_GL Conversion factor from base uom to LB_GL

ZPC Conversion factor from base uom to PC

ZZPRESOURC Primary resource for material

ZZPROCTYPE Procurement Source

ZZZUPSTAT Data Changed Statis

[Former Member]

!!!

But is everything custom !!!

Sorry dear, but how can we suggest std objects to use in your mapping without knowing your custom fields

You have (and it would be better) to create custom IOs in BW with type and lenght as your custom fields !

Bye,

Roberto

[Former Member]

Hi,

I'm really sorry. I thaught these fields are given by SAP. i checked the fields history in the SAP R/3 that is developed by SAP. Any way i will develop the Custom IO for these. can u guide what are development guide lines.

ZKG_AI DEC 10 5 Conversion factor from base uom to KG_AI

ZKG_LT DEC 10 5 Conversion factor from base uom to KG_LT

ZLB_AI DEC 10 5 Conversion factor from base uom to LB_AI

ZLB_GL DEC 10 5 Conversion factor from base uom to LB_GL

ZZPRESOURC CHAR 8 Primary resource for material

ZZPROCTYPE char 2 Procurement Source

ZPC DEC 10 5 Conversion factor from base uom to PC

ZZZUPSTAT CHAR 1 Data Changed Statis

Regards,

Nagesh.

[Former Member]

Hi Nagesh;

Hu!! you were saying the fields are provided by SAP, they are all customs ..now you need to create InfoObject in BW system to match the behavior of these fields.

Are these all answers are not helpful to you?? If so Please assign some points to them. this is the only way to say thanks for the helps.

Hope you will be able to map these fields with appropriate InfoObjects.

Regards:

BK

[Former Member]

Hi,

am having the same doubt

" those fields also provided by SAP in Extract Structure Maintenance. i didn't enhance the extract Structure(i just maintained the Extract Strucre in LO settings i added some fields from left side to right side what SAP has provided). at that time also do i need to create the Info Objects. 

I think SAP will provide the infobjects for those. Please guide me."

Can you please help me in identifying the standard info object other thant the constant fields  on the left hand side. as they are standard i guess we can find the standard objects kindly let me know is there any way to identify the standard fileds for those objects..... am stuck up in indentifying the objects from 2 days....

Thanks,

Malathi

[Former Member]

Hi Malathi,

Kindly check below tables in BW. They will give infoobjects used against R3 fields as well as Z fields mapped in BW.

RSOSFIELDMAP : Mapping Between OLTP Source Fields and InfoObjects

RSOSFIELDMAPSH : Shadow Table: Mapping between OLTPs, Fields and IOBJs

Regards:

Jitendra

[Former Member]

Hi,

You can find it in RSTSFIELD tabel in BW

Hope this helps,

Kashyap