RSZELTPROP SAP table for – Element properties (settings)

Here we would like to draw your attention to RSZELTPROP table in SAP. As we know it is being mainly used with the SAP BW-BEX (Business Explorer in BW) component which is coming under BW module (Business Warehouse). RSZELTPROP is a SAP standard transp table used for storing Element properties (settings) related data in SAP. It comes under the package RSZ.

SAP RSZELTPROP table

Table RSZELTPROP technical data

TableRSZELTPROP
Data storingElement properties (settings)
ModuleBW
Sub ModuleBW-BEX-ET
SAP PackageRSZ
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentSAP_BW
Table CategoryTRANSP

SAP RSZELTPROP Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in RSZELTPROP table.

  • ELTUID : BW: Unequivocal ID in room and time
    Its a key field. Its data type is CHAR (Character String) with field length 25
  • OBJVERS : Object version
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Query properties
  • NOMULTTXT : Query: Suppression of Repitition Texts
    Its data type is CHAR (Character String) with field length 1
  • SHOWFORMATS : Query: Format display
    Its data type is CHAR (Character String) with field length 1
  • SUMPOSIT : Query: Position of the results row
    Its data type is CHAR (Character String) with field length 1
  • NOSTYLES : Query: Suppression of styles in the output
    Its data type is CHAR (Character String) with field length 1
  • SIGNPRSNT : Query: +/- Sign Display
    Its data type is CHAR (Character String) with field length 1
  • NOZERO : Query: Zero Suppression from 3.0B
    Its data type is CHAR (Character String) with field length 1
  • KEYDATEFLAG : Flag for ‘typing’ an entry
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • KEYDATE : Dim: Field for a Characteristic Value Shorter Than 60 Char.
    Its data type is CHAR (Character String) with field length 60
  • RFCSUPPORT : Query: RFC Publishing as VirtualProvider (yes/no)
    Its data type is CHAR (Character String) with field length 1
  • EQSUPPORT : Query: RFC Publishing as VirtualProvider (yes/no)
    Its data type is CHAR (Character String) with field length 1
  • ODATASUPPORT : Query: RFC Publishing as VirtualProvider (yes/no)
    Its data type is CHAR (Character String) with field length 1
  • HANASUPPORT : External SAP HANA view for BW object
    Its data type is CHAR (Character String) with field length 1
  • FLAT_LIST : Boolean
    Its data type is CHAR (Character String) with field length 1
  • ZEROPRSNT : Query: Zero display
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • ZEROSTRING : Query: Zero String Display
    Its data type is CHAR (Character String) with field length 60
  • DOKUURL : Query: Display document links
    Its data type is CHAR (Character String) with field length 1
  • BORURL : Query: Display BOR URL
    Its data type is CHAR (Character String) with field length 1
  • HIERROWS : Query: Universal display hierarchy in the rows
    Its data type is CHAR (Character String) with field length 1
  • HIERCOLS : Query: Universal display hierarchy in the columns
    Its data type is CHAR (Character String) with field length 1
  • HIERROWSLEVEL : Dim: Initial value for hierarchy level of the expansion
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • HIERCOLSLEVEL : Dim: Initial value for hierarchy level of the expansion
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • WEBQDENABLED : Query: May Be Edited with Web Query Designer
    Its data type is CHAR (Character String) with field length 1
  • INPUTMODUS : Mode of Input Processing
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • INPUTABLEALL : Make All Basic Indicators Ready for Input
    Its data type is CHAR (Character String) with field length 1
  • ACTUALDATA : Dim: Field for a Characteristic Value Shorter Than 60 Char.
    Its data type is CHAR (Character String) with field length 60
  • ACTUALDATAFLAG : Flag for ‘typing’ an entry
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • ADDNLS : Dim: Field for a Characteristic Value Shorter Than 60 Char.
    Its data type is CHAR (Character String) with field length 60
  • ADDNLSFLAG : Flag for ‘typing’ an entry
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • .INCLUDE : Properties of navigation characteristics
  • CHAVL : Dim: Field for a User-Defined Characteristic Value
    Its data type is SSTR (Short Character String of Variable Length) with field length 1333
  • NODE_IOBJNM : InfoObject
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Properties of navigation characteristics (togther with OLAP)
  • CUMUL : Dim: Cumulate
    Its data type is CHAR (Character String) with field length 1
  • CUMUL_ORDER : Order of CUMUL as Characteristic
    Its data type is CHAR (Character String) with field length 1
  • CUMUL_ORDER_CRITERIA : Order criteria of CUMUL as Characteristic
    Its data type is CHAR (Character String) with field length 1
  • PLEVEL : Dim: Standardizing type
    Its data type is CHAR (Character String) with field length 1
  • NOSUMS : Dim: Suppression of totals rows
    Its data type is CHAR (Character String) with field length 1
  • IOBJPRSNT : Display for Characteristics and Units
    Its data type is CHAR (Character String) with field length 1
  • STRT_LVL : Dim: Initial value for hierarchy level of the expansion
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • HRY_ACTIVE : Flag: Entered hierarchy is active display hierarchy
    Its data type is CHAR (Character String) with field length 1
  • SPOC : Conditional Node Suppression
    Its data type is CHAR (Character String) with field length 1
  • HRY_NODE_POSIT : Positions of the nodes in reference to their leaves
    Its data type is CHAR (Character String) with field length 1
  • ALEAFNODSP : Do Not Display Leaves for Inner-Nodes in the Query
    Its data type is CHAR (Character String) with field length 1
  • HIENM : Hierarchy name
    Its data type is CHAR (Character String) with field length 30
  • HIENMFLAG : Flag for ‘typing’ an entry
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • VERSION : BW: Unequivocal ID in room and time (numbers and letters)
    Its data type is CHAR (Character String) with field length 25
  • VERSIONFLAG : Flag for ‘typing’ an entry
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • DATETO : BW: Unequivocal ID in room and time (numbers and letters)
    Its data type is CHAR (Character String) with field length 25
  • DATETOFLAG : Flag for ‘typing’ an entry
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • THJT : Key Date Derivation Type
    Its data type is CHAR (Character String) with field length 10
  • MA_ACTIVE : Boolean
    Its data type is CHAR (Character String) with field length 1
  • MA_IOBJPRSNT : Display for Characteristics and Units
    Its data type is CHAR (Character String) with field length 1
  • MA_POSIT : Logical sequence (position)
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • MA_S_OBJ : Characteristic
    Its data type is CHAR (Character String) with field length 30
  • MA_S_TYP : Sort: (K)ey, (T)ext, (V)alue (H)ierarchy
    Its data type is CHAR (Character String) with field length 1
  • MA_S_DIR : Sort direction
    Its data type is CHAR (Character String) with field length 1
  • IS_EMPTY : Display Values Not Posted
    Its data type is CHAR (Character String) with field length 1
  • MA_READ_MODE : Read Mode(F4) for Master Data Read Services
    Its data type is CHAR (Character String) with field length 1
  • HIER_DIS : Disaggregation for Budgeting
    Its data type is CHAR (Character String) with field length 1
  • INIVIEW_PRIO : Refresh Filter State with Query Settings
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Properties of structure members
  • NUM_SCALE : StrMember: Scaling factor of a number
    Its data type is CHAR (Character String) with field length 1
  • NUM_PREC : StrMember: Number of places after decimal point for output
    Its data type is CHAR (Character String) with field length 1
  • EMPHASIS : Emphasize Element
    Its data type is CHAR (Character String) with field length 1
  • TCUR : BW: Unequivocal ID in room and time (numbers and letters)
    Its data type is CHAR (Character String) with field length 25
  • TCURFLAG : Flag for ‘typing’ an entry
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • CTTNM : StrMember: Name of Currency Conversion Type
    Its data type is CHAR (Character String) with field length 10
  • SIGNINV : StrMember: +/- sign change
    Its data type is CHAR (Character String) with field length 1
  • FORMULACOLLSN : StrMember: Establishing Prf. Analysis with formula collision
    Its data type is CHAR (Character String) with field length 1
  • HIDDEN : Do Not Display Element
    Its data type is CHAR (Character String) with field length 1
  • STRMEM_PLEVEL : Dim: Standardizing type
    Its data type is CHAR (Character String) with field length 1
  • STRMEM_CUMUL : Dim: Cumulate
    Its data type is CHAR (Character String) with field length 1
  • STRMEM_LAGGR : Local Aggregation
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • NSUBR : Boolean
    Its data type is CHAR (Character String) with field length 1
  • PARENT : UUID in compressed form
    Its data type is CHAR (Character String) with field length 25
  • DRILLSTATE : Status of a hierarchy node with respect to tree structure
    Its data type is CHAR (Character String) with field length 1
  • CONSTSEL : Selection independent of the drilldown
    Its data type is CHAR (Character String) with field length 1
  • STRMEM_NOZERO : Query: Suppress zeros
    Its data type is CHAR (Character String) with field length 1
  • LAGGR_DIR : Axis Description
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • INPUTABLE : Element is input-ready
    Its data type is CHAR (Character String) with field length 1
  • LOCK : Element is lock-relevant
    Its data type is CHAR (Character String) with field length 1
  • TCURDATEFLAG : Flag for ‘typing’ an entry
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • TCURDATE : BW: Unequivocal ID in room and time (numbers and letters)
    Its data type is CHAR (Character String) with field length 25
  • UOMNM : Name of Quantity Conversion Type
    Its data type is CHAR (Character String) with field length 10
  • TUOMFLAG : Flag for ‘typing’ an entry
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • TUOM : BW: Unequivocal ID in room and time (numbers and letters)
    Its data type is CHAR (Character String) with field length 25
  • DRILLSTATE_EXEC : State of Hierarchy Node in Tree Structure (At Runtime)
    Its data type is CHAR (Character String) with field length 1
  • STRMEM_DIS : Disaggregation on Totals
    Its data type is CHAR (Character String) with field length 1
  • STRMEM_DISREF : UUID Reference for Disaggregation on Totals
    Its data type is CHAR (Character String) with field length 25
  • S_TYP : Sort: (K)ey, (T)ext, (V)alue (H)ierarchy
    Its data type is CHAR (Character String) with field length 1
  • S_OBJ : Characteristic
    Its data type is CHAR (Character String) with field length 30
  • S_DIR : Sort direction
    Its data type is CHAR (Character String) with field length 1
  • HS_TYP : Sort: (K)ey, (T)ext, (V)alue (H)ierarchy
    Its data type is CHAR (Character String) with field length 1
  • HS_OBJ : Characteristic
    Its data type is CHAR (Character String) with field length 30
  • HS_DIR : Sort direction
    Its data type is CHAR (Character String) with field length 1
  • PROPVERS : Version Information for Default Value of Properties
    Its data type is CHAR (Character String) with field length 1
  • SWITCHID : ID of Switch in Switch Framework
    Its data type is CHAR (Character String) with field length 30