SAP ABAP Table RSD_S_DTA (Properties InfoProvider)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-MTD (Application Component) Metadata (Repository)
     ⤷ RSD (Package) BW: Data Basis InfoObjects and Core Services

Basic Data

Table Category	INTTAB	Structure
Structure	RSD_S_DTA	Table Relationship Diagram
Short Description	Properties InfoProvider

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	INFOPROV	☐	RSINFOPROV	RSINFOPROV	CHAR	30	0	InfoProvider
2	TLOGO	☐	RSTLOGO	RSTLOGO	CHAR	4	0	BW: Object Type (TLOGO)
3	IO_TYPE	☐	RSREQUTYPE	RSREQUTYPE	CHAR	1	0	Type of requested data
4	IS_TRANSIENT	☐	RSD_IS_TRANSIENT	XFLAG	CHAR	1	0	Property: Is transient (InfoProvider, InfoObject)
5	CONTAINS_TRANSIENT	☐	RSDCONTAINS_TRANS	RSBOOL	CHAR	1	0	InfoProvider Contains Transient Objects
6	DMPROVTYPE	☐	RSDDMPROVTYPE	RSTLOGO	CHAR	4	0	Data Manager: Provider Type
7	.INCLUDE	☐				0	0	InfoProvider: Attributes
8	.INCLUDE	☐				0	0	InfoProvider: General Attributes
9	OBJVERS	☐	RSOBJVERS	RSOBJVERS	CHAR	1	0	Object version
10	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	*
11	TXTLG	☐	RSTXTLG	TEXT60	CHAR	60	0	Long description
12	TXTSH	☐	RSTXTSH	TEXT20	CHAR	20	0	Short description
13	.INCLUDE	☐				0	0	Properties TLOGO object (available in A and M versions)
14	.INCLUDE	☐				0	0	Properties TLOGO object (only available in A version)
15	OBJSTAT	☐	RSOBJSTAT	RSOBJSTAT	CHAR	3	0	Object Status
16	CONTREL	☐	RSCONTREL	CHAR6	CHAR	6	0	Content release
17	CONTTIMESTMP	☐	RSCONTTIMESTMP	TZNTSTMPS	DEC	15	0	Content time stamp: Last modification to the object by SAP
18	OWNER	☐	RSOWNER	XUBNAME	CHAR	12	0	Owner (Person Responsible)	*
19	BWAPPL	☐	RSBWAPPL		CHAR	10	0	BW Application (Namespace)
20	ACTIVFL	☐	RSACTIVFL	XFELD	CHAR	1	0	Active and revised version do not agree
21	PROTECFL	☐	RSPROTECFL	X	CHAR	1	0	Flag: Protected InfoObject, no changes allowed
22	INFOAREA	☐	RSINFOAREA	RSINFOAREA	CHAR	30	0	InfoArea	*
23	NCUMTIM	☐	RSNCUMTIM	RSIOBJNM	CHAR	30	0	Ref. Time-Char. for Non-cums
24	BCTCOMP	☐	RSDBCTCOMP		CHAR	10	0	Obsolete - do not translate
25	WIPROGID	☐	RSWIPROGID	RSUNIIDC25	CHAR	25	0	ID for generated InfoCube write program
26	SUPERPROV	☐	RSSUPERPROV	RSINFOPROV	CHAR	30	0	Higher-Level InfoProvider
27	SUPERTLOGO	☐	RSSUPERTLOGO	RSTLOGO	CHAR	4	0	TLOGO Type of Higher-Level Provider
28	.INCLUDE	☐				0	0	InfoProvider: Type Attribute
29	CUBETYPE	☐	RSCUBETYPE	RSCUBETYPE	CHAR	1	0	InfoProvider Type
30	CUBESUBTYPE	☐	RSCUBESUBTYPE	RSCUBESUBTYPE	CHAR	1	0	InfoProvider Subtype
31	.INCLUDE	☐				0	0	Generic Remote InfoCube: Settings
32	SVRESTR	☐	RSCUBESVRESTR	RSD_XFELD_EXT	CHAR	1	0	Obsolete Option! (Convert Restrictions (InfoProvider))
33	SVRESTRNO	☐	RSCUBESVRESTRNO	XFELD	CHAR	1	0	No Support of Selection Conditions
34	SVRESTRGLOBAL	☐	RSCUBESVRESTRGLOBAL	XFELD	CHAR	1	0	Only Global Selection Conditions
35	SVRESTRSEL	☐	RSCUBESVRESTRSEL	RSD_XFELD_EXT	CHAR	1	0	Obsolete Option! (Simplify Selections (InfoProvider))
36	SVSUPPHIER	☐	RSCUBESVSUPPHIER	XFELD	CHAR	1	0	Supports Hierarchies
37	SVSUPPACDA	☐	RSCUBESVSUPPACDA	XFELD	CHAR	1	0	Supports Data Integrity in Provider Implementation
38	NOTRANSFRESTR	☐	RSNOTRANSFRESTR	XFELD	CHAR	1	0	Do Not Transform Selection Conditions
39	SVRESTRHIER	☐	RSCUBESVRESTRHIER	RSD_XFELD_EXT	CHAR	1	0	Obsolete Option! (Expand Hier. Restrictions (InfoProvider))
40	SVRFCPACK	☐	RSCUBESVRFCPACK	XFELD	CHAR	1	0	Pack RFC (InfoProvider)
41	SVSLOGSYS	☐	RSSLOGSYS	LOGSYS	CHAR	10	0	Source system	*
42	SVSID	☐	RSCUBESVSID	XFELD	CHAR	1	0	SID Support (InfoProvider)
43	SVNAVATTR	☐	RSCUBESVNAVATTR	XFELD	CHAR	1	0	Supports Navigation Attributes (InfoProvider)
44	SVTRANSFSEL	☐	RSSVTRANSFSEL	XFELD	CHAR	1	0	Derive Sel. Conditions from Navigation Attribute
45	SVINTFORMAT	☐	RSCUBESVINTFORMAT	XFELD	CHAR	1	0	Internal Format (Key Figures)
46	FUNCNAME	☐	RSCUBESVFUNCNAME	FUNCNAME	CHAR	30	0	Name of Function Module/Class/SAP HANA Model	*
47	HDBMODNM	☐	RSHDBMODNM	RSHDBMODNM	CHAR	64	0	SAP Hana Model Name
48	AUDITMODEFL	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
49	CONVEXITFL	☐	RSCONVEXITFL	RS_BOOL	CHAR	1	0	Flag: Execute Conversion Exit(s)
50	BASICCUBE	☐	RSBASICCUBE	RSINFOCUBE	CHAR	30	0	BasicCube for Aggregate
51	TRANSACT	☐	RSDTRANSACT	RS_BOOL	CHAR	1	0	Real Time / Direct Update
52	SLOGSYS	☐	RSSLOGSYS	LOGSYS	CHAR	10	0	Source system	*
53	.INCLUDE	☐				0	0	BEx to OLTP: Specific Cube Properties
54	ISOURCE	☐	RSISOURCE	RSISOURCE	CHAR	30	0	InfoSource
55	UNIQUE_SOURCE	☐	RSOAUNIQUESOURCE	RS_BOOL	CHAR	1	0	Indicator: Unique Source System
56	WRITECLASNM	☐	RSDWRITECLASNM	SEOCLSNAME	CHAR	30	0	Name of Class for Write Interface
57	.INCLUDE	☐				0	0	Delta Capability of an InfoProvider
58	DELTACACHE	☐	RRDELTACACHE	RSBOOL	CHAR	1	0	Update Cache Objects in Delta Process
59	DELTACACHECLSNM	☐	RSDCCLSNM	SEOCLSNAME	CHAR	30	0	Name of Class for Delta Cache
60	BUFFERTYPE	☐	RSDBUFFERTYPE	RSDBUFFERTYPE	CHAR	1	0	Defines the buffer type
61	.INCLUDE	☐				0	0	"Modes" of an InfoProvider
62	PARTITIONMODE	☐	RRSPPARTITION	RRSPPARTITION	NUMC	1	0	Type of SP Grouping for Delta Caching
63	INPUTABLE	☐	RRINPUTPROV	RS_BOOL	CHAR	1	0	InfoProvider is ready for input; there is a write function
64	INPUTMODE	☐	RRINPUTMODUS	RRINPUTMODUS	NUMC	1	0	Mode of Input Processing
65	ACTUALDATA	☐	RRACTUALDATA	RRACTUALDATA	NUMC	1	0	Data Integrity
66	PACKAGEREAD	☐	RSDPACKAGEREAD	XFELD	CHAR	1	0	Supports Reading by Package
67	NOPARALLEL	☐	RSDNOPARALLEL	XFELD	CHAR	1	0	Parallel Reading of Provider Not Permitted
68	.INCLUDE	☐				0	0	Data Handling of an InfoProvider
69	DATASORTED	☐	RSDSVDATASORTED	XFELD	CHAR	1	0	Data will be sorted first
70	DATATRUSTED	☐	RSDSVDATATRUSTED	XFELD	CHAR	1	0	Data will be provided "exactly" (no superset)
71	MATERIALIZE	☐	RSDMATERIALIZE	XFELD	CHAR	1	0	Materialization of Read Data
72	MAT_CHAVL	☐	RSDMATCHAVL	XFELD	CHAR	1	0	Materialize CHAVL-Based Queries
73	MATININDEX	☐	RSDMATININDEX	XFELD	CHAR	1	0	Create as New Index (BWA Index)
74	AGGR_TRUSTED	☐	RSDAGGRTRUSTED	XFELD	CHAR	1	0	Return Aggregated Result Set
75	SIMULATE	☐	RSDSIMULATE	XFELD	CHAR	1	0	Display of Access Plans
76	SIDPREFERRED	☐	RSDSVSIDPREFERRED	XFELD	CHAR	1	0	SID Display Preferred
77	SVINTERNAL	☐	RSDSVINTERNAL	XFELD	CHAR	1	0	Use of Internal Remote Provider Interface
78	SVSUPPREQUID	☐	RSCUBESVSUPPREQUID	XFELD	CHAR	1	0	InfoProvider Supports Ranges on 0REQUID
79	SVSIDX4DATA	☐	RSDSVSIDX4DATA	RS_BOOL	CHAR	1	0	SIDs Exist for all Data of Provider
80	.INCLUDE	☐				0	0	InfoProvider: Supplementary Properties
81	EDSFL	☐	RSEDSFL	XFLAG	CHAR	1	0	Flag: Generate export data source
82	MOLAPFL	☐	RSMOLAPFL	XFELD	CHAR	1	0	Flag: with MOLAP cube
83	SAMPLRT	☐	RSSAMPLRATE	NUMC2	NUMC	2	0	Sample rate in percent
84	BIA_STATUS	☐	RSD_BIA_STATUS	RSD_BIA_STATUS	CHAR	1	0	RSD: BW Accelerator Status of InfoCube (BWA Indexes)
85	ALLOWCIC	☐	RSDALLOWCIC	XFELD	CHAR	1	0	Indicator: Compounding Inconsistency Permitted
86	DIMID_UNIQUE	☐	RSDDIMID_UNIQUE	XFELD	CHAR	1	0	DIMIDs One-to-One to Characteristic Combinations
87	DELTA_LOAD	☐	RSDDELTA_LOAD	XFELD	CHAR	1	0	Delta Load Allowed with RSDRI
88	.INCLUDE	☐				0	0	InfoCube: Names of Tables, Structures and Views
89	FACTTAB	☐	RSFACTTAB	AS4TAB	CHAR	30	0	Fact table (of an InfoCube)	*
90	FACTVIEW	☐	RSFACTVIEW	VIEWNAME	CHAR	30	0	View: Fact table	*
91	COMPTAB	☐	RSCOMPTAB	AS4TAB	CHAR	30	0	Compressed fact table	*
92	NCUMVALTAB	☐	RSNCUMVALTAB	AS4TAB	CHAR	30	0	Non-cumulative value validity table (of an InfoCube)	*
93	VIEWTOTAL	☐	RSVIEWTOTAL	TABNAME	CHAR	30	0	View: InfoObjects + navigation attributes
94	VIEWIOBJ	☐	RSVIEWIOBJ	TABNAME	CHAR	30	0	View: Only InfoObjects
95	VIEWNAVATR	☐	RSVIEWNAVATR	TABNAME	CHAR	30	0	View: Only navigation attributes
96	VIEWIIOBJNM	☐	RSVIEWIIOBJNM	TABNAME	CHAR	30	0	View: Only InfoObjects with InfoObject field names
97	VIEWTIOBJNM	☐	RSVIEWTIOBJNM	TABNAME	CHAR	30	0	View: InfoObjects + nav.attr. with InfoObject field names
98	VIEWTIOBJNM2	☐	RSVIEWTIOBJNM2	TABNAME	CHAR	30	0	View: InfoObjects + Nav.Attr. with InfoObject field names(2)
99	VIEWHIOBJNM	☐	RSVIEWHIOBJNM	TABNAME	CHAR	30	0	View: InfoObjects + Nav. attr + Hier. w InfoObj field names
100	VIEWISET	☐	RSVIEWISET	TABNAME	CHAR	30	0	View on InfoSet
101	.INCLUDE	☐				0	0	InfoCube: Technical Properties
102	.INCLUDE	☐				0	0	InfoProvider: Partitioning Parameters
103	PARTMODE	☐	RSPARTMODE	RSPARTMODE	CHAR	1	0	Partitioning Type
104	PARTTIM	☐	RSPARTTIM	RSIOBJNM	CHAR	30	0	Partitioning time char.
105	PARTVL_FROM	☐	RSPARTVL_FROM	RSPARTVL	CHAR	10	0	Lower limit (partitioning value)
106	PARTVL_TO	☐	RSPARTVL_TO	RSPARTVL	CHAR	10	0	Upper Limit (Partitioning Value)
107	PARTMAXCNT	☐	RSPARTMAXCNT		INT4	10	0	Maximum number of partitions
108	.INCLUDE	☐				0	0	InfoProvider: Storage Parameters
109	DIMESIZCAT	☐	RSDIMESIZCAT	TABKAT	CHAR	2	0	BW: Size Category for Dimension Tables
110	DIMEDATCLS	☐	RSDIMEDATCLS	TABART	CHAR	5	0	BW: Data class for dimension tables	*
111	CUBESIZCAT	☐	RSCUBESIZCAT	TABKAT	CHAR	2	0	BW: Size Category for InfoCube (Fact) Tables
112	CUBEDATCLS	☐	RSCUBEDATCLS	TABART	CHAR	5	0	BW: Data class for InfoCube (fact)tables	*
113	.INCLUDE	☐				0	0	InfoCube: Data Flow/Status/Control
114	.INCLUDE	☐				0	0	InfoCube: BW Statistics
115	BWSTATISTICS	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
116	BWSTATWHM	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
117	.INCLUDE	☐				0	0	InfoCube: Request treatment
118	AUTOQUALOKFL	☐	RSMAUTOQUALOKFL	RSBOOL	CHAR	1	0	Set Quality Status to 'OK' Automatically
119	AUTOROLLUPFL	☐	RSMAUTOROLLUPFL	RSBOOL	CHAR	1	0	Roll up data in the aggregate automatically
120	AUTOCOMPRFL	☐	RSMAUTOCOMPRFL	RSBOOL	CHAR	1	0	Compress Automatically After Roll-Up (or After Load)
121	NOAUTOCMPAGGRFL	☐	RSMNOAUTOCMPRAGGRFL	RSBOOL	CHAR	1	0	Do not collapse aggregates automatically
122	.INCLUDE	☐				0	0	InfoCube: DB Performance Parameter
123	.INCLUDE	☐				0	0	InfoProvider: DB Performance Flags
124	CLEAR_INDEX	☐	RSBOOK3	CHAR1	CHAR	1	0	Delete index before each data load and then recreate
125	DELTA_INDEX	☐	RSBOOK4	CHAR1	CHAR	1	0	Delete index before each delta load and then recreate
126	REBUILD_STAT	☐			CHAR	1	0
127	DELTA_STAT	☐			CHAR	1	0
128	PERCENTAGE	☐			NUMC	3	0
129	NULLCOMP	☐	CDS_0_ELIM	RS_BOOL	CHAR	1	0	Zero elimination in the summarization module
130	COMP_DISJ	☐	RSCOMP_DISJ	XFELD	CHAR	1	0	Obsolete!! (Previously: Only Disjunct Records)
131	REFUPDATE	☐	CDS_REFUPDATE	RS_BOOL	CHAR	1	0	No update of the non-cumulative marker
132	DROP_INDX_ROLLUP	☐			CHAR	1	0
133	.INCLUDE	☐				0	0	Aggregate: Storage Parameter
134	ADIMSIZCAT	☐	RSADIMSIZCAT	TABKAT	CHAR	2	0	BW: Size Category for Aggregate Dimension Tables
135	ADIMDATCLS	☐	RSADIMDATCLS	TABART	CHAR	5	0	BW: Data class for aggregate dimension tables	*
136	AGGRSIZCAT	☐	RSAGGRSIZCAT	TABKAT	CHAR	2	0	BW: Size Category for Aggregate (Fact) Tables
137	AGGRDATCLS	☐	RSAGGRDATCLS	TABART	CHAR	5	0	BW: Default Data Class for Aggregate (Fact) Table	*
138	.INCLUDE	☐				0	0	InfoCube: Default Query Properties
139	QPROPVERS	☐	RSQPROPVERS	RSQPROPVERS	NUMC	2	0	Conversion Version Query Properties
140	READMODE	☐	RSRREADMODE	RSRREADMODE	CHAR	1	0	Read Mode
141	CACHEMODE	☐	RSRCACHEMODE	RSRCACHEMODE	CHAR	1	0	Cache Mode
142	CACHEDELAY	☐	RSRCACHEDELAY		INT4	10	0	Cache Validity Period in Seconds
143	NLREADMODE	☐	RSD_NLREADMODE	RSD_NLREADMODE	CHAR	1	0	Read Modus for Near-Line Storage
144	NOPARALLELQDEF	☐	RRSNOPARALLEL	RS_BOOL	CHAR	1	0	no parallel processing
145	KIDSEL	☐	RRKIDSEL	RS_BOOL	CHAR	1	0	Use Selection of Structure Elements
146	CACHEUSEREXIT	☐	RSRNOCACHEFL	RSBOOL	CHAR	1	0	Indicator: Do not Use Cache for this Report
147	NOHPA	☐	RRSNOHPA	RS_BOOL	CHAR	1	0	Obsolete Field (Do Not Use BWA Index)
148	TREXOPS	☐	RSRTREXOPS	RSRTREXOPS	CHAR	1	0	Operations in SAP HANA/BWA
149	MATERIALIZEQUERYLAYER	☐	RSRMATERIALIZEQUERYLAYER	RS_BOOL	CHAR	1	0	Materialize Intermediate Query Result
150	PACKFLQDEF	☐	RSDHIGHPRECFL	RS_BOOL	CHAR	1	0	Process key figure with high precision
151	HANAMODELFL	☐	RSMHANAMODEL	RSMHANAMODEL	CHAR	1	0	External SAP HANA view for BW object
152	SUPP_QUERY_W_DUPL_KYF	☐	SUPPORTS_KEYFIGURE_DUPLICATES	RS_BOOL	CHAR	1	0	Supp. queries w/ dupl. KYF which cont. diff. aggregations
153	CACHEUSAGEMODE	☐	RSRCACHEUSAGEMODE	RSRCACHEUSAGEMODE	CHAR	1	0	Cache Usage Mode
154	DATA_INTEGRITY_SCENARIO	☐	RSR_DATA_INTEGRITY_SCENARIO	RSR_DATA_INTEGRITY_SCENARIO	CHAR	1	0	Data Integrity Profile
155	.INCLUDE	☐				0	0	InfoCube: Aggregate Check Mode,..
156	AGGRAUTOCHECK	☐	RSDDAGGRCHECKMODE	RSDDAGGRCHECKMODE	CHAR	1	0	Check Mode for Aggregates ('A', 'Q' or 'C')
157	AGGRCHECKTIME	☐	RSDDAGGRCHECKTIME	CHAR10	CHAR	10	0	When Automatic Aggregate Check is Executed
158	.INCLUDE	☐				0	0	Include: Last changed by, time stamp in internal format
159	TSTPNM	☐	RSTSTPNM	XUBNAME	CHAR	12	0	Last changed by	USR02
160	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
161	MASTERPROV	☐	RSINFOPROV	RSINFOPROV	CHAR	30	0	InfoProvider
162	MASTERTLOGO	☐	RSTLOGO	RSTLOGO	CHAR	4	0	BW: Object Type (TLOGO)
163	DBROUTID	☐	RSODSPROGID	RSUNIIDC25	CHAR	25	0	ID for Generated DataStore Program
164	.INCLUDE	☐				0	0	ODSO Attributes for InfoProvider
165	BEXFL	☐	RSDBEXFL	RSDBEXFL	CHAR	1	0	SID Generation
166	ODSOTYPE	☐	RSDODSOTYPE	RSDODSOTYPE	CHAR	1	0	Type of DataStore Object
167	NOIOBJFL	☐	RSDODSO_NOIOBJFL	RSDODSO_NOIOBJFL	CHAR	1	0	DataStore Object: Fields Defined Without InfoObjects
168	IMOFL	☐	RSDODSO_IMOFL	XFELD	CHAR	1	0	DataStore Object: SAP HANA-Optimized
169	DELTACHECK	☐	RSMDELTACHECK	RS_BOOL	CHAR	1	0	Delta Consistency Check for DataStore
170	UOM_IOBJNM	☐	RSDG_UOM_IOBJNM	RSIOBJNM	CHAR	30	0	Reference InfoObject for Quantity Conversion
171	.INCLUDE	☐				0	0	DataStore: Automation Flags
172	AUTOACTIVATEFL	☐	RSMAUTOACTIVATEFL	RSBOOL	CHAR	1	0	Activate DataStore Object Data Automatically
173	AUTOPROCESSFL	☐	RSMAUTOPROCESSFL	RSBOOL	CHAR	1	0	Update Data from DataStore Object Automatically
174	.INCLUDE	☐				0	0	DataStore: Technical Properties
175	ODSASIZCAT	☐	RSDODSASIZCAT	TABKAT	CHAR	2	0	Size Category for DS Tables of Active Records
176	ODSADATCLS	☐	RSDODSADATCLS	TABART	CHAR	5	0	Data Type for DataStore Tables of Active Records	*
177	ODSMSIZCAT	☐	RSDODSMSIZCAT	TABKAT	CHAR	2	0	Size Category for DS Activation Queue
178	ODSMDATCLS	☐	RSDODSMDATCLS	TABART	CHAR	5	0	Data Class for DS Activation Queue	*
179	INSERTONLY	☐	RSINSERTONLY	XFELD	CHAR	1	0	Overwriting data records not permitted
180	KEY_NOT_UNIQUE	☐	RSDODSO_KEY_NOT_UNIQUE	XFELD	CHAR	1	0	Allow Duplicate Data Records

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RSD_S_DTA	TSTPNM	USR02	BNAME	KEY	C	CN

History

Last changed by/on	SAP	20141013
SAP Release Created in	20B