SAP ABAP Table V_VIBDMEASAO_DS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_VIBDMEASAO_DS	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	INTRENO	☑	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
3	MEAS	☑	REBDMEAS	REBDMEAS	CHAR	4	0	Measurement Type	TIVBDMEAS
4	VALIDTO	☑	REBDMEASVALIDTO	RECADATEEND	DATS	8	0	Date: Measurement Valid To
5	VALIDFROM	☐	REBDMEASVALIDFROM	RECADATE	DATS	8	0	Date: Measurement Valid From
6	MEASVALUE	☐	REBDMEASVALUE	REBDMEASVALUE	QUAN	17	4	Measurement Amount: Available
7	MEASVALUECMPL	☐	REBDMEASVALUECMPL	REBDMEASVALUE	QUAN	17	4	Measurement Amount: Capacity
8	MEASUNIT	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit
9	ISMANUALLYSET	☐	REBDISMANUALLYSET	RECABOOL	CHAR	1	0	Measurement Is Overwritten Manually
10	ISHIERARCHICAL	☐	REBDISHIERARCHICAL	RECABOOL	CHAR	1	0	There Are Hierarchically Subordinate Objects
11	AOID	☐	REBDAOID	REBDAOID	CHAR	30	0	Identification of Architectural Object
12	AOTYPE	☐	REBDAOTYPE	REBDAOTYPE	CHAR	4	0	Architectural Object Type	TIVBDAROBJTYPE
13	AONR	☐	REBDAONR	REBDAONR	CHAR	13	0	Number of Architectural Object
14	PARTSEPARATOR	☐	REBDPARTSEPARATOR	REBDPARTSEPARATOR	CHAR	10	0	AOID Code: Separator
15	PARTAOID	☐	REBDPARTAOID	REBDPARTAOID	CHAR	30	0	AOID Code
16	XAO	☐	REBDXAO	RECAXLDESCRIPTION	CHAR	60	0	Name of Architectural Object
17	AOFUNCTION	☐	REBDAOFUNCTION	REBDAOFUNCTION	CHAR	4	0	Function of Architectural Object	TIVBDARFUNC
18	USAGECOMMON	☐	REBDUSCOMMON	REBDUSCOMMON	CHAR	1	0	Common Usage
19	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number
20	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
21	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
22	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
23	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
24	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
25	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
26	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
27	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
28	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
29	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
30	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
31	LASTRENO	☐	DRENOV	DATUM	DATS	8	0	Date of last redecoration
32	MEASSTRC	☐	REBDMEASSTRC	REBDMEASSTRC	CHAR	4	0	Measurement Structure	TIVBDMEASSTRC
33	DOORPLT	☐	REBDDOORPLT	REBDDOORPLT	CHAR	15	0	Short description
34	RSAREA	☐	REORRSAREA	REORRSAREA	CHAR	10	0	Reservation Area	TIVORRSAREA
35	SINSTBEZ	☐	SINSTBEZ	SINSTBEZ	NUMC	5	0	Maintenance district	TIV16
36	SVERKEHR	☐	SVERKEHR	SVERKEHR	CHAR	1	0	Transport Connections of Business Entity	TIV44
37	SLAGEWE	☐	SLAGEWE	SLAGEWE	NUMC	4	0	Business entity location number	TIV10
38	SOBJLAGE	☐	RESOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator: District Location of Object	TIV45
39	RGRNART	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map	TIVC4
40	RBEPLAN	☐	RBEPLAN	XMBEZ	CHAR	30	0	Development plan
41	DBEPLAN	☐	DBEPLAN	DDAT	DATS	8	0	Date of development plan
42	RNBPLAN	☐	RNBPLAN	RGRNART	CHAR	4	0	Usage type according to development plan	TIVB3
43	XNUTZGRU	☐	XNUTZGRU	XMBEZ	CHAR	30	0	Current usage of property
44	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
45	JUNUTZA	☐	VVJUNUTZA	JANE	CHAR	1	0	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36
46	NZGRZ	☐	NZGRZ	DEC1_2	DEC	3	2	Permitted Usage: Site Occupancy Index
47	NZGFZ	☐	NZGFZ	DEC2_2	DEC	4	2	Permitted Usage: Floor Area Ratio
48	NZBMZ	☐	NZBMZ	DEC3_2	DEC	5	2	Permitted Usage: Construction Dimension Number
49	NTGRZ	☐	NTGRZ	DEC1_2	DEC	3	2	Actual Usage: Site Occupancy Index
50	NTGFZ	☐	NTGFZ	DEC2_2	DEC	4	2	Actual Usage: Floor Area Ratio
51	NTBMZ	☐	NTBMZ	DEC3_2	DEC	5	2	Actual Usage: Construction Dimension Number
52	SGRART	☐	VVSGRART	VVSGRART	NUMC	4	0	Property type	TIV56
53	SGRQAL	☐	VVSGRQAL	VVSGRQAL	NUMC	3	0	Property: Quality of location	TIV57
54	SGRFRM	☐	VVSGRFRM	VVSGRFRM	NUMC	3	0	Property ground type	TIV58
55	SGRGZS	☐	VVSGRGZS	VVSGRGZS	NUMC	3	0	Overall condition of property	TIV59
56	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
57	ZULBAUH	☐	REBDALLOWEDHEIGHT	REBDALLOWEDHEIGHT	INT2	5	0	Allowed Building Height (as Integer)
58	RGEBART	☐	RGEBART	SOBJART	NUMC	2	0	Type of building	TIV5A
59	RGEBZUST	☐	RGEBZUST	VVRZUSTAND	NUMC	2	0	General condition of building	TIV83
60	YBAUJAHR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
61	JNURJAHR	☐	VVJNURJ	JANE	CHAR	1	0	Indicator: Only regard construction date in terms of years
62	YMODERN	☐	VVYMODERN	DATUM	DATS	8	0	Year of modernization
63	YAUFBAU	☐	VVYAUFBAU	DATUM	DATS	8	0	Year of reconstruction
64	DBAUBEGI	☐	DBAUBEGI	DDAT	DATS	8	0	Construction start date
65	DBAUVOR	☐	DBAUVOR	DDAT	DATS	8	0	Date of planning inquiry
66	DVORBES	☐	DVORBES	DDAT	DATS	8	0	Date of prior notice
67	DANTBAU	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
68	DBAUGENE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
69	XBAUGENE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
70	DFERTIG	☐	DFERTIG	DDAT	DATS	8	0	Completion
71	DSCHLUSS	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
72	DBEZUGSF	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
73	RDAZUST	☐	RECADUMMYN2	NUMC2	NUMC	2	0	Dummy: No Longer Used
74	RFAZUST	☐	RECADUMMYN2	NUMC2	NUMC	2	0	Dummy: No Longer Used
75	JDENKMAL	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
76	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
77	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
78	BANZGE	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
79	AUGESCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
80	SSTCKBIS	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	TIV37
81	SLIFTBIS	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	TIV37
82	NSTCKLFT	☐	VVNSTCKLFT	NUMC3	NUMC	3	0	Number of highest floor reached by elevator
83	VALIDFROMAO	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
84	VALIDTOAO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_VIBDMEASAO_DS	AOFUNCTION	TIVBDARFUNC	AOFUNCTION	REF	1	CN
2	V_VIBDMEASAO_DS	AOTYPE	TIVBDAROBJTYPE	AOTYPE	REF	1	CN
3	V_VIBDMEASAO_DS	JERBBAU	TDO9	SOBJERBBAU
4	V_VIBDMEASAO_DS	MANDT	T000	MANDT	KEY	1	CN
5	V_VIBDMEASAO_DS	MEAS	TIVBDMEAS	MEAS	KEY	1	CN
6	V_VIBDMEASAO_DS	MEASSTRC	TIVBDMEASSTRC	MEASSTRC	KEY	1	CN
7	V_VIBDMEASAO_DS	RESPONSIBLE	USR02	BNAME	REF	1	CN
8	V_VIBDMEASAO_DS	RGEBART	TIV5A	SOBJART	REF	C	CN
9	V_VIBDMEASAO_DS	RGEBZUST	TIV83	RZUSTAND	REF	C	CN
10	V_VIBDMEASAO_DS	RGRNART	TIVC4	RGRNART	KEY	1	CN
11	V_VIBDMEASAO_DS	RNBPLAN	TIVB3	RNBPLAN		1	CN
12	V_VIBDMEASAO_DS	RSAREA	TIVORRSAREA	RSAREA	KEY
13	V_VIBDMEASAO_DS	SGRART	TIV56	SGRART	REF	C	CN
14	V_VIBDMEASAO_DS	SGRFRM	TIV58	SGRFRM	REF	C	CN
15	V_VIBDMEASAO_DS	SGRGZS	TIV59	SGRGZS	REF	C	CN
16	V_VIBDMEASAO_DS	SGRQAL	TIV57	SGRQAL	REF	C	CN
17	V_VIBDMEASAO_DS	SINSTBEZ	TIV16	SINSTBEZ	REF	C	CN
18	V_VIBDMEASAO_DS	SLAGEWE	TIV10	SLAGEWE	REF	C	CN
19	V_VIBDMEASAO_DS	SLIFTBIS	TIV37	SSTOCKW	REF	C	CN
20	V_VIBDMEASAO_DS	SOBJLAGE	TIV45	SOBJLAGE	REF	C	CN
21	V_VIBDMEASAO_DS	SSTCKBIS	TIV37	SSTOCKW	REF	C	CN
22	V_VIBDMEASAO_DS	SUNUTZA	TIV36	SUNART	REF	C	CN
23	V_VIBDMEASAO_DS	SVERKEHR	TIV44	SVERKEHR	REF	C	CN
24	V_VIBDMEASAO_DS	USEREXCLUSIVE	USR02	BNAME	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in