SAP table RSDMD_S_FILTER_CHAVLS (Filter for Characteristic Values)

Field Description Data Type Length Decimals Checktable Data Element
S_VIOBJ STRU 0 0 RSD_S_VIOBJ
IOBJNM InfoObject CHAR 30 0 RSDIOBJNM
OBJVERS Object version CHAR 1 0 RSOBJVERS
A Active
D Content
H Historic
M Revised
N New
T Transport
IOBJTP Type of an InfoObject CHAR 3 0 RSIOBJTP
CHA Characteristic
DPA Data packet characteristic
KYF Key figure
TIM Time characteristic
UNI Unit of measurement
XXL XXL InfoObject
OBJSTAT Object Status CHAR 3 0 RSOBJSTAT
ACT Active, executable
INA Inactive, not executable
OFF Switched off
PRO Production
PROTECFL Checkbox CHAR 1 0 XFELD
No
X Yes
PRIVATEFL InfoObject is Private CHAR 1 0 RSPRIVATEFL
ACTIVFL Active and revised version do not agree CHAR 1 0 RSACTIVFL
FIELDNM Field Name InfoObject In Structures (Not in database table) CHAR 30 0 RSDIOBJFIELDNM
CONTREL Content release CHAR 6 0 RSCONTREL
CONTTIMESTMP Content time stamp: Last modification to the object by SAP DEC 15 0 RSCONTTIMESTMP
ATRONLYFL InfoObject is Exclusively an Attribute (Not Used in ICs) CHAR 1 0 RSATRONLYFL
BCTCOMP Obsolete - do not translate CHAR 10 0 RSDBCTCOMP
OWNER Owner (Person Responsible) CHAR 12 0 RSOWNER
BWAPPL BW Application (Namespace) CHAR 10 0 RSBWAPPL
BDSFL Characteristic is allowed as attribute of documents CHAR 1 0 RSDDOCFL
TSTPNM Last Changed By CHAR 12 0 RSTSTPNM
TIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 RSTIMESTMP
ORIGIN Origin of Object CHAR 1 0 RSDORIGIN
Default
E Extensibility
MTINFOAREA BW-MT InfoObject: InfoArea CHAR 30 0 RSBWMTINFOAREA
LANGU Language Key LANG 1 0 LANGU
TXTSH Short description CHAR 20 0 RSTXTSH
TXTLG Long description CHAR 60 0 RSTXTLG
TXTSH_SET Short Text is Maintained CHAR 1 0 RSDTXTSHSET
Not maintained
X Maintained
CHABASNM Reference InfoObject CHAR 30 0 RSDCHABASNM
BCHREFFL Characteristic references another basic characteristic(flag) CHAR 1 0 RSBCHREFFL
CHATP Characteristc Type Based on Master Data Access CHAR 3 0 RSCHATP
FIX Own Implementation
GEN Default
REM Direct Access
CMPSTA Compound status CHAR 1 0 RSCMPSTA
Not compounded
1 Only compounded with constants
2 Normally compounded (not just with constants)
CMPOFFSET 4 Byte Signed Integer INT4 10 0 INT4
CHACONST Characteristic Constant SSTR 1333 0 RSCHACONST
AUTHRELFL Characteristic is relevant for authorization check CHAR 1 0 RSDAUTHRELFL
AUTHFIELD Authorization Field for Reporting Authorizations CHAR 10 0 RSDAUTHFIELD
ODSFL InfoObject is an ODS InfoObject (Flag) CHAR 1 0 RSDODSFL
CHAPRSNT Display for Characteristics and Units CHAR 1 0 RSCHAPRSNT
0 Key and Text
1 Text
2 Key
3 Text and Key
4 Long Text
5 Medium-Length Text
6 No Display
7 Short Text
B Text and Key as Short Text
C Text and Key as Medium Text
D Text and Key as Long Text
E Key and Text as Short Text
F Key and Text as Medium Text
G Key and Text as Long Text
CHANAV Navigation Indicator for Characteristics and Units CHAR 1 0 RSCHANAV
Not assigned
0 Permitted for navigation without restriction
1 Must be selected for navigation
2 Not permitted for navigation (no drilldown possible)
CHASEL Selection restriction for characteristics CHAR 1 0 RSCHASEL
0 No Selection Restriction
1 Only Single Values and Intervals
2 Unique for Every Cell
3 Single Values or Nodes Only
4 Not Allowed
5 Unique for Query
TXTDEF Business Explorer Description CHAR 1 0 RSTXTDEF
Short description
1 Long description
F4PRSNT Representation of Filter Values During Query Execution CHAR 1 0 RSF4PRSNT
Selector Box Without Values
0 Selector Box with Values
1 Input Field Only
2 Input Field with Input Help
3 Radio Button
4 Dropdown Box
5 Combo Box
6 Input Help Only
7 Checkboxes
SUPPRESS_INITIAL_VALUE Suppression Of Initial Values in Value Help CHAR 1 0 RSD_SUPPRESS_INITIAL_VALUE
DISPLAY_OF_INITIAL Display of Initial Values CHAR 1 0 RSD_DISPLAY_OF_INITIAL
Display Initial As '#'
O Display Initial as Type Complaint Initial Values
GISTP Geographical type for a characteristic NUMC 1 0 RSGISTP
0 No geo-characteristic
1 Static geo-characteristic
2 Dynamic geo-characteristic
3 Dynamic geo-characteristic with values from attribute
4 Static geo-characteristic with geo-attributes
GISATTRINM Geographical attribute CHAR 30 0 RSGISATTRINM
INFOAREA InfoArea CHAR 30 0 RSINFOAREA
APPLNM Application Component CHAR 30 0 RSAPPLNM
BOR_OBJTYP Object Type CHAR 10 0 SWO_OBJTYP
MDRCLNM Name of Master Data Read Class CHAR 30 0 RSMDCLNM
MDRCLPA Parameters for Master Data Read Class CHAR 100 0 RSMDRCLPA
NOVALFL Characteristic does not have a check table CHAR 1 0 RSNOVALFL
HIGH_CARDINALITY Characteristic with high cardinality (more than 2 mio recs.) NUMC 1 0 RSDHIGH_CARD_CHA
0 Without high cardinality
1 With high cardinality
RDAFL Permitted for RDA Process CHAR 1 0 RSDRDAFL
F4DEFAULT Selection of Filter Values for Query Definition CHAR 1 0 RSF4DEFAULT
D Only Values in InfoProvider
M Values in Master Data Table
F4QUERYEXEC Selection of Filter Values for Query Execution CHAR 1 0 RSF4QUERYEXEC
D Only Values in InfoProvider
M Values in Master Data Table
Q Only Posted Values for Navigation
ATTRIBFL Attributes (flag) exist for the characteristic CHAR 1 0 RSATTRIBFL
TIMDEPFL Flag: Master data is time-dependent CHAR 1 0 RSTIMDEPFL
KEYSORTEXT The key is sorted according to the external format (flag) CHAR 1 0 RSDKEYSOREXT
MASTAUTHFL Maintenance of master data is relevant for authorization CHAR 1 0 RSDMASTAUTHFL
EXPDSOURCEFL The characteristic is used as export data source CHAR 1 0 RSEXPDSOURCEFL
CHECKODS DataStore Object for Checking Characteristic Values CHAR 30 0 RSDCHECKODS
TXTTABFL Text Table Exists CHAR 1 0 RSDTXTTABFL
TXTTIMFL Texts are time-dep. CHAR 1 0 RSDTXTTIMFL
NOLANGU Master data texts are language independent (flag) CHAR 1 0 RSNOLANGU
TXTSHFL Short text exists (flag) CHAR 1 0 RSTXTSHFL
TXTMDFL Medium length text exists (flag) CHAR 1 0 RSTXTMDFL
TXTLGFL Long text exists (flag) CHAR 1 0 RSTXTLGFL
TXTXLFL The long text is extra long (String) CHAR 1 0 RSTXTXLFL
IOBJROUTFL InfoObject has Conversion Routine (Eclipse BW-MT) CHAR 1 0 RSDIOBJROUTFL
IOBJROUT Global transfer routine for InfoObjects CHAR 25 0 RSIOBJROUT
DBROUTID ID for database routines for basic char. CHAR 25 0 RSDBROUTID
ACTPROGID ID for database routines for basic char. CHAR 25 0 RSDBROUTID
ROLLBACKPROGID ID for database routines for basic char. CHAR 25 0 RSDBROUTID
NUMBRANR Number of the number range object of a characteristic CHAR 7 0 RSNUMBRANR
CNVSTATE See docu for conversion status CHAR 2 0 RSDCNVSTATE
TREXFL Characteristic Uses TREX Search CHAR 1 0 RSTREXFL
SIDCONVERT Conversion type for SID CHAR 1 0 RSDSIDCONVERT
E Conversion into a form with names SID_EXIT_iobjnm
T Conversion using table
V MID same as characteristic value
SIDMONFL Flag indicating whether SID retains the order CHAR 1 0 RSDSIDMONFL
HIETABFL Characteristic with hierarchies CHAR 1 0 RSHIETABFL
HIEVERFL Hierarchies can have multiple versions CHAR 1 0 RSHIEVERFL
HIENMTFL Entire hierarchy is time-dependent CHAR 1 0 RSDHIENMTFL
HIENDTFL Hierarchy structure is time-dependent CHAR 1 0 RSHIENDTFL
HIEINTFL Intervals permitted in hierarchy CHAR 1 0 RSHIEINTFL
HIESIGNCH Reverse Sign for Hierarchy Nodes CHAR 1 0 RSSHSIGNCH
No Reverse of Sign for Hierarchy Nodes
X Reverse of Sign Possible for Hierarchy Nodes
HIETJOINFL Use Temporal Hierarchy Join CHAR 1 0 RSHIETJOINFL
HIETP Type of Characteristic Related to Hierarchy CHAR 3 0 RSHIETP
FIX Own Implementation
GEN Standard
HIECLNM Name of Remote Hierarchy CHAR 30 0 RSHIECLNM
HIECLPA Parameters for Remote Hierarchy Class CHAR 100 0 RSHIECLPA
IOBJSIZCAT BW: Size category for InfoObject tables (master data/hier.) CHAR 2 0 RSIOBJSIZCAT
IOBJDATCLS BW: Data class for InfoObject tables(master data/ hierarch.) CHAR 5 0 RSIOBJDATCLS
UOMCONV Base Unit of Measure CHAR 30 0 RSUOMCONV
UOMCONVODS Quantity ODS: Units of Measure for InfoObject CHAR 30 0 RSUOMCONVODS
UOMCONVODSDESC BW-MT InfoObject: Description of UOM ODS CHAR 60 0 RSUOMCONVODSDESC
UOMCONVODSAREA BW-MT InfoObject: InfoArea of UOM ODS CHAR 30 0 RSUOMCONVODSAREA
UOMCONVODSSTATE BW-MT InfoObject: Status of UOM ODS CHAR 1 0 RSUOMCONVODSSTATE
D Disabled
E Enabled
IOBJ_HANAMODEL External SAP HANA view for BW object CHAR 1 0 RSMHANAMODEL
No external SAP HANA view
E External SAP HANA views for reporting and master data
I External SAP HANA view for master data
X External SAP HANA view for reporting
SUPPORTS_XXL_ATTRIBUTES Characteristic Supports XXL Attributes CHAR 1 0 RSDSUPPXXLATTR
Characteristic does not support XXL attributes
X Characteristic supports XXL attributes
MIME_TYPE MIME Content Type CHAR 100 0 SDOK_CNTTY
BWSTATISTICS Boolean CHAR 1 0 RS_BOOL
False
X True
BWSTATWHM Boolean CHAR 1 0 RS_BOOL
False
X True
QPROPVERS Conversion Version Query Properties NUMC 2 0 RSQPROPVERS
00 3.X /7.0 to SP12
01 7.0 SP13
02 7.20 SP1
READMODE Read Mode CHAR 1 0 RSRREADMODE
A Query to read all data at once
H Query to read when you navigate or expand hierarchies
X Query to read data during navigation
CACHEMODE Query Cache Mode CHAR 1 0 RSRCACHEMODE
0 Local cache
D Cache in database
I Cache is inactive
P Every provider as set up in provider definition
CACHEDELAY Cache Validity Period in Seconds INT4 10 0 RSRCACHEDELAY
NLREADMODE Read Mode for Near-Line Storage CHAR 1 0 RSD_NLREADMODE
Do not read near-line storage (default)
N Near-line access not allowed or not possible
P Near-line access setting same as for PartProvider
X Read near-line storage
NOPARALLELQDEF No Parallel Processing CHAR 1 0 RRSNOPARALLEL
KIDSEL Use Selection of Structure Elements CHAR 1 0 RRKIDSEL
CACHEUSEREXIT Flag: Do not use cache for this report CHAR 1 0 RSRNOCACHEFL
NOHPA Obsolete Field (Do Not Use BWA Index) CHAR 1 0 RRSNOHPA
TREXOPS Operations in SAP HANA/BWA CHAR 1 0 RSRTREXOPS
0 No optimized operations in SAP HANA/no BWA
2 Individual access per InfoProvider
3 Optimized access
6 Exception aggregation
7 Formulas calculated in SAP HANA
8 Formulas calculated in SAP HANA with complex currency/unit
9 Conditions calculated in SAP HANA
MATERIALIZEQUERYLAYER Materialize Intermediate Query Result CHAR 1 0 RSRMATERIALIZEQUERYLAYER
No
M Yes, in case data is read for multiple subtotal levels
X Yes
PACKFLQDEF Process Key Figure with High Precision CHAR 1 0 RSDHIGHPRECFL
HANAMODELFL External SAP HANA view for BW object CHAR 1 0 RSMHANAMODEL
No external SAP HANA view
E External SAP HANA views for reporting and master data
I External SAP HANA view for master data
X External SAP HANA view for reporting
SUPP_QUERY_W_DUPL_KYF Supp. queries w/ dupl. KYF which cont. diff. aggregations CHAR 1 0 SUPPORTS_KEYFIGURE_DUPLICATES
CACHEUSAGEMODE Cache Usage Mode CHAR 1 0 RSRCACHEUSAGEMODE
Data from query start if possible, otherwise current data
C Always display current data
P As specified in partprovider settings
S Always display data from query start (stable data)
DATA_INTEGRITY_SCENARIO Data Integrity Profile CHAR 1 0 RSR_DATA_INTEGRITY_SCENARIO
Default: No profile (expert settings are used)
C Consistent current data
D Dirty data - no caching
G Guaranteed stable data from query start
M Most current data
P Provider specific: transactional providers with current data
S Data from query start
READ_CHILD_KIDS Also Read the Child Members with Hierarchy Structure Node CHAR 1 0 RR_READ_CHILD_KIDS
AUTOREFRESH Refresh Automatically after Deletion of Request CHAR 1 0 RSRAUTOREFRESH
FORCE_DB_PUSHDOWN Force Access via CalculationScenario NUMC 1 0 RSR_FORCE_DB_PUSHDOWN
0 Off
2 On if CalculationScenario already used
4 On
IS_UUID Characteristic Is UUID CHAR 1 0 RSDUUIDFL
UUID_EXT External Key of UUID CHAR 30 0 RSDUUIDEXT
FILTER_MODE Use of a Characteristic in Filter and / or Result Set CHAR 1 0 RSDFILTERMODE
Characteristic can be used in filter and in result set
F Characteristic can only be used in filter
R Characteristic can only be used in result set
EQ_FILTER_ONLY Characteristic Only Supports Equal Filter CHAR 1 0 RSDEQFILTERONLY
NOINFOPROVFL Characteristic is no InfoProvider (Inverted logic) CHAR 1 0 RSDDTAINFOPROVFL
SORTINITIALKEYFL Include initial value in sorting sequence CHAR 1 0 RSDSORTINITIALKEYFL
DIFFERS_FROM_BAS Characteristic differs from basic characteristic CHAR 1 0 RSDDIFFFROMBASIC
ENHANCED_MD_UPDATE Characteristic Uses Enhanced Master Data Update CHAR 1 0 RSDMDUPDATEENH
0 Does not use enhanced master data update
1 Uses enhanced master data update
SNUMC_SEMANTIC SNUMC Semantic CHAR 4 0 RSDSNUMCSEMANTIC
DEC DEC
INT4 INT4
INT8 INT8
NO_COLUMNVIEW No Column View Generation in Steampunk systems CHAR 1 0 RSD_NO_COLUMNVIEW
DATATP Data Type in ABAP Dictionary CHAR 4 0 DATATYPE_D
INTLEN Internal Length of InfoObjects in BW - see Docu NUMC 6 0 RSDINTLEN
OUTPUTLEN Output Length NUMC 6 0 OUTPUTLEN
CONVEXIT Conversion Routine CHAR 5 0 CONVEXIT
FVALEX Domain fixed values exist (flag) CHAR 1 0 RSFVALEX
LOWERCASE Lowercase letters allowed/not allowed CHAR 1 0 LOWERCASE
KYFTP Key figure type CHAR 3 0 RSKYFTP
AMO Amount
DAT Date
FLO Floating point number (without unit)
INT Whole number
NUM Number (without unit)
QUA Quantity
TIM Time
NCUMFL Non-cumulative value (flag) CHAR 1 0 RSNCUMFL
Cumulative value
1 Stock with change involving stocks
2 Stock with inward and outward movement
FIXCUKY Fixed currency CUKY 5 0 RSFIXCUKY
FIXUNIT Fixed Unit of Measure UNIT 3 0 RSFIXUNIT
AGGRGEN Usual Aggregation CHAR 3 0 RSDAGGRGEN
MAX Maximum
MIN Minimum
NO1 No Longer Used
NO2 No Longer Used
NOP No Longer Used
SUM Summation
AGGREXC Exception Aggregation CHAR 3 0 RSDAGGREXC
AV0 Average (Values Not Equal to Zero)
AV1 Average (Weighted with Number of Days)
AV2 Average (Weighted with No. of Working Days; Factory Calcul.)
AVG Average (All Values)
CN0 Counter (Values Unequal to Zero )
CNT Counter (All Values)
FIR First Value
LAS Last Value
MAX Maximum
MED Median
MIN Minimum
NGA No Aggregation of Postable Nodes Along Hierarchy
NHA No Aggregation Along Hierarchy
NO1 No Aggregation (X, If More Than One Record Occurs)
NO2 No Aggregation (X, If More Than One Value Occurs)
NOP No Aggregation (X, If More Than One Value Uneq. to 0 Occurs)
SLC Simple Linear Regression: Correlation Coefficient
SLI Simple Linear Regression: Y-Intercept
SLS Simple Linear Regression: Slope
STD Standard Deviation
SUM Summation
VAR Variance
AGGRCHA Reference characteristic for exception aggregation CHAR 30 0 RSAGGRCHA
KYFDECIM Decimal places (of a key figure) CHAR 1 0 RSKYFDECIM
Not defined
0 0
1 0.0
2 0.00
3 0.000
4 0.0000
5 0.00000
6 0.000000
7 0.0000000
8 0.00000000
9 0.000000000
KYFPRSNT Display (of a key figure) CHAR 1 0 RSKYFPRSNT
Not defined
0 in 1
1 in 10
2 in 100
3 in 1,000
4 in 10,000
5 in 100,000
6 in 1,000,000
7 in 10,000,000
8 in 100,000,000
9 in 1,000,000,000
KYFNAV Navigation indicator for key figures CHAR 1 0 RSKYFNAV
Not assigned
0 Permitted without restrictions
1 Must be selected
2 Not allowed
UNINM Unit InfoObject (currency/unit) CHAR 30 0 RSUNINM
DOMANM Domain name CHAR 30 0 DOMNAME
PACKFL Process Key Figure with High Precision CHAR 1 0 RSDHIGHPRECFL
KYFSEMANTIC Semantic of a Key Figure CHAR 1 0 RSDKYFSEMANTIC
Standard Keyfigure
S Stock Cover Keyfigure
STOCK_COVER_CALCTYPE Type of Stock used by Stock Coverage Calculation CHAR 1 0 RSDSTOCK_COVER_CALCTYPE
No Stock Cover Key Figure
B Begin
D Derived from Referenced Key Figure
E End
STOCK_COVER_PERIODS Number of Stock Cover Periods to be calculated INT4 10 0 RSDSTOCK_COVER_PERIODS
ICEFL Boolean CHAR 1 0 RS_BOOL
False
X True
CHKTAB Table Name CHAR 30 0 TABNAME
UNITP Unit type CHAR 3 0 RSUNITP
CUR Currency
UNI Units of measure
MARK Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') CHAR 1 0 BOOLE_D
BCT_DEVCLASS Package CHAR 30 0 DEVCLASS
OBN_SYS_ALIAS System Alias for OBN CHAR 10 0 RSDSYSALIAS
T_NAIP TTYP 0 0 RSD_T_NAIP
T_ICE TTYP 0 0 RSD_T_ICE
T_HIECHA TTYP 0 0 RSD_T_HIECHA
T_AGGR TTYP 0 0 RSD_T_AGGR
CB_DATA_INTEGRITY_SCENARIO Boolean CHAR 1 0 RS_BOOL
False
X True
CB_READMODE Boolean CHAR 1 0 RS_BOOL
False
X True
CB_ACTUALDATA Boolean CHAR 1 0 RS_BOOL
False
X True
CB_NLREADMODE Boolean CHAR 1 0 RS_BOOL
False
X True
CB_CACHEMODE Boolean CHAR 1 0 RS_BOOL
False
X True
CB_DELTACACHE Boolean CHAR 1 0 RS_BOOL
False
X True
CB_PARTITIONMODE Boolean CHAR 1 0 RS_BOOL
False
X True
CB_TREXOPS Boolean CHAR 1 0 RS_BOOL
False
X True
CB_MATERIALIZEQUERYLAYER Boolean CHAR 1 0 RS_BOOL
False
X True
CB_KIDSEL Boolean CHAR 1 0 RS_BOOL
False
X True
CB_PACKFLQDEF Boolean CHAR 1 0 RS_BOOL
False
X True
CB_NOPARALLELQDEF Boolean CHAR 1 0 RS_BOOL
False
X True
CB_CACHEUSEREXIT Boolean CHAR 1 0 RS_BOOL
False
X True
CB_CACHEDELAY Boolean CHAR 1 0 RS_BOOL
False
X True
CB_CACHEUSAGEMODE Boolean CHAR 1 0 RS_BOOL
False
X True
CB_AUTOREFRESH Boolean CHAR 1 0 RS_BOOL
False
X True
R_FILTER Filter for characteristic values REF 0 0 RSFILTERCHAVLS