Question Re: Table or view that stores SID table for InfoObjects. in Technology Q&A

Table or view that stores SID table for InfoObjects.

Former Member — Mon, 15 Apr 2013 21:01:37 GMT

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.

Re: Table or view that stores SID table for InfoObjects.

Former Member — Tue, 16 Apr 2013 13:28:40 GMT

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

Re: Table or view that stores SID table for InfoObjects.

RamanKorrapati — Tue, 16 Apr 2013 14:38:57 GMT

Hi Elvis,

Please look at this table -RSDMD_S_ATR_ENH

Thanks

Re: Table or view that stores SID table for InfoObjects.

Former Member — Tue, 16 Apr 2013 16:26:52 GMT

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

Re: Table or view that stores SID table for InfoObjects.

Former Member — Tue, 16 Apr 2013 16:28:41 GMT

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

Thanks for your help.

Re: Table or view that stores SID table for InfoObjects.

RamanKorrapati — Tue, 16 Apr 2013 16:34:45 GMT

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

Re: Table or view that stores SID table for InfoObjects.

Former Member — Wed, 17 Apr 2013 04:30:19 GMT

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.

Re: Table or view that stores SID table for InfoObjects.

Former Member — Wed, 17 Apr 2013 06:46:56 GMT

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

Re: Table or view that stores SID table for InfoObjects.

umashankar_poojar — Wed, 17 Apr 2013 07:24:55 GMT

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

Re: Table or view that stores SID table for InfoObjects.

Former Member — Wed, 17 Apr 2013 20:47:09 GMT

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

Re: Table or view that stores SID table for InfoObjects.

Former Member — Wed, 17 Apr 2013 20:49:41 GMT

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