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".

Fields for table RSZELTPROP

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
ELTUIDBW: Unequivocal ID in room and timeXRSUNIIDXCHAR50
OBJVERSObject versionXRSOBJVERSCHAR2
.INCLUDERSZQRYPROP0
NOMULTTXTQuery: Suppression of Repitition TextsRRXNOMULTTXTCHAR2
SHOWFORMATSQuery: Format displayRRXSHOWFORMATSCHAR2
SUMPOSITQuery: Position of the results rowRRXSUMPOSITCHAR2
NOSTYLESQuery: Suppression of styles in the outputRRXNOSTYLESCHAR2
SIGNPRSNTQuery: +/- Sign DisplayRRXSIGNPRSNTCHAR2
NOZEROQuery: Zero Suppression from 3.0BRSZNOZEROCHAR2
KEYDATEFLAGFlag for 'typing' an entryRSZTYPEFLAGNUMC2
KEYDATEDim: Field for a Characteristic Value Shorter Than 60 Char.RSCHAVL60CHAR120
RFCSUPPORTQuery: RFC Publishing as VirtualProvider (yes/no)RRXRFCSUPPORTCHAR2
EQSUPPORTQuery: RFC Publishing as VirtualProvider (yes/no)RRXRFCSUPPORTCHAR2
ODATASUPPORTQuery: RFC Publishing as VirtualProvider (yes/no)RRXRFCSUPPORTCHAR2
HANASUPPORTExternal SAP HANA view for BW objectRSMHANAMODELCHAR2
FLAT_LISTBooleanRS_BOOLCHAR2
DOKUURLQuery: Display document linksRSZDOKUURLCHAR2
BORURLQuery: Display BOR URLRSZBORURLCHAR2
HIERROWSQuery: Universal display hierarchy in the rowsRSZHIERROWSCHAR2
HIERCOLSQuery: Universal display hierarchy in the columnsRZSHIERCOLSCHAR2
HIERROWSLEVELDim: Initial value for hierarchy level of the expansionRRSTARTLVLNUMC4
HIERCOLSLEVELDim: Initial value for hierarchy level of the expansionRRSTARTLVLNUMC4
WEBQDENABLEDQuery: May Be Edited with Web Query DesignerRSZWEBQDENABLEDCHAR2
INPUTMODUSMode of Input ProcessingRRINPUTMODUSNUMC2
INPUTABLEALLMake All Basic Indicators Ready for InputRRINPUTBASICCHAR2
ACTUALDATADim: Field for a Characteristic Value Shorter Than 60 Char.RSCHAVL60CHAR120
ACTUALDATAFLAGFlag for 'typing' an entryRSZTYPEFLAGNUMC2
ADDNLSDim: Field for a Characteristic Value Shorter Than 60 Char.RSCHAVL60CHAR120
ADDNLSFLAGFlag for 'typing' an entryRSZTYPEFLAGNUMC2
NEWLINES_ANYLVLNew lines on any levelRSZNEWLINES_ANYLVLCHAR2
RDPOSTED_DISAGGRUNPOSTRead posted, disaggregate unpostedRSZRDPOSTED_DISAGGRUNPOSTCHAR2
SUPP_FORMULAMODEAnalysis for MS Excel: Query can be driven by formulasRSZ_SUPP_FORMULAMODECHAR2
SUPP_DYNADDSupoort extensibility of query at runtime (add dim, measure)RSZ_SUPPORT_DYNADDCHAR2
.INCLUDERSZDIMPROP0
CHAVLDim: Field for a User-Defined Characteristic ValueRSCHAVLSSTR8
NODE_IOBJNMInfoObjectRSIOBJNMCHAR60
.INCLUDERSZDIMPROP10
CUMULDim: CumulateRRCUMULCHAR2
CUMUL_ORDEROrder of CUMUL as CharacteristicRRCUMUL_ORDERCHAR2
CUMUL_ORDER_CRITERIAOrder criteria of CUMUL as CharacteristicRRCUMUL_ORDER_CRITERIACHAR2
PLEVELDim: Standardizing typeRRPLEVELCHAR2
NOSUMSDim: Suppression of totals rowsRRXNOSUMSCHAR2
IOBJPRSNTDisplay for Characteristics and UnitsRSCHAPRSNTCHAR2
STRT_LVLDim: Initial value for hierarchy level of the expansionRRSTARTLVLNUMC4
HRY_ACTIVEFlag: Entered hierarchy is active display hierarchyRRXHRYACTIVECHAR2
SPOCConditional Node SuppressionRRXSPOCCHAR2
HRY_NODE_POSITPositions of the nodes in reference to their leavesRRXHRYNODEPOSITCHAR2
ALEAFNODSPDo Not Display Leaves for Inner-Nodes in the QueryRSSHCRLEAFDSPCHAR2
HIENMHierarchy nameRSHIENMCHAR60
HIENMFLAGFlag for 'typing' an entryRSZTYPEFLAGNUMC2
VERSIONBW: Unequivocal ID in room and time (numbers and letters)RSUNIIDC25CHAR50
VERSIONFLAGFlag for 'typing' an entryRSZTYPEFLAGNUMC2
DATETOBW: Unequivocal ID in room and time (numbers and letters)RSUNIIDC25CHAR50
DATETOFLAGFlag for 'typing' an entryRSZTYPEFLAGNUMC2
THJTKey Date Derivation TypeRSRHIERTHJTCHAR20
MA_ACTIVEBooleanRS_BOOLCHAR2
MA_IOBJPRSNTDisplay for Characteristics and UnitsRSCHAPRSNTCHAR2
MA_POSITLogical sequence (position)RSZPOSNINT44
MA_S_OBJCharacteristicRSCHANMCHAR60
MA_S_TYPSort: (K)ey, (T)ext, (V)alue (H)ierarchyRROSARTCHAR2
MA_S_DIRSort directionRROSDIRCHAR2
IS_EMPTYDisplay Values Not PostedRREMPTYCHAR2
MA_READ_MODERead Mode(F4) for Master Data Read ServicesRSMD_RS_READ_MODECHAR2
NL_READ_MODERead Mode(F4) for Master Data Read ServicesRSMD_RS_READ_MODECHAR2
HIER_DISDisaggregation for BudgetingRSZHIERDISCHAR2
INIVIEW_PRIORefresh Filter State with Query SettingsRSZINIVIEWPRIOCHAR2
.INCLUDERSZSTRMEMPROP0
NUM_SCALEStrMember: Scaling factor of a numberRRSCALECHAR2
NUM_PRECStrMember: Number of places after decimal point for outputRRPRECISIONCHAR2
EMPHASISEmphasize ElementRSZEMPHASISCHAR2
TCURBW: Unequivocal ID in room and time (numbers and letters)RSUNIIDC25CHAR50
TCURFLAGFlag for 'typing' an entryRSZTYPEFLAGNUMC2
CTTNMStrMember: Name of Currency Conversion TypeRRNUMBRCHAR20
SIGNINVStrMember: +/- sign changeRSZSIGNCHAR2
FORMULACOLLSNStrMember: Establishing Prf. Analysis with formula collisionRSZCALCULATIONCHAR2
HIDDENDo Not Display ElementRSZHIDDENCHAR2
STRMEM_PLEVELDim: Standardizing typeRRPLEVELCHAR2
STRMEM_CUMULDim: CumulateRRCUMULCHAR2
STRMEM_LAGGRLocal AggregationRRLAGGRNUMC4
NSUBRBooleanRS_BOOLCHAR2
PARENTUUID in compressed formSYSUUID_25CHAR50
DRILLSTATEStatus of a hierarchy node with respect to tree structureRRXDRILLSTATECHAR2
CONSTSELSelection independent of the drilldownRSZCONSTSELCHAR2
STRMEM_NOZEROQuery: Suppress zerosRRNOZEROCHAR2
LAGGR_DIRAxis DescriptionRSZAXISNUMC2
INPUTABLEElement is input-readyRSZINPUTABLECHAR2
LOCKElement is lock-relevantRSZLOCKCHAR2
TCURDATEFLAGFlag for 'typing' an entryRSZTYPEFLAGNUMC2
TCURDATEBW: Unequivocal ID in room and time (numbers and letters)RSUNIIDC25CHAR50
UOMNMName of Quantity Conversion TypeRSUOMNMCHAR20
TUOMFLAGFlag for 'typing' an entryRSZTYPEFLAGNUMC2
TUOMBW: Unequivocal ID in room and time (numbers and letters)RSUNIIDC25CHAR50
DRILLSTATE_EXECState of Hierarchy Node in Tree Structure (At Runtime)RRXDRILLST_EXECCHAR2
STRMEM_DISDisaggregation on TotalsRSZDISCHAR2
STRMEM_DISREFUUID Reference for Disaggregation on TotalsRSZDISREFCHAR50
S_TYPSort: (K)ey, (T)ext, (V)alue (H)ierarchyRROSARTCHAR2
S_OBJCharacteristicRSCHANMCHAR60
S_DIRSort directionRROSDIRCHAR2
HS_TYPSort: (K)ey, (T)ext, (V)alue (H)ierarchyRROSARTCHAR2
HS_OBJCharacteristicRSCHANMCHAR60
HS_DIRSort directionRROSDIRCHAR2
PROPVERSVersion Information for Default Value of PropertiesRSPROPVERSCHAR2
SWITCHIDID of Switch in Switch FrameworkSFW_SWITCHIDCHAR60
Privacy Policy