R3 field and table names

[Former Member]

Could someone kindly tell me where in BW I can find reference to the correspnding R3 field name and table.

Thanks & regards

Tina

[Former Member · Accepted solution]

HI,

go to SE11 at BW side give the table name : RSTRFIELDSH

click on display then click on contents button

there u will find out the field box u can give the field name there and say execute there u will find out the corresponding BW objects as well as Datasources of particular field..

Thanks & Regards

Ramesh

[Former Member]

Thank you all for your prompt reply - much appreciated

[Former Member]

To find the table where the field exists -Easy ways first check for the datasources at http://help.sap.com/saphelp_nw2004s/helpdata/en/3d/5fb13cd0500255e10000000a114084/frameset.htm as Rasim suggested.

If that really doesn't help you have to have a look at this Excellent blog by Roberto Negro : /people/sap.user72/blog/2005/09/05/sap-bw-and-business-content-datasources-in-pursuit-of-the-origins

You can run a trace in ST05 with RSA3 on n check wot tables is d datasource reading.

[Former Member]

RSOSFIELDMAP

You will see :

OLTPSOURCE

LOGSYS

OBJVERS

FIELDNM = BELNR ( for example )

IOBJNM

CONVERSION

Width of Output List

Maximum No. of Hits

Execute

You will get a list of datasources where the ECC field exists & the object.

U can do <b>Viceversa</b> too

[purvang_zinzuwadia]

hi,

you can also see this in transfer structure, on right hand side pan. Thr is mapping of names between R/3 Field name and BW field name.

Regards,

Purvang