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:
You might want to look at the RVI* views as well
Hi Candas,
Would you mind to elaborate in more detail on what do you mean by RVI* views?
cheers
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.
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.
As I said it's there in BWonHana/7.5 as well, that's why I mentioned it.
Nevermind.
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
Post a Comment