How to find out InfoArea for particular BW object type?

- update on 24DEC2021 - 

For an BW/4 version see new blog: How to find out InfoArea for particular BW object type – in BW/4 systems?

I run into this issue quite often. I need to find out where in BW object’s tree in modeling area of RSA1 the object is precisely located. I mean what is an InfoArea where particular object is located. Well I can search for it and once it is found the system gets me directly into its position. However it gets worse when I do not have an authorization to access the object. In such a case even search does not find it. Therefore I have to lookup particular InfoArea manually. Here I’m posting a kind of cheat list with all the tables which can help to lookup the InfoArea of different BW object types.

Kindly notice that list of BW object types is not comprehensive but it server with few basic and most used types.

BW obj type	Table	Input field	Field which has InfoArea’s name
InfoObject	RSDIOBCIOBJ RSDCHABAS	IOBJNM CHABASNM	INFOOBJCAT INFOAREA
DSO	RSDODSO	ODSOBJECT	INFOAREA
SPO	RSLPO	LPO	INFOAREA
OpenHub	RSBOHDEST	OHDEST	INFOAREA
InfoCube	RSDCUBE	INFOCUBE	INFOAREA
Composite Provider	RSDDCOPR	COMPNAME	INFOAREA
Data Flow	RSDFDMOD	DATAFLOW	INFOAREA
HANA Analysis Processes	RSDHAMAP	HAAPNM	INFOAREA
HANA CompositeProvider	RSOHCPR	HCPRNM	INFOAREA
InfoSet	RSQISET	INFOSET	INFOAREA
Planning Sequence	RSPLS_SEQUENCE	SEQNM	INFOAREA

Guide: e.g. for InfoObject go to table RSDIOBCIOBJ and for given IO name in field IOBJNM value of field INFOOBJCAT gets InfoArea.

More information:

How to find out InfoArea for particular BW object type – in BW/4 systems?