SAP table RSMONVIEW (BIW: View of RSMONIC)

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