Hierarchy
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-WHM-MTD (Application Component) Metadata (Repository)⤷
RSD (Package) BW: Data Basis InfoObjects and Core Services
Basic Data
| Data Element | RSSIDTAB |
| Short Description | Table of master data IDs |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | AS4TAB | |
| Data Type | CHAR | Character String |
| Length | 30 | |
| Decimal Places | 0 | |
| Output Length | 30 | |
| Value Table | DD02L |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | MID Tab. |
| Medium | 15 | SID table |
| Long | 20 | SID table |
| Heading | 10 | MID Tab. |
Documentation
Definition
Use
In InfoCubes and aggregates, master data IDs (SIDs) are saved instead of characteristic values. In the SID table, a master data ID is stored for every characteristic value. The OLAP processor also only works internally with SIDs and not with characteristic values.
Dependencies
Generation of SIDs for characteristic M1:
In the following cases SIDs are generated for M1:
- Loading of master data for M1
- Loading of texts for M1
- Loading of master data for a characteristic that has M1 as a navigation attribute
- Activation of M1 as navigation attribute for a characteristic
- Addition of M1 as navigation attribute for a characteristic if M1 is compounded
- Loading of InfoCube data with the option of generating master data
- Deactivation of the property exclusive attribute for characteristic M1, if M1 is used in ODS Objects that are released for reporting
In the following cases SIDs for M1 are only generated if M1 is not an exclusive attribute):
- Activation of data of an DataStore object that is released for reporting and contains M1
- Release of a DataStore object that contains M1 for reporting
- Execution of a query on a characteristic as InfoProvider that contains M1 as an attribute
Execution of a query on an InfoSet that contains M1 (via a characteristic or a DataStore object)
Example
The content of the SID table for the characteristic Material could be as follows:
MATERIAL SID
0
ABC 1
10000 2
DEF 3
10100 4
XYZ 5
RTZE 6
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
