SAP ABAP Table RSMDATASTATE_S (Structure for Data Status in InfoCubes)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-DST (Application Component) Data Staging
     ⤷ RSSM (Package) BW: General monitoring and scheduling

Basic Data

Table Category	INTTAB	Structure
Structure	RSMDATASTATE_S	Table Relationship Diagram
Short Description	Structure for Data Status in InfoCubes

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	INFOCUBE	☐	RSINFOCUBE	RSINFOCUBE	CHAR	30	0	InfoCube
2	TECHOK	☐	RSMTECHOK	RSSID	INT4	10	0	Request SID for which all requests are technically o.k.
3	QUALOK	☐	RSMQUALOK	RSSID	INT4	10	0	Request SID for which all requests checked for quality
4	ROLLUP	☐	RSMROLLUP	RSSID	INT4	10	0	Request SID, up to which all aggregates are rolled up
5	DMEXIST	☐	RSDMHIGH	RSSID	INT4	10	0	Upper limit for data mart delta request
6	DMALL	☐	RSDMLOW	RSSID	INT4	10	0	Lower limit for data mart delta request
7	TMSTMP_ROLLUP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
8	TMSTMP_QUALOK	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9	COMPR	☐	RSMCOMPR	RSSID	INT4	10	0	Request SID up to which InfoCube is to be compressed
10	AGGREXIST	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
11	CNSID	☐	RSMCNSID_LAST	RSDCNSID	INT4	10	0	MID of the last chnage run
12	.INCLUDE	☐				0	0	Status of the data in the Infocubes (Dual)
13	ROLLUP_RSVD_DUAL	☐	RSMROLLUP_RSVD	RSSID	INT4	10	0	Request SID, up to which aggregates are to be rolled up
14	COMPR_DUAL	☐	RSMCOMPR	RSSID	INT4	10	0	Request SID up to which InfoCube is to be compressed
15	.INCLUDE	☐				0	0	InfoCube: Data Flow/Status/Control
16	.INCLUDE	☐				0	0	InfoCube: BW Statistics
17	BWSTATISTICS	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
18	BWSTATWHM	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
19	.INCLUDE	☐				0	0	InfoCube: Request treatment
20	AUTOQUALOKFL	☐	RSMAUTOQUALOKFL	RSBOOL	CHAR	1	0	Set Quality Status to 'OK' Automatically
21	AUTOROLLUPFL	☐	RSMAUTOROLLUPFL	RSBOOL	CHAR	1	0	Roll up data in the aggregate automatically
22	AUTOCOMPRFL	☐	RSMAUTOCOMPRFL	RSBOOL	CHAR	1	0	Compress Automatically After Roll-Up (or After Load)
23	NOAUTOCMPAGGRFL	☐	RSMNOAUTOCMPRAGGRFL	RSBOOL	CHAR	1	0	Do not collapse aggregates automatically
24	.INCLUDE	☐				0	0	InfoCube: DB Performance Parameter
25	.INCLUDE	☐				0	0	InfoProvider: DB Performance Flags
26	CLEAR_INDEX	☐	RSBOOK3	CHAR1	CHAR	1	0	Delete index before each data load and then recreate
27	DELTA_INDEX	☐	RSBOOK4	CHAR1	CHAR	1	0	Delete index before each delta load and then recreate
28	REBUILD_STAT	☐			CHAR	1	0
29	DELTA_STAT	☐			CHAR	1	0
30	PERCENTAGE	☐			NUMC	3	0
31	NULLCOMP	☐	CDS_0_ELIM	RS_BOOL	CHAR	1	0	Zero elimination in the summarization module
32	COMP_DISJ	☐	RSCOMP_DISJ	XFELD	CHAR	1	0	Obsolete!! (Previously: Only Disjunct Records)
33	REFUPDATE	☐	CDS_REFUPDATE	RS_BOOL	CHAR	1	0	No update of the non-cumulative marker
34	DROP_INDX_ROLLUP	☐			CHAR	1	0
35	.INCLUDE	☐				0	0	Aggregate: Storage Parameter
36	ADIMSIZCAT	☐	RSADIMSIZCAT	TABKAT	CHAR	2	0	BW: Size Category for Aggregate Dimension Tables
37	ADIMDATCLS	☐	RSADIMDATCLS	TABART	CHAR	5	0	BW: Data class for aggregate dimension tables	*
38	AGGRSIZCAT	☐	RSAGGRSIZCAT	TABKAT	CHAR	2	0	BW: Size Category for Aggregate (Fact) Tables
39	AGGRDATCLS	☐	RSAGGRDATCLS	TABART	CHAR	5	0	BW: Default Data Class for Aggregate (Fact) Table	*
40	.INCLUDE	☐				0	0	InfoCube: Default Query Properties
41	QPROPVERS	☐	RSQPROPVERS	RSQPROPVERS	NUMC	2	0	Conversion Version Query Properties
42	READMODE	☐	RSRREADMODE	RSRREADMODE	CHAR	1	0	Read Mode
43	CACHEMODE	☐	RSRCACHEMODE	RSRCACHEMODE	CHAR	1	0	Cache Mode
44	CACHEDELAY	☐	RSRCACHEDELAY		INT4	10	0	Cache Validity Period in Seconds
45	NLREADMODE	☐	RSD_NLREADMODE	RSD_NLREADMODE	CHAR	1	0	Read Modus for Near-Line Storage
46	NOPARALLELQDEF	☐	RRSNOPARALLEL	RS_BOOL	CHAR	1	0	no parallel processing
47	KIDSEL	☐	RRKIDSEL	RS_BOOL	CHAR	1	0	Use Selection of Structure Elements
48	CACHEUSEREXIT	☐	RSRNOCACHEFL	RSBOOL	CHAR	1	0	Indicator: Do not Use Cache for this Report
49	NOHPA	☐	RRSNOHPA	RS_BOOL	CHAR	1	0	Obsolete Field (Do Not Use BWA Index)
50	TREXOPS	☐	RSRTREXOPS	RSRTREXOPS	CHAR	1	0	Operations in SAP HANA/BWA
51	MATERIALIZEQUERYLAYER	☐	RSRMATERIALIZEQUERYLAYER	RS_BOOL	CHAR	1	0	Materialize Intermediate Query Result
52	PACKFLQDEF	☐	RSDHIGHPRECFL	RS_BOOL	CHAR	1	0	Process key figure with high precision
53	HANAMODELFL	☐	RSMHANAMODEL	RSMHANAMODEL	CHAR	1	0	External SAP HANA view for BW object
54	SUPP_QUERY_W_DUPL_KYF	☐	SUPPORTS_KEYFIGURE_DUPLICATES	RS_BOOL	CHAR	1	0	Supp. queries w/ dupl. KYF which cont. diff. aggregations
55	CACHEUSAGEMODE	☐	RSRCACHEUSAGEMODE	RSRCACHEUSAGEMODE	CHAR	1	0	Cache Usage Mode
56	DATA_INTEGRITY_SCENARIO	☐	RSR_DATA_INTEGRITY_SCENARIO	RSR_DATA_INTEGRITY_SCENARIO	CHAR	1	0	Data Integrity Profile
57	.INCLUDE	☐				0	0	InfoCube: Aggregate Check Mode,..
58	AGGRAUTOCHECK	☐	RSDDAGGRCHECKMODE	RSDDAGGRCHECKMODE	CHAR	1	0	Check Mode for Aggregates ('A', 'Q' or 'C')
59	AGGRCHECKTIME	☐	RSDDAGGRCHECKTIME	CHAR10	CHAR	10	0	When Automatic Aggregate Check is Executed
60	DOUBLE_FACT	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
61	.INCLUDE	☐				0	0	Changelog Status for ODS Object
62	ODSOBJECT	☐	RSDODSOBJECT	RSDODSOBJECT	CHAR	30	0	DataStore Object	RSDODSO
63	DELTAINA	☐	RSDELTAINA	CHAR1	CHAR	1	0	DataMart delta update status
64	ACTIVE	☐	RSBACTIVE	RSSID	INT4	10	0	Max. Delta Slice in Change Log
65	PROCESSED_ALL	☐	RSBROLLUPALL	RSSID	INT4	10	0	Max. delta slice that was extracted by all receivers
66	PROCESSED_ONE	☐	RSBROLLUPONE	RSSID	INT4	10	0	Max. delta slice extracted until now
67	COMPR_ODS	☐	RSBCOMPR	RSSID	INT4	10	0	Delta slice up to which compression has taken place
68	ODSVERSION	☐	RSODSVERSION	NUMC3	NUMC	3	0	Active version of the Operational Data Store
69	.INCLUDE	☐				0	0	DataStore: Automation Flags
70	AUTOACTIVATEFL	☐	RSMAUTOACTIVATEFL	RSBOOL	CHAR	1	0	Activate DataStore Object Data Automatically
71	AUTOPROCESSFL	☐	RSMAUTOPROCESSFL	RSBOOL	CHAR	1	0	Update Data from DataStore Object Automatically
72	TLOGO	☐	RSTLOGO	RSTLOGO	CHAR	4	0	BW: Object Type (TLOGO)
73	IO_TYPE	☐	RSBWREQUTYPE	RSBWREQUTYPE	CHAR	1	0	Type of Requested Data - Also New DS Types
74	LOADALWD	☐	RSLOADALLOWED	CHAR1	CHAR	1	0	Allow loading for real-time data targets
75	COMPR_AGGR	☐	RSMCOMPR	RSSID	INT4	10	0	Request SID up to which InfoCube is to be compressed
76	VALID_TIMESTAMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
77	VALID_SID	☐	RSSID	RSSID	INT4	10	0	Master data ID
78	TIMDIM_INCON	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
79	ARCH_DONE	☐	RSARCH_DONE	RSSID	INT4	10	0	Lower Limit for Write-Only DSO Archiving
80	ARCH_TODO	☐	RSARCH_TODO	RSSID	INT4	10	0	Upper Limit for Write-Only DSO Archiving
81	ODS_TIME_CONS	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RSMDATASTATE_S	ODSOBJECT	RSDODSO	ODSOBJECT

History

Last changed by/on	SAP	20141013
SAP Release Created in