Friday, December 24, 2021

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.


6 comments:

Candas said...

You might want to look at the RVI* views as well

Martin Maruskin said...

Hi Candas,

Would you mind to elaborate in more detail on what do you mean by RVI* views?

cheers

Candas said...

This link mentions about S4 but I can see those views in BWonHana
https://www.trailsap.com/sap-s4-hana-tables/list/?index=rvi

I came across those a long time ago, I can't remember if I ever found why this was created by SAP.

But it's an easy way to find all SAP BW objects related information.

Martin Maruskin said...

These RVI* tables seems to be present in S/4 system. However my blog post is about BW/4. I'm not even really sure if they are real S/4 tables and what's their purpose though.

Candas said...

As I said it's there in BWonHana/7.5 as well, that's why I mentioned it.
Nevermind.

Martin Maruskin said...

Hi Candas,

I'm sorry I missed that part... Yes the RVI* DDIC objects are present in BW75 on HANA. They are all DDL SQL View on top of classic BW tables - RS* namespace. Seems they are part of Reusable CDS Views used in BW. Not sure why these objects are not present in BW/4HANA systems.

Thanks for pointing to these objects!
cheers