Table or view that stores SID table for InfoObjects.

[Former Member]

What data dictionary table or view stores the name of the SID table for InfoObjects?  In the Display Characteristics transaction the form uses the structure RSDGSCIOBJ and the field name SIDTAB.  I am looking for the source table object that stores SIDTAB.  Thanks.

[Former Member · Accepted solution]

Hi,

not sure if there is such a table as the table name follows a strict naming convention. Please check out one standard object, e.g. 0material, and one self defined object, e.g. zobject. The table name will be /bi0/smaterial for 0material and /bic/szobject for zobject. If you have your own name space in use, just replace /bic/ by /<your name space>/.

regards

Siggi

[Former Member · Accepted solution]

Hi Siegfried, looks like it's pointing that way.  These rules are pretty basic, I could probably work with this.

Thanks for your help.

[Former Member]

Thanks to everyone that has taken the time to reply to my question.

To provide more context for my question, I am developing a script that will build a query to select information from any DSO or cube (instead of using display data in RSA1).  I much prefer using SQL to query instead using SAP.  So in general terms I need to know what the name a SID table is for all infoobjects for any particular DSO/Cube.  I would think that sort of data modeling information would be stored as a column in some infoobject table. Ideally I would like to query some data dictionary table related to infoobjects to get corresponding SID table, otherwise I will have to programatically build the SID table name Siegfried suggested.

Thanks.

Elvis

[umashankar_poojar]

Hi Elvis,

           As you mentioned in the display transaction, the form uses the structure RSDGSCIOBJ and field name SIDTAB, and you would like to know the source table for SIDTAB.  Please note it doesn't have any source, infact it is filled during runtime.

Further Information:

The value for this field is populated by program 'SAPLRSD_GU_IOBJ_MAINT' - please note this is Function Pool not executable program. Inside this there is a include program 'LRSD_GUI_IOBJ_MAINTF40' which calls the Function Module 'RSD_SIDTAB_GET_FOR_CHA_BAS' to get value for the field RSDGSCIOBJ-SIDTAB.

The logic of FM is to append /BIC/S*InfoObject* OR /BI0/S*InfoObject* and display in RSDGSCIOBJ-SIDTAB.

Based on above logic, if you check the tables DD02V (view on DD02L & DD02T) and search /BIC/S* & /BI0/S* in table name. you will get the names of SID Tables for all InfoObjects.

Thanks,

Umashankar

[Former Member]

Hi Umashankar,

Please see my latest update.  I am asking within the context of building a SQL query and have not visibility to any ABAP structures/functions/programs/etc.

Thanks.

Elvis

[Former Member]

Hi Elvis ,

SIDs are stored in table not in view.

Suppose if you are loading cost_centre data then SID table will be

SID table is / BI0/SCost_cntr

/BIO/XCost_cntr-- SID Table, Time Independent
/BIO/YCost_cntr-- SID Tabel, Time Dependent

if it will be custom IO then table should be like

/BIC/S<IO NAME>

/BIC/X<IO NAME>

/BIC/Y<IO NAME>

Regards,

Laxmikant Verma

[Former Member]

Hi ,

You can see all the table/view information for the object in master data / text tab of the master data object.Go to display object and select the master data / Text tab .

eg : For time dependent object , SID tabel will be Y table.

If 0employee is master data object than SID table for time dependent attribute  =  /BI0/YEMPLOYEE

For time independent attribute , SID table will be X table .

SID atble for time indipendent = /BIO/XEMPLOYEE.

So you can see all information about related table /view for the object .

Regards,

Neha.

[RamanKorrapati]

Hi Elvis,

Please look at this table -RSDMD_S_ATR_ENH

Thanks

[Former Member]

Hi K Raman

Doesn't look like the table exists in our system....we are on BW 7.01, would the table exist in later versions?

Thanks

Elvis

[RamanKorrapati]

Hi Elvis,

Yes, think so, i can able to see in our system which bw 7.3, so you can follow same path which you got(siggi suggestion).

Might be useful.

Thanks