Showing posts with label InfoArea. Show all posts
Showing posts with label InfoArea. Show all posts

Friday, December 24, 2021

BW’s InfoArea vs Application components

In BW we often hear terms like infoarea and application component. Let’s have a closer look on the two.

InfoArea (IA) as per its definition (on SAPterm - SAP Terminology) is an element for grouping meta-objects in the SAP BW systems. Each InfoProvider is assigned to the IA. Resulting hierarchy is displayed in BW’s Administrator Workbench. BW’s InfoObjects are also assigned to IAs. Table that holds data about the IA in BW is RSDAREA (Directory of InfoAreas).

Application component (APCO) has a relation to source system’s (OLTP) datasources. Historically when SAP started to deliver the datasources (within Business Content) for their EPR system they followed an application’s hierarchy of the ERP. In addition, that part had to reflect into BW as well. There are t-codes like RSA9 that can be used in ERP source system to transfer source system’s application component hierarchy to BW. Thus while speaking of the APCO think of hierarchy of applications in the source system.

However, relation between the application component hierarchy in the OLTP system and BW system are independed from each other. They are also stored in different tables. BW’s APCO is stored in the table RSAPPL (Application components directory). Whereas DataSource application component hier is stored in the table RODSAPPL DataSource Application Components.

More information:

onlinedocu


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

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

This blog post is continuation of my earlier blog - How to find out InfoArea for particular BW object type. That blog was focused on classic BW running on anyDB. In advent of BW/4 the tables for the BW objects have changed a little so I’m refurnishing the old blog post in here.

BW obj type

Table

Input field

Field which holds InfoArea’s name

InfoObject

RSDIOBJ

IOBJNM

MTINFOAREA

aDSO

RSOADSO

ADSONM

INFOAREA

Composite Provider

RSOHCPR

HCPRNM

INFOAREA

Open ODS View

RSFBP

FBPNAME

INFOAREA

OpenHub

RSBOHDEST

OHDEST

INFOAREA

DataSource

RSDS

DATASOURCE

APPLNM *

InfoSource

RSKSNEW

ISOURCE

INFOAREA

Data Flow

RSDFDMOD

DATAFLOW

INFOAREA

BW Query components

RSZCOMPDIR

COMPUID

COMPID

INFOAREA

HANA Analysis Processes

RSDHAMAP

HAAPNM

INFOAREA *

Planning Sequence

RSPLS_SEQUENCE

SEQNM

INFOAREA *

Process Chain

RSPCCHAINATTR

CHAIN_ID

APPLNM *

 

* Field not populated (not used) in the table

* Instead of InfoArea an Application Component is used

 

More information:

How to find out InfoArea for particular BW object type.


Friday, January 8, 2016

How to find out InfoArea for particular BW object type?

- update on 24DEC2021 - 

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: