SAP ABAP View RSDVCHA (View of characteristics, basic chars and local properties)

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

View Type	D	Database View
Database View	RSDVCHA
Short Description	View of characteristics, basic chars and local properties
Root table	RSDCHA	Characteristic Catalog

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	RSDCHA	RSDCHA
2	RSDCHABAS
3	RSDCHABASLOC

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	RSDCHABAS	CHABASNM	JL	EQ				0	0
2	RSDCHA	CHABASNM	JR	EQ			AND	0	0
3	RSDCHABAS	OBJVERS	JL	EQ				0	0
4	RSDCHA	OBJVERS	JR	EQ			AND	0	0
5	RSDCHABASLOC	CHABASNM	JL	EQ				0	0
6	RSDCHABAS	CHABASNM	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CHANM	RSDCHA	CHANM		☐	RSCHANM	☐	Characteristic
2	OBJVERS	RSDCHA	OBJVERS		☐	RSOBJVERS	☐	Object version
3	CHABASNM	RSDCHA	CHABASNM		☐	RSCHABASNM	☐	Reference characteristic
4	BCHREFFL	RSDCHA	BCHREFFL		☐	RSBCHREFFL	☐	Characteristic references another basic characteristic(flag)
5	CMPSTA	RSDCHA	CMPSTA		☐	RSCMPSTA	☐	Compound status
6	CHACONST	RSDCHA	CHACONST		☐	RSCHACONST	☐	Characteristic Constant
7	AUTHRELFL	RSDCHA	AUTHRELFL		☐	RSDAUTHRELFL	☐	Characteristic is relevant for authorization check
8	AUTHFIELD	RSDCHA	AUTHFIELD		☐	RSDAUTHFIELD	☐	Authorization Field for Reporting Authorizations
9	MASTAUTHFL	RSDCHA	MASTAUTHFL		☐	RSDMASTAUTHFL	☐	Maintenance of master data is relevant for authorization
10	ODSFL	RSDCHA	ODSFL		☐	RSDODSFL	☐	InfoObject is an ODS InfoObject (Flag)
11	DEFMEMBER	RSDCHA	DEFMEMBER		☐	RSDDEFMEMBER	☐	Default Characteristic Value
12	CHAPRSNT	RSDCHA	CHAPRSNT		☐	RSCHAPRSNT	☐	Display for Characteristics and Units
13	CHANAV	RSDCHA	CHANAV		☐	RSCHANAV	☐	Navigation Indicator for Characteristics and Units
14	CHASEL	RSDCHA	CHASEL		☐	RSCHASEL	☐	Selection restriction for characteristics
15	TXTDEF	RSDCHA	TXTDEF		☐	RSTXTDEF	☐	Business Explorer Description
16	BWSTATISTICS	RSDCHA	BWSTATISTICS		☐	RS_BOOL	☐	Boolean
17	BWSTATWHM	RSDCHA	BWSTATWHM		☐	RS_BOOL	☐	Boolean
18	READMODE	RSDCHA	READMODE		☐	RSRREADMODE	☐	Read Mode
19	CACHEMODE	RSDCHA	CACHEMODE		☐	RSRCACHEMODE	☐	Cache Mode
20	CACHEDELAY	RSDCHA	CACHEDELAY		☐	RSRCACHEDELAY	☐	Cache Validity Period in Seconds
21	F4PRSNT	RSDCHA	F4PRSNT		☐	RSF4PRSNT	☐	Representation of Filter Values During Query Execution
22	DATATP	RSDCHABAS	DATATP		☐	DATATYPE_D	☐	Data Type in ABAP Dictionary
23	INTLEN	RSDCHABAS	INTLEN		☐	RSDINTLEN	☐	Internal Length of InfoObjects in BW - see Docu
24	OUTPUTLEN	RSDCHABAS	OUTPUTLEN		☐	OUTPUTLEN	☐	Output Length
25	CONVEXIT	RSDCHABAS	CONVEXIT		☐	CONVEXIT	☐	Conversion Routine
26	FVALEX	RSDCHABAS	FVALEX		☐	RSFVALEX	☐	Domain fixed values exist (flag)
27	LOWERCASE	RSDCHABAS	LOWERCASE		☐	LOWERCASE	☐	Lowercase letters allowed/not allowed
28	GISTP	RSDCHABAS	GISTP		☐	RSGISTP	☐	Geographical type for a characteristic
29	GISATTRINM	RSDCHABAS	GISATTRINM		☐	RSGISATTRINM	☐	Geographical attribute
30	INFOAREA	RSDCHABAS	INFOAREA		☐	RSINFOAREA	☐	InfoArea
31	APPLNM	RSDCHABAS	APPLNM		☐	RSAPPLNM	☐	Application Component
32	BOR_OBJTYP	RSDCHABAS	BOR_OBJTYP		☐	SWO_OBJTYP	☐	Object Type
33	CHATP	RSDCHABAS	CHATP		☐	RSCHATP	☐	Characteristc Type Based on Master Data Access
34	MDRCLNM	RSDCHABAS	MDRCLNM		☐	RSMDCLNM	☐	Name of Master Data Read Class
35	MDRCLPA	RSDCHABAS	MDRCLPA		☐	RSMDRCLPA	☐	Parameters for Master Data Read Class
36	NOVALFL	RSDCHABAS	NOVALFL		☐	RSNOVALFL	☐	Characteristic does not have a check table
37	HIGH_CARDINALITY	RSDCHABAS	HIGH_CARDINALITY		☐	RSDHIGH_CARD_CHA	☐	Characteristic with high cardinality (more than 2 mio recs.)
38	RDAFL	RSDCHABAS	RDAFL		☐	RSDRDAFL	☐	Permitted for RDA Process
39	F4DEFAULT	RSDCHABAS	F4DEFAULT		☐	RSF4DEFAULT	☐	Selection of Filter Values for Query Definition
40	F4QUERYEXEC	RSDCHABAS	F4QUERYEXEC		☐	RSF4QUERYEXEC	☐	Selection of Filter Values for Query Execution
41	ATTRIBFL	RSDCHABAS	ATTRIBFL		☐	RSATTRIBFL	☐	Attributes (flag) exist for the characteristic
42	TIMDEPFL	RSDCHABAS	TIMDEPFL		☐	RSTIMDEPFL	☐	Flag: Master data is time-dependent
43	KEYSORTEXT	RSDCHABAS	KEYSORTEXT		☐	RSDKEYSOREXT	☐	The key is sorted according to the external format (flag)
44	EXPDSOURCEFL	RSDCHABAS	EXPDSOURCEFL		☐	RSEXPDSOURCEFL	☐	The characteristic is used as export data source
45	CHECKODS	RSDCHABAS	CHECKODS		☐	RSDCHECKODS	☐	DataStore Object for Checking Characteristic Values
46	TXTTABFL	RSDCHABAS	TXTTABFL		☐	RSDTXTTABFL	☐	Text Table Exists
47	TXTTIMFL	RSDCHABAS	TXTTIMFL		☐	RSDTXTTIMFL	☐	Texts are time-dep.
48	NOLANGU	RSDCHABAS	NOLANGU		☐	RSNOLANGU	☐	Master data texts are language independent (flag)
49	TXTSHFL	RSDCHABAS	TXTSHFL		☐	RSTXTSHFL	☐	Short text exists (flag)
50	TXTMDFL	RSDCHABAS	TXTMDFL		☐	RSTXTMDFL	☐	Medium length text exists (flag)
51	TXTLGFL	RSDCHABAS	TXTLGFL		☐	RSTXTLGFL	☐	Long text exists (flag)
52	TXTXLFL	RSDCHABAS	TXTXLFL		☐	RSTXTXLFL	☐	The long text is extra long (String)
53	UOMCONV	RSDCHABAS	UOMCONV		☐	RSUOMCONV	☐	Base Unit of Measure
54	UOMCONVODS	RSDCHABAS	UOMCONVODS		☐	RSUOMCONVODS	☐	Quantity ODS: Units of Measure for InfoObject
55	UNINM	RSDCHABAS	UNINM		☐	RSCUKYDEF	☐	Currency attribute
56	IOBJROUT	RSDCHABAS	IOBJROUT		☐	RSIOBJROUT	☐	Global transfer routine for InfoObjects
57	HIETABFL	RSDCHABAS	HIETABFL		☐	RSHIETABFL	☐	Characteristic with hierarchies
58	HIEVERFL	RSDCHABAS	HIEVERFL		☐	RSHIEVERFL	☐	Hierarchies can have several versions
59	HIENMTFL	RSDCHABAS	HIENMTFL		☐	RSDHIENMTFL	☐	Entire hierarchy is time-dependent
60	HIENDTFL	RSDCHABAS	HIENDTFL		☐	RSHIENDTFL	☐	Hierarchy structure is time-dependent
61	HIEINTFL	RSDCHABAS	HIEINTFL		☐	RSHIEINTFL	☐	Intervals permitted in hierarchy
62	HIESIGNCH	RSDCHABAS	HIESIGNCH		☐	RSSHSIGNCH	☐	Reverse Sign for Hierarchy Nodes
63	HIETJOINFL	RSDCHABAS	HIETJOINFL		☐	RSHIETJOINFL	☐	Use Temporal Hierarchy Join
64	HIETP	RSDCHABAS	HIETP		☐	RSHIETP	☐	Type of Characteristic Related to Hierarchy
65	HIECLNM	RSDCHABAS	HIECLNM		☐	RSHIECLNM	☐	Name of Remote Hierarchy
66	HIECLPA	RSDCHABAS	HIECLPA		☐	RSHIECLPA	☐	Parameters for Remote Hierarchy Class
67	IOBJSIZCAT	RSDCHABAS	IOBJSIZCAT		☐	RSIOBJSIZCAT	☐	BW: Size category for InfoObject tables (master data/hier.)
68	IOBJDATCLS	RSDCHABAS	IOBJDATCLS		☐	RSIOBJDATCLS	☐	BW: Data class for InfoObject tables(master data/ hierarch.)
69	OBN_SYS_ALIAS	RSDCHABAS	OBN_SYS_ALIAS		☐	RSDSYSALIAS	☐	System Alias for OBN
70	IOBJ_HANAMODEL	RSDCHABAS	IOBJ_HANAMODEL		☐	RSMHANAMODEL	☐	External SAP HANA view for BW object
71	HANAMODELFL	RSDCHA	HANAMODELFL		☐	RSMHANAMODEL	☐	External SAP HANA view for BW object
72	SUPPORTS_XXL_ATTRIBUTES	RSDCHABAS	SUPPORTS_XXL_ATTRIBUTES		☐	RSDSUPPXXLATTR	☐	Characteristic Supports XXL Attributes
73	DBROUTID	RSDCHABASLOC	DBROUTID		☐	RSDBROUTID	☐	ID for database routines for basic char.
74	NUMBRANR	RSDCHABASLOC	NUMBRANR		☐	RSNUMBRANR	☐	Number of the number range object of a characteristic
75	CNVSTATE	RSDCHABASLOC	CNVSTATE		☐	RSDCNVSTATE	☐	See docu for conversion status
76	TREXFL	RSDCHABASLOC	TREXFL		☐	RSTREXFL	☐	Characteristic Uses TREX Search
77	MIME_TYPE	RSDCHABAS	MIME_TYPE		☐	SDOK_CNTTY	☐	MIME Content Type

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20141013
SAP Release Created in