Hierarchy Tables
转载自:http://wiki.scn.sap.com/wiki/display/BI/Hierarchy+Tables
Hierarchy Tables |
Description |
---|---|
RSHIEDIR | Hierarchy Directory, Header Information |
RSHIEDIRT | Hierarchy directory texts |
/BI*/H<IOBJNM> | Hierarchy structure table |
/BI*/J<IOBJNM> | Interval table |
RSMHIERNODE | Master data table for text nodes |
RSTHIERNODE | Text table for text nodes |
SID Tables |
Description |
---|---|
RSRHIEDIR_OLAP | OLAP table hierarchy directory |
/BI*/K<IOBJNM> | Conversion of hierarchy nodes - SID |
/BI*/I<IOBJNM> | SID table hierarchy structure |
Important Fields for RSHIEDIR |
Description |
---|---|
HIEID | Internal hierarchy ID (unique ID) |
OBJVERS | Object version (M or A) |
HIETYPE | Type BW hierarchies 1= master data hierarchy with ref to infoobject |
HIENM | Hierarchy name |
VERSION | Hierarchy version |
DATETO | Date valid to |
IOBJNM | InfoObject |
DATEFROM | Date valid from |
LOGSYS | Source system |
REQUEST | Request number for data transfer |
TSTPNM | Last changed by |
TIMESTMP | UTC time stamp in abbreviated form (YYYYMMDDhhmmss) |
Fields of Structure table /BI*/H<IOBJNM> |
Description |
---|---|
HIEID | Internal hierarchy ID (unique ID) |
OBJVERS | Object version |
NODEID | Internal ID number for a hierarchy node |
IOBJNM | InfoObject |
NODENAME | Hierarchy node name |
TLEVEL | Hierarchy node level |
LINK | Link indicator for a hierarchy node |
PARENTID | Parent ID for a hierarchy node |
CHILDID | Child ID for a hierarchy node |
NEXTID | Next ID for a hierarchy node |
DATEFROM | Date valid from |
DATETO | Date valid to |
INTERVL | Flag: node is interval |
SIGNCH | +/- sign reversal |
Fields of Interval table /BI*/J<IOBJNM> |
Description |
---|---|
HIEID | Internal hierarchy ID (unique ID) |
OBJVERS | Object version |
NODEID | Internal ID number for a hierarchy node |
LEAFFROM | Hierarchy leaf from |
LEAFTO | Hierarchy leaf to |
Fields of Text Node Table RSMHIERNODE |
Description |
---|---|
HIEID | Internal hierarchy ID (unique ID) |
OBJVERS | Object version |
NODENAME | Hierarchy nodes unable to be posted |
Texts for text nodes RSTHIERNODE |
Description |
---|---|
LANGU | Language key |
HIEID | Internal hierarchy ID (unique ID) |
OBJVERS | Object version |
NODENAME | Hierarchy nodes unable to be posted |
TXTSH | Short description |
TXSTMD | Medium description |
TXTLG | Long description |