cancel
Showing results for 
Search instead for 
Did you mean: 

to get the list of cube, object, info source etc

Former Member
0 Kudos

is there any way I can get the list of all the objects, providers, info packages, tranfer rule, infosouces from our system from all the info areas. we are in BW3.5. any transactions or any other way.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

SE16

RSUPDINFO -- Infocube to Infosource correlation

RSIS -- Infosouce Info

RSUPDINFO -- Update Rules Info

RSTS -- Transfer Rules Info

RSKSFIELD -- Communication Structure fields

RSTSODS -- Operational data store for Transfer structure

RSZELTDIR -- Query Elements

RXSELTXREF, RSCOMPDIR -- Reports/query relavent tables

RSDIOBJ -- Infoobjects

RSMONIPTAB -- InfoPackage for the monitor

RSRWORKBOOK -- Workbooks & related query genunid's

RSRREPDIR -- QUERY RELATED --Contains Genuin id, Rep Name, author, etc...

RSRINDEXT -- Workbook ID & Name

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

You can find available BW objects like infocubes, ODS, transfer stuctutes, queries.. and so on using transaction RSA1--> click on 'Metadata repository'

or you can find these details with the following tables.

Info Objects: RSDIOBJ

Info Cubes:RSDCUBE

Multi providers:RSDCUBE

Update rules:RSUPDINFO

ODS Objects:RSDODSO

Transfer structures:RSTS

Thanks and Regards,

Ramki

Former Member
0 Kudos

hi ,

you can check this in Tables:

InfoCubes(amd multipr): RSDCUBE,

ODS Objetcs: RSDODSO,

InfoSources: RSIS,

TrStruct: RSTS,

Queries: RSZELTDIR(DEFTP=REP)

or

Transaction RSA1and then choose MetadataRepository.

You'll find all you objects with details there.

Regards,

Shikha