RSZELTPROP - Element properties (settings)
Element properties (settings) information is stored in SAP table RSZELTPROP.
It is part of development package RSZ in software component BW-BEX-ET. This development package consists of objects that can be grouped under "BEx query definition server".
It is part of development package RSZ in software component BW-BEX-ET. This development package consists of objects that can be grouped under "BEx query definition server".
Fields for table RSZELTPROP
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| ELTUID | BW: Unequivocal ID in room and time | X | RSUNIIDX | CHAR | 50 | |
| OBJVERS | Object version | X | RSOBJVERS | CHAR | 2 | |
| .INCLUDE | RSZQRYPROP | 0 | ||||
| NOMULTTXT | Query: Suppression of Repitition Texts | RRXNOMULTTXT | CHAR | 2 | ||
| SHOWFORMATS | Query: Format display | RRXSHOWFORMATS | CHAR | 2 | ||
| SUMPOSIT | Query: Position of the results row | RRXSUMPOSIT | CHAR | 2 | ||
| NOSTYLES | Query: Suppression of styles in the output | RRXNOSTYLES | CHAR | 2 | ||
| SIGNPRSNT | Query: +/- Sign Display | RRXSIGNPRSNT | CHAR | 2 | ||
| NOZERO | Query: Zero Suppression from 3.0B | RSZNOZERO | CHAR | 2 | ||
| KEYDATEFLAG | Flag for 'typing' an entry | RSZTYPEFLAG | NUMC | 2 | ||
| KEYDATE | Dim: Field for a Characteristic Value Shorter Than 60 Char. | RSCHAVL60 | CHAR | 120 | ||
| RFCSUPPORT | Query: RFC Publishing as VirtualProvider (yes/no) | RRXRFCSUPPORT | CHAR | 2 | ||
| EQSUPPORT | Query: RFC Publishing as VirtualProvider (yes/no) | RRXRFCSUPPORT | CHAR | 2 | ||
| ODATASUPPORT | Query: RFC Publishing as VirtualProvider (yes/no) | RRXRFCSUPPORT | CHAR | 2 | ||
| HANASUPPORT | External SAP HANA view for BW object | RSMHANAMODEL | CHAR | 2 | ||
| FLAT_LIST | Boolean | RS_BOOL | CHAR | 2 | ||
| DOKUURL | Query: Display document links | RSZDOKUURL | CHAR | 2 | ||
| BORURL | Query: Display BOR URL | RSZBORURL | CHAR | 2 | ||
| HIERROWS | Query: Universal display hierarchy in the rows | RSZHIERROWS | CHAR | 2 | ||
| HIERCOLS | Query: Universal display hierarchy in the columns | RZSHIERCOLS | CHAR | 2 | ||
| HIERROWSLEVEL | Dim: Initial value for hierarchy level of the expansion | RRSTARTLVL | NUMC | 4 | ||
| HIERCOLSLEVEL | Dim: Initial value for hierarchy level of the expansion | RRSTARTLVL | NUMC | 4 | ||
| WEBQDENABLED | Query: May Be Edited with Web Query Designer | RSZWEBQDENABLED | CHAR | 2 | ||
| INPUTMODUS | Mode of Input Processing | RRINPUTMODUS | NUMC | 2 | ||
| INPUTABLEALL | Make All Basic Indicators Ready for Input | RRINPUTBASIC | CHAR | 2 | ||
| ACTUALDATA | Dim: Field for a Characteristic Value Shorter Than 60 Char. | RSCHAVL60 | CHAR | 120 | ||
| ACTUALDATAFLAG | Flag for 'typing' an entry | RSZTYPEFLAG | NUMC | 2 | ||
| ADDNLS | Dim: Field for a Characteristic Value Shorter Than 60 Char. | RSCHAVL60 | CHAR | 120 | ||
| ADDNLSFLAG | Flag for 'typing' an entry | RSZTYPEFLAG | NUMC | 2 | ||
| NEWLINES_ANYLVL | New lines on any level | RSZNEWLINES_ANYLVL | CHAR | 2 | ||
| RDPOSTED_DISAGGRUNPOST | Read posted, disaggregate unposted | RSZRDPOSTED_DISAGGRUNPOST | CHAR | 2 | ||
| SUPP_FORMULAMODE | Analysis for MS Excel: Query can be driven by formulas | RSZ_SUPP_FORMULAMODE | CHAR | 2 | ||
| SUPP_DYNADD | Supoort extensibility of query at runtime (add dim, measure) | RSZ_SUPPORT_DYNADD | CHAR | 2 | ||
| .INCLUDE | RSZDIMPROP | 0 | ||||
| CHAVL | Dim: Field for a User-Defined Characteristic Value | RSCHAVL | SSTR | 8 | ||
| NODE_IOBJNM | InfoObject | RSIOBJNM | CHAR | 60 | ||
| .INCLUDE | RSZDIMPROP1 | 0 | ||||
| CUMUL | Dim: Cumulate | RRCUMUL | CHAR | 2 | ||
| CUMUL_ORDER | Order of CUMUL as Characteristic | RRCUMUL_ORDER | CHAR | 2 | ||
| CUMUL_ORDER_CRITERIA | Order criteria of CUMUL as Characteristic | RRCUMUL_ORDER_CRITERIA | CHAR | 2 | ||
| PLEVEL | Dim: Standardizing type | RRPLEVEL | CHAR | 2 | ||
| NOSUMS | Dim: Suppression of totals rows | RRXNOSUMS | CHAR | 2 | ||
| IOBJPRSNT | Display for Characteristics and Units | RSCHAPRSNT | CHAR | 2 | ||
| STRT_LVL | Dim: Initial value for hierarchy level of the expansion | RRSTARTLVL | NUMC | 4 | ||
| HRY_ACTIVE | Flag: Entered hierarchy is active display hierarchy | RRXHRYACTIVE | CHAR | 2 | ||
| SPOC | Conditional Node Suppression | RRXSPOC | CHAR | 2 | ||
| HRY_NODE_POSIT | Positions of the nodes in reference to their leaves | RRXHRYNODEPOSIT | CHAR | 2 | ||
| ALEAFNODSP | Do Not Display Leaves for Inner-Nodes in the Query | RSSHCRLEAFDSP | CHAR | 2 | ||
| HIENM | Hierarchy name | RSHIENM | CHAR | 60 | ||
| HIENMFLAG | Flag for 'typing' an entry | RSZTYPEFLAG | NUMC | 2 | ||
| VERSION | BW: Unequivocal ID in room and time (numbers and letters) | RSUNIIDC25 | CHAR | 50 | ||
| VERSIONFLAG | Flag for 'typing' an entry | RSZTYPEFLAG | NUMC | 2 | ||
| DATETO | BW: Unequivocal ID in room and time (numbers and letters) | RSUNIIDC25 | CHAR | 50 | ||
| DATETOFLAG | Flag for 'typing' an entry | RSZTYPEFLAG | NUMC | 2 | ||
| THJT | Key Date Derivation Type | RSRHIERTHJT | CHAR | 20 | ||
| MA_ACTIVE | Boolean | RS_BOOL | CHAR | 2 | ||
| MA_IOBJPRSNT | Display for Characteristics and Units | RSCHAPRSNT | CHAR | 2 | ||
| MA_POSIT | Logical sequence (position) | RSZPOSN | INT4 | 4 | ||
| MA_S_OBJ | Characteristic | RSCHANM | CHAR | 60 | ||
| MA_S_TYP | Sort: (K)ey, (T)ext, (V)alue (H)ierarchy | RROSART | CHAR | 2 | ||
| MA_S_DIR | Sort direction | RROSDIR | CHAR | 2 | ||
| IS_EMPTY | Display Values Not Posted | RREMPTY | CHAR | 2 | ||
| MA_READ_MODE | Read Mode(F4) for Master Data Read Services | RSMD_RS_READ_MODE | CHAR | 2 | ||
| NL_READ_MODE | Read Mode(F4) for Master Data Read Services | RSMD_RS_READ_MODE | CHAR | 2 | ||
| HIER_DIS | Disaggregation for Budgeting | RSZHIERDIS | CHAR | 2 | ||
| INIVIEW_PRIO | Refresh Filter State with Query Settings | RSZINIVIEWPRIO | CHAR | 2 | ||
| .INCLUDE | RSZSTRMEMPROP | 0 | ||||
| NUM_SCALE | StrMember: Scaling factor of a number | RRSCALE | CHAR | 2 | ||
| NUM_PREC | StrMember: Number of places after decimal point for output | RRPRECISION | CHAR | 2 | ||
| EMPHASIS | Emphasize Element | RSZEMPHASIS | CHAR | 2 | ||
| TCUR | BW: Unequivocal ID in room and time (numbers and letters) | RSUNIIDC25 | CHAR | 50 | ||
| TCURFLAG | Flag for 'typing' an entry | RSZTYPEFLAG | NUMC | 2 | ||
| CTTNM | StrMember: Name of Currency Conversion Type | RRNUMBR | CHAR | 20 | ||
| SIGNINV | StrMember: +/- sign change | RSZSIGN | CHAR | 2 | ||
| FORMULACOLLSN | StrMember: Establishing Prf. Analysis with formula collision | RSZCALCULATION | CHAR | 2 | ||
| HIDDEN | Do Not Display Element | RSZHIDDEN | CHAR | 2 | ||
| STRMEM_PLEVEL | Dim: Standardizing type | RRPLEVEL | CHAR | 2 | ||
| STRMEM_CUMUL | Dim: Cumulate | RRCUMUL | CHAR | 2 | ||
| STRMEM_LAGGR | Local Aggregation | RRLAGGR | NUMC | 4 | ||
| NSUBR | Boolean | RS_BOOL | CHAR | 2 | ||
| PARENT | UUID in compressed form | SYSUUID_25 | CHAR | 50 | ||
| DRILLSTATE | Status of a hierarchy node with respect to tree structure | RRXDRILLSTATE | CHAR | 2 | ||
| CONSTSEL | Selection independent of the drilldown | RSZCONSTSEL | CHAR | 2 | ||
| STRMEM_NOZERO | Query: Suppress zeros | RRNOZERO | CHAR | 2 | ||
| LAGGR_DIR | Axis Description | RSZAXIS | NUMC | 2 | ||
| INPUTABLE | Element is input-ready | RSZINPUTABLE | CHAR | 2 | ||
| LOCK | Element is lock-relevant | RSZLOCK | CHAR | 2 | ||
| TCURDATEFLAG | Flag for 'typing' an entry | RSZTYPEFLAG | NUMC | 2 | ||
| TCURDATE | BW: Unequivocal ID in room and time (numbers and letters) | RSUNIIDC25 | CHAR | 50 | ||
| UOMNM | Name of Quantity Conversion Type | RSUOMNM | CHAR | 20 | ||
| TUOMFLAG | Flag for 'typing' an entry | RSZTYPEFLAG | NUMC | 2 | ||
| TUOM | BW: Unequivocal ID in room and time (numbers and letters) | RSUNIIDC25 | CHAR | 50 | ||
| DRILLSTATE_EXEC | State of Hierarchy Node in Tree Structure (At Runtime) | RRXDRILLST_EXEC | CHAR | 2 | ||
| STRMEM_DIS | Disaggregation on Totals | RSZDIS | CHAR | 2 | ||
| STRMEM_DISREF | UUID Reference for Disaggregation on Totals | RSZDISREF | CHAR | 50 | ||
| S_TYP | Sort: (K)ey, (T)ext, (V)alue (H)ierarchy | RROSART | CHAR | 2 | ||
| S_OBJ | Characteristic | RSCHANM | CHAR | 60 | ||
| S_DIR | Sort direction | RROSDIR | CHAR | 2 | ||
| HS_TYP | Sort: (K)ey, (T)ext, (V)alue (H)ierarchy | RROSART | CHAR | 2 | ||
| HS_OBJ | Characteristic | RSCHANM | CHAR | 60 | ||
| HS_DIR | Sort direction | RROSDIR | CHAR | 2 | ||
| PROPVERS | Version Information for Default Value of Properties | RSPROPVERS | CHAR | 2 | ||
| SWITCHID | ID of Switch in Switch Framework | SFW_SWITCHID | CHAR | 60 |