on 01-08-2009 8:17 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.