SAP Table RSMONVIEW

BIW: View of RSMONIC

RSMONVIEW (BIW: View of RSMONIC) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RSMONVIEW to other SAP tables.

Source: RSMONVIEW (BIW: View of RSMONIC)

RSMONVIEW table fields

Field Data element Checktable Datatype Length Decimals
RNR Request number for the data transfer RSREQUNR CHAR 30 0
RNRTYP RNR type (D-trans. data, T-texts, M-master data, H-hi) RNR_TYP CHAR 1 0
IDOCTYP IDOC type (I = Info, D = Data). IDOC_TYP CHAR 1 0
GNR Group number for scheduler-data request RS_GNUMBER CHAR 30 0
LOGDPID Logical InfoPackage variant (ID) RSLOGDPID CHAR 30 0
LOGGRID InfoPackage group RSLOGGRID CHAR 30 0
IOBJNM InfoObject RSIOBJNM CHAR 30 0
OBJVERS Object version RSOBJVERS CHAR 1 0
A Active
M Revised
N New
D Content
H Historic
T Transport
INFOPAKID Logical InfoPackage variant (ID) RSLOGDPID CHAR 30 0
ISOURCE InfoSource RSISOURCE CHAR 30 0
TYP InfoSource type RS_TYP CHAR 1 0
LOGSYS Source system RSSLOGSYS CHAR 10 0
QUELLE Single-Character Indicator CHAR1 CHAR 1 0
ZIEL Target(s) of the data from the scheduler job RSZIEL CHAR 2 0
0 ALE (BIWEXPRESS='X': InfoCubes or check tables)
1 PSA only
2 PSA and InfoCubes or check tables in parallel
3 PSA and then InfoCubes or check table
4 InfoCubes only
8 from PSA into InfoCubes or check table
FILLIDOC Single-Character Indicator CHAR1 CHAR 1 0
FIELDNAME Field name RSFNM CHAR 30 0
SELUPDIC InfoCube RSINFOCUBE CHAR 30 0
AGGRIC Single-Character Indicator CHAR1 CHAR 1 0
METAUPDIC Data handling type when updating the IC RSMETAUPDIC CHAR 1 0
1 Data is always updated in the ICs, even without master data
2 Only update the data with available master data in the ICs
3 Do not update data in ICs if master data is mising
UNAME User Name SYUNAME CHAR 12 0
VARIANT Variant RSVARIANT CHAR 12 0
EXPRESS Single-Character Indicator CHAR1 CHAR 1 0
BIWEXPRESS Single-Character Indicator CHAR1 CHAR 1 0
BATCH Indicates whether used in the background RSBATCH CHAR 1 0
UPDMODE Mode of data update (Full, Delta, etc.) RSUPDMODE CHAR 2 0
F Transfer of all requested data
D Transfer of the deltas since the last request
I Transfer of an opening balance for non-cumulative values
R Repetition of the transfer of a data packet
C Initialization of the delta transfer
TIMEDEPFL System Date SYDATUM DATS 8 0
TIMEDEPFLTO System Date SYDATUM DATS 8 0
JOBNAME Background job name BTCJOB CHAR 32 0
JOBCOUNT Job ID BTCJOBCNT CHAR 8 0
ERROR Error Indicator RSERROR CHAR 1 0
ERRCLASS Application Area ARBGB CHAR 20 0
ERRNR Message number MSGNR CHAR 3 0
AUFRUFER Caller RSCALLER CHAR 2 0
01 Start of the data request
02 End of the data request
09 Info IDoc (RQSTATE)
20 Start of Processing in BI
29 Data was written in the communication structure
30 Writing to PSA Started
32 Writing to PSA Finished
36 Reading from PSA Started
39 Reading from PSA Finished
50 Start of the transaction data update
51 Number of Data Targets to Be Updated
52 Update of the Data Target
55 Start of the aggregation
57 Notification of the update routine
58 Notification of the update routine
59 End of the aggregation
60 Insert/update in database for transaction data
61 Insert/update in database for texts
62 Insert/update in database for master data
63 Insert/update in database for hierarchies
66 Error when inserting/updating database for transaction data
70 End of Processing
80 Begin of Second Step for Master Data, Texts, Hierarchies
84 End of Intermediate Step for Hierarchies
89 End of Second Step for Master Data, Texts. Hierarchies
INFOCUBE InfoCube RSINFOCUBE CHAR 30 0
PART_ID Master data ID RSSID INT4 10 0
SIGN Selection criteria: SIGN RSSIGN CHAR 1 0
OPT Selection criteria: OPTION RSOPTION CHAR 2 0
LOW Selection criteria: From value RSLOW CHAR 45 0
HIGH Selection criteria: To value RSHIGH CHAR 45 0
VARTYP Variable selection type. RSVARTYP CHAR 1 0
0 Get yesterday
1 Get last week
2 Get last month
3 Get last quarter
4 Get last year
5 Free temporal selection (for as many fields as you like)
6 ABAP Routine
7 OLAP variable
NEXT_PER Selection criteria: From value RSLOW CHAR 45 0
ANZ_PER Number of periods per year RSANZPER CHAR 10 0
VON_BIS From-to validity indicator RSVONBIS CHAR 1 0
KENNZ_PER Indicator of period type with free time selection RSKENNFLG CHAR 1 0
0 Year-like period (ongoing)
1 Year/period-like
BEX_VARIABLE Name (ID) of a Report Variable RSZVNAM CHAR 30 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
DESCRIPTION Char 80 CHAR80 CHAR 80 0
DATUM Date DATUM DATS 8 0
UZEIT Time UZEIT TIMS 6 0
HIENM Customer-Defined Hierarchy Name RSHIECHAR CHAR 30 0
HIEVERS Hierarchy version RSVERSION CHAR 3 0
HIEDATETO Valid-to date RSDATETO DATS 8 0
HIEDATEFROM Valid-From Date RSDATEFROM DATS 8 0
HIECLASS Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
FREMDSYS External System RSFREMD CHAR 1 0
LOCATION Type of External System RSLOCATION CHAR 1 0
0 External data from application server
1 External data from client workstation
FILENAME File Name for External Data RSFILENM CHAR 128 0
FILETYP Type of External File RSFILETYP CHAR 1 0
1 File is ASCII file with CR as separator
2 File is Excel-CSV type
3 File is Excel native
FILESEP Separator for Excel format RSSEP RAW 2 0
ESC Escape Character for Excel File RSESC RAW 2 0
CHAR1000 Thousand separator RSTHOUSAND CHAR 1 0
DEZICHAR Character for decimal point RSDECIMAL CHAR 1 0
CURRCONV Currency Conversion for External Systems RSCURCONVERT CHAR 1 0
X Yes
NULL No
RFCFIELDNM Field name RSFIELDNM CHAR 30 0
RFCVALUE Value of Data Input for RFC of Third-Party Tool RS3RDVALUE CHAR 128 0
RFCUSER User name for logging on to 3rd party tool RS3RDUSER CHAR 32 0
TCPIP Single-Character Indicator CHAR1 CHAR 1 0
LASTDATE Date DATUM DATS 8 0
LASTTIME Time UZEIT TIMS 6 0
SELANZAHL Counter of the Info idoc RSINFONR CHAR 6 0
PRIMKEY No. of created key groups RSPRIMKEY CHAR 12 0
IDOCNUM IDoc number EDI_DOCNUM NUMC 16 0
RQSTATE Status of the data selection RSRQSTATE CHAR 1 0
0 Data request received
1 Data selection started
2 Data selection running
5 Error in data selection
6 Transfer structure obsolete, transfer rules regeneration
8 No data available, data selection ended
9 Data selection ended
RQRECORD Number of selected data records (absolute) RSRQRECORD NUMC 12 0
DATAPAKID Data packet number RSDATAPID NUMC 6 0
RQDRECORD Number of selected data records per data packet RSRQDRECRD NUMC 12 0
REQ_CONV Number of Selected Data Records (Absolute) RSNUMRECORD INT4 10 0
REQ_FORT Number of Selected Data Records (Absolute) RSNUMRECORD INT4 10 0
REQ_UPDATE Number of Selected Data Records (Absolute) RSNUMRECORD INT4 10 0
REQ_INSERT Number of Selected Data Records (Absolute) RSNUMRECORD INT4 10 0
REQ_ERROR Number of Selected Data Records (Absolute) RSNUMRECORD INT4 10 0
REQ_NOTUPD Number of Selected Data Records (Absolute) RSNUMRECORD INT4 10 0
ANZAHL1 Comment CHAR50 CHAR 50 0
ANZAHL2 Comment CHAR50 CHAR 50 0
ANZAHL3 Comment CHAR50 CHAR 50 0
ANZAHL4 Comment CHAR50 CHAR 50 0
ANZAHL5 Comment CHAR50 CHAR 50 0
ANZAHL6 Comment CHAR50 CHAR 50 0
MESSID1 Application Area ARBGB CHAR 20 0
TEXTNR1 Message number MSGNR CHAR 3 0
MESSID2 Application Area ARBGB CHAR 20 0
TEXTNR2 Message number MSGNR CHAR 3 0
MESSID3 Application Area ARBGB CHAR 20 0
TEXTNR3 Message number MSGNR CHAR 3 0
MESSID4 Application Area ARBGB CHAR 20 0
TEXTNR4 Message number MSGNR CHAR 3 0
MESS_ID Message ID RSMESS_ID NUMC 10 0
MSGNO Message Number SYMSGNO NUMC 3 0
MSGTY Message Type SYMSGTY CHAR 1 0
MSGID Message Class SYMSGID CHAR 20 0
MSGV1 Message Variable SYMSGV CHAR 50 0
MSGV2 Message Variable SYMSGV CHAR 50 0
MSGV3 Message Variable SYMSGV CHAR 50 0
MSGV4 Message Variable SYMSGV CHAR 50 0
TEXT Text, 40 Characters Long TEXT40 CHAR 40 0
LNR 10 digit number NUM10 NUMC 10 0
HIERACT Activate Hierarchies After Loading RSHIERACT NUMC 1 0
1
FUNCTION_NAME Function module name for checking ODS data RSFUNCCALL CHAR 30 0
CHECK_ODS Single-Character Indicator CHAR1 CHAR 1 0
ODSNAME Name of the Persistant Staging Area RSODSNAME CHAR 30 0
CHAVL_CHECK Single-Character Indicator CHAR1 CHAR 1 0
EVENT_ID_OK Background Processing Event BTCEVENTID CHAR 32 0
EVENT_PM_OK Background Event Parameters (Such as, Jobname/Jobcount) BTCEVTPARM CHAR 64 0
EVENT_ID_ER Background Processing Event BTCEVENTID CHAR 32 0
EVENT_PM_ER Background Event Parameters (Such as, Jobname/Jobcount) BTCEVTPARM CHAR 64 0
FUNCTION_CALL Single-Character Indicator CHAR1 CHAR 1 0
EXIT_CALL Single-Character Indicator CHAR1 CHAR 1 0
UPDATE_CUBE Single-Character Indicator CHAR1 CHAR 1 0
APPL_LOG Boolean RS_BOOL CHAR 1 0
NULL False
X True
OLTPSOURCE InfoSource RSISOURCE CHAR 30 0
WRITE_FLAT_OLTP Single-Character Indicator CHAR1 CHAR 1 0
CHANNEL Channel in the InfoCatalog RSCHANNEL CHAR 10 0
INIT_SIMU Delta process initialization simulation RSINITSIMU CHAR 1 0
NEW_HIENAME_ON Single-Character Indicator CHAR1 CHAR 1 0
NEW_HIENM Customer-Defined Hierarchy Name RSHIECHAR CHAR 30 0
ERROR_LOG Boolean RS_BOOL CHAR 1 0
NULL False
X True
CONTINUE_AT_ERR Single-Character Indicator CHAR1 CHAR 1 0
REPORT_AT_ERR Single-Character Indicator CHAR1 CHAR 1 0
NUMBER_AT_ERR No. of records to be checked when handling incorrect data RSNUMBER_AT_ERR INT4 10 0
IGNORELINES No. of lines to be ignored RSIGNORELINES NUMC 2 0
NOSISICO No single SID commit with master data update RSNOSISICO CHAR 1 0
X True
NULL False
HIESUBTREE Store Hierarchy as Subtree RSSUBTREEUPD CHAR 1 0
NULL No Subtree Update
X Add Subtree
U Update Subtree (Deletes Old Subtree)
BATCH_WAIT Single-Character Indicator CHAR1 CHAR 1 0
TIMEDEPFL_FLAG Flag controlling how time-dependency selections are handled RSTIMEDEPFL_FLAG CHAR 1 0
B BEx Variable
R Routine
NULL Fixed Value
TIMEDEPFL_VAR Name (ID) of a Report Variable RSZVNAM CHAR 30 0
TIMEDEPFL_PERIV Fiscal Year Variant PERIV CHAR 2 0
TIMEDEPFL_DESC Char 80 CHAR80 CHAR 80 0
NOAGGR Request is incorrect, if aggregation takes place RSSM_NOAGGR CHAR 1 0
NULL False
X True
OLTPTYP Type of Requested Data - Also New DS Types RSBWREQUTYPE CHAR 1 0
T Master data text (language dependent description)
H Hierachies
M Master Data Attributes
D Transaction Data
S Segmented DS
DUPREC Flag: DataSources poss. return duplicate data records RSDMDDUPREC CHAR 1 0
NULL False
X True
DUPRECDEL Flag: Handling of duplicate data records RSDMDDUPRECDEL CHAR 1 0
NULL False
X True
ARCHIVE_SEL Boolean RS_BOOL CHAR 1 0
NULL False
X True
DBCONNECT DB Connect Source System RSDBCONNECTFL CHAR 1 0
REPAIR_FULL Indicate Full Request as Repair Request RSREPAIRFULL CHAR 1 0
TIMEOUT Timeout Time RSTIMEOUT NUMC 8 0
WARNING Interpretation of Warnings RSWARNING CHAR 1 0
R Interpret Wanings as Errors (RED)
G Interpret Warnings as Successes (Green)
NULL Interpret Warnings as Successes (Green)
Y Warnings as Undecided (Yellow)
EARLY_DELTA Early Delta Possible RSEARLYDELTA CHAR 1 0
NULL false
X True
UNICODE_CODEPAGE SAP Character Set ID CPCODEPAGE NUMC 4 0
UNICODE_METHOD Unicode Entry Method RSUNICODE_METHOD CHAR 1 0
U User Definition
NULL Default = Standard
UNICODE_REPLACE Replacement Characters RSAC_FILE_REPLACE_CHAR CHAR 1 0
UNICODE_ENDIAN Endian RSAC_FILE_ENDIAN CHAR 1 0
B Big Endian
L Little Endian
NULL Application Server Endian
GENERATED Boolean RS_BOOL CHAR 1 0
NULL False
X True
CRT_PACKAGE Boolean RS_BOOL CHAR 1 0
NULL False
X True
CHAIN_LOG_ID Log-ID of a Process Chain Run RSPC_LOGID CHAR 25 0
HIER_DESC Long description RSTXTLG CHAR 60 0
HIER_ROUT Single-Character Indicator CHAR1 CHAR 1 0
HIER_AUTO Single-Character Indicator CHAR1 CHAR 1 0
SEL_1000 Indicates if more than 1000 values are allowed for a field RSSEL1000 CHAR 1 0
METADATA_SYNC Indicator to Synchronize BW Metdata during Loading RSMDATASYNC CHAR 1 0
NULL False
X True
NEW_DS Single-Character Indicator CHAR1 CHAR 1 0
NEW_DS_EXTRACTOR Access Method DataSource RSDSACCESS CHAR 10 0
NEW_DS_CONVERTER Access Method DataSource RSDSACCESS CHAR 10 0
DTP Data Transfer Process ID RSBKDTPNM CHAR 30 0
PUSH_PACKAGE Single-Character Indicator CHAR1 CHAR 1 0
PSA_SERIAL Single-Character Indicator CHAR1 CHAR 1 0
MASTERIPAK Logical InfoPackage variant (ID) RSLOGDPID CHAR 30 0
ISMASTERIPAK Single-Character Indicator CHAR1 CHAR 1 0
LPI Process Variant (Name) RSPC_VARIANT CHAR 30 0
LPI_CHAIN Process Chain RSPC_CHAIN CHAR 25 0
INITTODELTA Single-Character Indicator CHAR1 CHAR 1 0
NODATACOLOR Interpretation of Warnings RSWARNING CHAR 1 0
R Interpret Wanings as Errors (RED)
G Interpret Warnings as Successes (Green)
NULL Interpret Warnings as Successes (Green)
Y Warnings as Undecided (Yellow)
ONLY_TO_INDX Only Store Data in Cluster Table for Data Flow Comparison RS_ONLY_INDX CHAR 1 0
X Only Store Data in Cluster Table for Data Flow Comparison
NULL Post to Data Targets as Previously
BO_LOADER Maximum connections (number of loaders) RSBOBJDS_LOADERS NUMC 2 0