| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CUSTOMIZID | ID for Customizing in BW | nvarchar | 8 | 0 | CHAR | (N' ') | No | | RSCUSTOMIZID | Allow NULL? |
| 2 | SRCSYST_USER | User in source system for ALE communication | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RSSRCSYSTUSER | Allow NULL? |
| 3 | COL_NODATA | Traffic-light color in monitor if no data in source system | char | 1 | 0 | NUMC | (N'0') | Yes | | RSCOLNODATA | Allow NULL? |
| 4 | CHAR1000 | Thousand separator | char | 1 | 0 | CHAR | (N' ') | Yes | | RSTHOUSAND | Allow NULL? |
| 5 | DECIMALCHAR | Character for decimal point | char | 1 | 0 | CHAR | (N' ') | Yes | | RSDECIMAL | Allow NULL? |
| 6 | EXCEL_ESC | Field Delimiter for CSV Files | char | 1 | 0 | CHAR | (N' ') | Yes | | RSEXCEL_ESC | Allow NULL? |
| 7 | EXCEL_FIELDSEP | Field separator for csv files | char | 1 | 0 | CHAR | (N' ') | Yes | | RSEXCEL_FILESEP | Allow NULL? |
| 8 | CURR_CONV | Currency Conversion for External Systems | char | 1 | 0 | CHAR | (N' ') | Yes | | RSCURCONVERT | Allow NULL? |
| 9 | INFOIDOCFRQ | Frequency with which status Idocs are sent | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | RSIDOCFRQU | Allow NULL? |
| 10 | IDOCPACKSIZE | Number of Data Records per Package | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | RSIDOCPACSIZE | Allow NULL? |
| 11 | MONITIMEOUT | Wait.time until traf. light status is changed in the monitor | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | RSMONIOUT | Allow NULL? |
| 12 | RRXDATADIFF0 | Display value for dividing by zero | nvarchar | 73 | 0 | CHAR | (N' ') | Yes | | RRXDATADIFF0 | Allow NULL? |
| 13 | RRXDATANOTEXIST | Display value for cells with error | nvarchar | 73 | 0 | CHAR | (N' ') | Yes | | RRXDATANOTEXIST | Allow NULL? |
| 14 | RRXDATALARGE | Display value for numeric overflow | nvarchar | 73 | 0 | CHAR | (N' ') | Yes | | RRXDATALARGE | Allow NULL? |
| 15 | RRXDATAMIXCUR | Display value from various currencies/units or mixed values | nvarchar | 73 | 0 | CHAR | (N' ') | Yes | | RRXDATAMIXCUR | Allow NULL? |
| 16 | RRXSHOWMIXCURVAL | Display value of a cell with mixed currency | char | 1 | 0 | CHAR | (N' ') | Yes | | RRXSHOWMIXCURVAL | Allow NULL? |
| 17 | RRXDATANOAUTHOR | Display value for cells without authorization | nvarchar | 73 | 0 | CHAR | (N' ') | Yes | | RRXDATANOAUTHORITY | Allow NULL? |
| 18 | GANTT_MIN_LENGTH | Length of horizontal bar in Gantt chart | decimal | 15 | 0 | DEC | ((0)) | Yes | | RSGANTTLEN | |
| 19 | MERGE_APPL | Hierarchies: Merge with applications, yes/no | char | 1 | 0 | CHAR | (N' ') | Yes | | RSMERGEAPPL | Allow NULL? |
| 20 | MERGE_AREA | Hierarchies: Merge with InfoArea, yes/no | char | 1 | 0 | CHAR | (N' ') | Yes | | RSMERGEAREA | Allow NULL? |
| 21 | MERGE_IPG | Hierarchies: Merge with IPG, yes/no | char | 1 | 0 | CHAR | (N' ') | Yes | | RSMERGEIPG | Allow NULL? |
| 22 | MSGPOPUP | Message Long Text As Dialog Box | char | 1 | 0 | CHAR | (N' ') | Yes | | RSMSGPOPUP | Allow NULL? |
| 23 | MONITORASSI | Indicator for standard default starting of the wizard | char | 1 | 0 | CHAR | (N' ') | Yes | | RSMONIASSI | Allow NULL? |
| 24 | AUTOSID | Automatic MD ID entry when loading transaction data | char | 1 | 0 | CHAR | (N' ') | Yes | | RSAUTOSID | Allow NULL? |
| 25 | DELTALIMIT | Threshold Value (0-99): Delta -> Reconstruct Aggregates | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | RSDELTALIMIT | Allow NULL? |
| 26 | BLOCKSIZE | Block Size for Building Aggregate | int | 10 | 0 | INT4 | ((0)) | Yes | | RSBLOCKSIZE | Allow NULL? |
| 27 | CR_MAXWAIT | Wait Time for Change Run Lock (in Minutes) | int | 10 | 0 | INT4 | ((0)) | Yes | | RSDDSCR_MAXWAIT | Allow NULL? |
| 28 | LOCKCR | Reporting Lock on Change Run | char | 1 | 0 | CHAR | (N' ') | Yes | | RSDDSLOCKCR | Allow NULL? |
| 29 | MDMTBOOKMODE | Update method in master data maintenance | char | 1 | 0 | NUMC | (N'0') | Yes | | RSMDMTBOOKMODE | Allow NULL? |
| 30 | PSAPARTSIZE | Size of PSA Partition | int | 10 | 0 | INT4 | ((0)) | Yes | | RSPSAPARTSIZE | Allow NULL? |
| 31 | ITS | ITS Name for URLs Created by the Server for BW Web Reporting | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | RRW3_ITS | Allow NULL? |
| 32 | WEBSERVICE | ITS Service for BW Web Reporting URLs created by the server | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RRW3_WEBSERVICE | Allow NULL? |
| 33 | STYLE_SHEET | Style Sheet for Html Page Generation | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | RRW3_STYLE_SHEET | Allow NULL? |
| 34 | WBID | Workbook ID for the Standard Web Page | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | RRW3_WBID | Allow NULL? |
| 35 | PAGEID | Page Name of the Standard BW Web Template | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | RRW3_PAGEID | Allow NULL? |
| 36 | TMPLID | Name of the Web Template for Ad Hoc Analysis (SAP BW 3.x) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RRW3_TMPLID | Allow NULL? |
| 37 | PROPERTIESID | Name of Standard Template Properties (SAP BW 3.x) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RRW3_PROPERTIESID | Allow NULL? |
| 38 | PROTAWBSTART | Write Log to Application Log when DWB Starts | char | 1 | 0 | CHAR | (N' ') | Yes | | RSPROTABWSTART | Allow NULL? |
| 39 | SRVNAME | Data element for MD server name | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | RSDP_DTEL_SRVNAME | Allow NULL? |
| 40 | RFCOLAPDEST | RSDP:data tp encapsulating the rfc destination to work with | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | RSDP_DTEL_RFCOLAPDEST | Allow NULL? |
| 41 | MSASEXIST | RSDP: Data element for storing info if MS AS2000 can be used | char | 1 | 0 | CHAR | (N' ') | Yes | | RSDP_DTEL_MSASEXIST | Allow NULL? |
| 42 | TECHNAME | RSDP: Data element for technical names | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | RSDP_DTEL_TECHNAME | Allow NULL? |
| 43 | LOCALBORURL | D&R Links for BW Unifier | char | 1 | 0 | CHAR | (N' ') | Yes | | RSLOCALBORURL | Allow NULL? |
| 44 | WP3DEST | Destination of URL Gerneration Server | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | RSWP3DEST | Allow NULL? |
| 45 | COL_WARNING | Traffic Light Color in Monitor if Warnings Occurred | char | 1 | 0 | CHAR | (N' ') | Yes | | RSCOLWARNING | Allow NULL? |
| 46 | INACTIVE | Cross-transactional cache is deactivated | char | 1 | 0 | CHAR | (N' ') | Yes | | RSRCC_CACHE_INACTIVE | Allow NULL? |
| 47 | MAX_LCS_MB | Local Cache Size | int | 10 | 0 | INT4 | ((0)) | Yes | | RSRCC_LCS_MB | Allow NULL? |
| 48 | MAX_GCS_MB | Global Cache Size | int | 10 | 0 | INT4 | ((0)) | Yes | | RSRCC_GCS_MB | Allow NULL? |
| 49 | PERSISTMODE | Cache Persistence Mode | char | 1 | 0 | CHAR | (N' ') | Yes | | RSRPERSISTMODE | Allow NULL? |
| 50 | FILENAME | Flat File Name | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | * | RSRFILENAME | Allow NULL? |
| 51 | FILENAME_SPAN | Comprehensive Flat File Name for AppServer | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | * | RSRFILENAME_SPAN | Allow NULL? |
| 52 | LIMIT | Database Cache Limit | int | 10 | 0 | INT4 | ((0)) | Yes | | RSRCACHESIZE | Allow NULL? |
| 53 | CLUSTER_LIMIT | Size Limit for Clustering | int | 10 | 0 | INT4 | ((0)) | Yes | | RSRCACHECLUSTER | Allow NULL? |
| 54 | WEBPROTOCOL | Web Protocoll for BW Web Reporting URLs Created by Server | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RRW3_WEBPROTOCOL | Allow NULL? |
| 55 | MPRO_CHECK | Use MultiProvider Authorization Object (S_RS_MPRO) | char | 1 | 0 | CHAR | (N' ') | Yes | | RSSB_MPRO_CHECK | Allow NULL? |
| 56 | TCURF_FAKT | Indicator: Consider tcurf Ratios in Currency Conversion | char | 1 | 0 | CHAR | (N' ') | Yes | | RSTCURF_FAKT | Allow NULL? |
| 57 | MPRO_CHECK_QUERY | Use MultiProvider Authorization Object in Query | char | 1 | 0 | CHAR | (N' ') | Yes | | RSSB_MPRO_QUERY_CHECK | Allow NULL? |
| 58 | CUBE_CHECK_QUERY | Use Authorization Object InfoCube (Query) | char | 1 | 0 | CHAR | (N' ') | Yes | | RSSB_CUBE_QUERY_CHECK | Allow NULL? |
| 59 | DBC_BWSERVER | BW Application Server (as of 6.10) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | RSDBC_BWSERVER | Allow NULL? |
| 60 | DBC_PACKSIZE | Number of Data Records per Package for DB Connect | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | RSDBC_PACKSIZE | Allow NULL? |
| 61 | DBC_SHOWSIZE | Number of Data Records with Display Mode | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | RSDBC_SHOWSIZE | Allow NULL? |
| 62 | TMPLID_BROADCAST | Standard Web Template for Broadcasting (BW 3.5) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RSRA_TMPLID_BROADCASTER | Allow NULL? |
| 63 | TMPLID_QUERY_BR | Standard Web Template for Query Precalculation (BW 3.5) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RSRA_TMPLID_QUERY_BROADCAST | Allow NULL? |
| 64 | TMPLID_DOCUMENTS | Standard Web Template for Document Browser (SAP BW 3.x) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RSOD_TMPLID_DOCUMENT_BROWSER | Allow NULL? |
| 65 | ISETHUGEWHERE | InfoSet: Limit Value for Large Where Conditions | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | RSISETHUGEWHERE | Allow NULL? |
| 66 | HIER_ISRCMD | Hierarchies: Use Authorization Object S_RS_ISRCM | char | 1 | 0 | CHAR | (N' ') | Yes | | RSSB_HIER_ISRCMD_CHECK | Allow NULL? |
| 67 | EP50_MENU | Hide Menu 'Publish to Enterprise Portal 5.0' | char | 1 | 0 | CHAR | (N' ') | Yes | | RSPOR_EP50_MENU | Allow NULL? |
| 68 | PSA_REQUDEL | Check for Activity 06 during PSA Request Deletion | char | 1 | 0 | CHAR | (N' ') | Yes | | RSSB_PSA_REQUDEL_CHECK | Allow NULL? |
| 69 | TMPLID_BCAST | Standard Web Template for Broadcasting | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RSRD_TMPLID_BCAST | Allow NULL? |
| 70 | TMPLID_BCAST_QUE | Standard Web Template for Query Precalculation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RSRD_TMPLID_BCAST_QUERY | Allow NULL? |
| 71 | USE_NEW_REPAUTH | Analysis Authorization System | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | RSRAUTH | Allow NULL? |
| 72 | UOM_BUFF_SIZE | Quantity Conversion: Setting Buffer Size Int. Table | int | 10 | 0 | INT4 | ((0)) | Yes | | RSUOM_BUFF_SIZE | Allow NULL? |
| 73 | DB_STATISTICS | Let BW Generate Database Statistics | char | 1 | 0 | CHAR | (N' ') | Yes | | RSDD_CREATE_DB_STATISTICS | Allow NULL? |
| 74 | SPLT_QRY_TAB_THR | Threshold Value for Query Split | int | 10 | 0 | INT4 | ((0)) | Yes | | RSDD_SPLIT_QUERY_THRES | Allow NULL? |
| 75 | SPLT_DM_TAB_THR | Threshold for Splitting Data Mart Requests | int | 10 | 0 | INT4 | ((0)) | Yes | | RSDD_SPLIT_DATAMART_THRES | Allow NULL? |
| 76 | ORA_LOGGING | Deactivates NOLOGGING while Building Index | char | 1 | 0 | CHAR | (N' ') | Yes | | RSDD_ORA_LOGGING | Allow NULL? |
| 77 | ORA_PARALLEL_DEG | Degree of Parallelization dur. Aggregate and Index Building | int | 10 | 0 | INT4 | ((0)) | Yes | | RSDD_ORA_PARALLEL_DEGREE | Allow NULL? |
| 78 | RSER_TMPL_ID | Standard Template for Enterprise Reporting | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RSER_TMPL_ID | Allow NULL? |
| 79 | TMPLID_ANALYZER | Name of the Template for Ad Hoc Analysis | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RSWR_TMPLID_ANALYSIS | Allow NULL? |
| 80 | TEMPL_PARAM | Name of Standard Template Settings | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RSWR_TEMPL_PARAMETERS | Allow NULL? |
| 81 | TMPLID_BCAST70 | Standard Web Template for Broadcaster | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RSRD_TMPLID_BCAST70 | Allow NULL? |
| 82 | TMPLID_BCAST_Q70 | Standard Web Template for Query Precalculation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RSRD_TMPLID_BCAST_QUERY70 | Allow NULL? |
| 83 | BCAST_SUPP_FOOT | Broadcasting: Suppress Footer in E-mail | char | 1 | 0 | CHAR | (N' ') | Yes | | RSRD_SUPPRESS_FOOTER | Allow NULL? |
| 84 | BCAST_MAIL_EXP | Number of Days Until Send Requests Are Deleted | int | 10 | 0 | INT4 | ((0)) | Yes | | RSRD_MAIL_EXPIRATION | Allow NULL? |
| 85 | MHTML_AS_ATTACH | Send MHTML Documents by E-Mail As Attachments | char | 1 | 0 | CHAR | (N' ') | Yes | | RSRD_MHTML_AS_ATTACHEMENT | Allow NULL? |
| 86 | ER_STYLESHEET | Stylesheet for Exception Reporting (Path in MIME Repository) | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | RSRD_ER_STYLESHEET | Allow NULL? |
| 87 | TMPLID_BCAST_REP | Standard Web Template for Report Precalculation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RSRD_TMPLID_BCAST_REPORT | Allow NULL? |
| 88 | ANPR_SERV | Application Server for Batch Execution of Analysis Processes | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | RSAN_PR_SERV | Allow NULL? |
| 89 | ANPR_SERVTYPE | Type of Server | char | 1 | 0 | CHAR | (N' ') | Yes | | RSAN_PR_SERVTYPE | Allow NULL? |
| 90 | SOBI_RFC_DEST | RFC Destination for BW Model Generation | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | RSOBI_MF_RFCDEST | Allow NULL? |
| 91 | RSAWBN_HIDE_FUNC | Hide obsolete Functions of the Data Warehousing Workbench | char | 1 | 0 | CHAR | (N' ') | Yes | | RSAWBN_HIDE_OLD_FUNCTIONS | Allow NULL? |
| 92 | RRSITHRESHOLD | Threshold Value: Select Single -> Select for All Entries | int | 10 | 0 | INT4 | ((0)) | Yes | | RRSITHRESHOLD | Allow NULL? |
| 93 | ASYNCHR_DELETION | Asynchronous Deletion from Write-Optimized DataStores | char | 1 | 0 | CHAR | (N' ') | Yes | | RSODSO_ASYNC_DEL | Allow NULL? |
| 94 | RS2HANA_PACKAGE | | nvarchar | 500 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 95 | RS2HANA_ASSIGN_TYPE | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 96 | RS2HANA_DBMS_USER_MAPPING | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
