SAP ABAP Table AVIXCITCADAO (Change Document Structure Cadaster data of ALV (VIXCITCADAO))

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_XC_RA_IT (Package) RE: XC - Localisation of Flexible Real Estate for Italy

Basic Data

Table Category	INTTAB	Structure
Structure	AVIXCITCADAO	Table Relationship Diagram
Short Description	Change Document Structure Cadaster data of ALV (VIXCITCADAO)

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	.INCLUDE	☐				0	0	Temporary architectural object data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	.INCLUDE	☐				0	0	Key for Cadaster temporary data of AO merging/splitting (VIX
4	PROCESSID	☐	REXCITCADPROC	VVSSOLLID	NUMC	8	0	ID of Splitting/Merging Process
5	KEY_DATE	☐	DATUM	DATUM	DATS	8	0	Date
6	ORIG_INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
7	NEW_INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
8	.INCLUDE	☐				0	0	Architectural Object: Key
9	AOID	☐	REBDAOID	REBDAOID	CHAR	30	0	Identification of Architectural Object
10	.INCLUDE	☐				0	0	Architectural object
11	CADOPERATION	☐	REXCITCADOP	REXCITCADOP	CHAR	1	0	Process Type with Architectural Object
12	.INCLUDE	☐				0	0	Architectural Object: Header
13	AOTYPE	☐	REBDAOTYPE	REBDAOTYPE	CHAR	4	0	Architectural Object Type	TIVBDAROBJTYPE
14	AONR	☐	REBDAONR	REBDAONR	CHAR	13	0	Number of Architectural Object
15	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
16	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
17	PARTSEPARATOR	☐	REBDPARTSEPARATOR	REBDPARTSEPARATOR	CHAR	10	0	AOID Code: Separator
18	PARTAOID	☐	REBDPARTAOID	REBDPARTAOID	CHAR	30	0	AOID Code
19	XAO	☐	REBDXAO	RECAXLDESCRIPTION	CHAR	60	0	Name of Architectural Object
20	AOFUNCTION	☐	REBDAOFUNCTION	REBDAOFUNCTION	CHAR	4	0	Function of Architectural Object	TIVBDARFUNC
21	USAGECOMMON	☐	REBDUSCOMMON	REBDUSCOMMON	CHAR	1	0	Common Usage
22	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
23	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
24	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
25	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
26	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
27	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
28	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
29	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
30	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
31	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
32	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
33	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
34	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
35	LASTRENO	☐	DRENOV	DATUM	DATS	8	0	Date of last redecoration
36	MEASSTRC	☐	REBDMEASSTRC	REBDMEASSTRC	CHAR	4	0	Measurement Structure	*
37	DOORPLT	☐	REBDDOORPLT	REBDDOORPLT	CHAR	15	0	Short description
38	.INCLUDE	☐				0	0	Architectural Object: Attributes of Business Entity
39	SINSTBEZ	☐	SINSTBEZ	SINSTBEZ	NUMC	5	0	Maintenance district	TIV16
40	SVERKEHR	☐	SVERKEHR	SVERKEHR	CHAR	1	0	Transport Connections of Business Entity	TIV44
41	SLAGEWE	☐	SLAGEWE	SLAGEWE	NUMC	4	0	Business entity location number	TIV10
42	SOBJLAGE	☐	RESOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator: District Location of Object	TIV45
43	.INCLUDE	☐				0	0	Architectural Object: Attributes of Property
44	RGRNART	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map	TIVC4
45	RBEPLAN	☐	RBEPLAN	XMBEZ	CHAR	30	0	Development plan
46	DBEPLAN	☐	DBEPLAN	DDAT	DATS	8	0	Date of development plan
47	RNBPLAN	☐	RNBPLAN	RGRNART	CHAR	4	0	Usage type according to development plan	TIVB3
48	XNUTZGRU	☐	XNUTZGRU	XMBEZ	CHAR	30	0	Current usage of property
49	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
50	JUNUTZA	☐	VVJUNUTZA	JANE	CHAR	1	0	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36
51	NZGRZ	☐	NZGRZ	DEC1_2	DEC	3	2	Permitted Usage: Site Occupancy Index
52	NZGFZ	☐	NZGFZ	DEC2_2	DEC	4	2	Permitted Usage: Floor Area Ratio
53	NZBMZ	☐	NZBMZ	DEC3_2	DEC	5	2	Permitted Usage: Construction Dimension Number
54	NTGRZ	☐	NTGRZ	DEC1_2	DEC	3	2	Actual Usage: Site Occupancy Index
55	NTGFZ	☐	NTGFZ	DEC2_2	DEC	4	2	Actual Usage: Floor Area Ratio
56	NTBMZ	☐	NTBMZ	DEC3_2	DEC	5	2	Actual Usage: Construction Dimension Number
57	SGRART	☐	VVSGRART	VVSGRART	NUMC	4	0	Property type	TIV56
58	SGRQAL	☐	VVSGRQAL	VVSGRQAL	NUMC	3	0	Property: Quality of location	TIV57
59	SGRFRM	☐	VVSGRFRM	VVSGRFRM	NUMC	3	0	Property ground type	TIV58
60	SGRGZS	☐	VVSGRGZS	VVSGRGZS	NUMC	3	0	Overall condition of property	TIV59
61	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
62	ZULBAUH	☐	REBDALLOWEDHEIGHT	REBDALLOWEDHEIGHT	INT2	5	0	Allowed Building Height (as Integer)
63	.INCLUDE	☐				0	0	Architectural Object: Attributes of Building
64	RGEBART	☐	RGEBART	SOBJART	NUMC	2	0	Type of building	TIV5A
65	RGEBZUST	☐	RGEBZUST	VVRZUSTAND	NUMC	2	0	General condition of building	TIV83
66	YBAUJAHR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
67	JNURJAHR	☐	VVJNURJ	JANE	CHAR	1	0	Indicator: Only regard construction date in terms of years
68	YMODERN	☐	VVYMODERN	DATUM	DATS	8	0	Year of modernization
69	YAUFBAU	☐	VVYAUFBAU	DATUM	DATS	8	0	Year of reconstruction
70	DBAUBEGI	☐	DBAUBEGI	DDAT	DATS	8	0	Construction start date
71	DBAUVOR	☐	DBAUVOR	DDAT	DATS	8	0	Date of planning inquiry
72	DVORBES	☐	DVORBES	DDAT	DATS	8	0	Date of prior notice
73	DANTBAU	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
74	DBAUGENE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
75	XBAUGENE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
76	DFERTIG	☐	DFERTIG	DDAT	DATS	8	0	Completion
77	DSCHLUSS	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
78	DBEZUGSF	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
79	RDAZUST	☐	RECADUMMYN2	NUMC2	NUMC	2	0	Dummy: No Longer Used
80	RFAZUST	☐	RECADUMMYN2	NUMC2	NUMC	2	0	Dummy: No Longer Used
81	JDENKMAL	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
82	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
83	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
84	BANZGE	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
85	AUGESCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
86	SSTCKBIS	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	TIV37
87	SLIFTBIS	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	TIV37
88	NSTCKLFT	☐	VVNSTCKLFT	NUMC3	NUMC	3	0	Number of highest floor reached by elevator
89	.INCLUDE	☐				0	0	Cadastral Master Data - data fields
90	CITYCODE	☐	REXCITCITYCODE	REXCITCITYCODE	CHAR	4	0	City Code
91	ADMINDIVISION	☐	REXCITADMDIV	REXCITADMDIV	CHAR	10	0	Administrative Division
92	CENSUSDIVISION	☐	REXCITCENSUSDIV	REXCITCENSUSDIV	CHAR	10	0	Census Division
93	CITYDIVISION	☐	REXCITCITYDIV	REXCITCITYDIV	CHAR	10	0	City Division
94	SHEET	☐	REXCITSHEET	REXCITSHEET	CHAR	10	0	Sheet
95	PARCEL	☐	REXCITPARCEL	REXCITPARCEL	CHAR	10	0	Parcel
96	QUALITY	☐	REXCITICIQUALITY	CHAR25	CHAR	25	0	Quality
97	DENOMINATOR	☐	REXCITDENOMINATOR	REXCITDENOMINATOR	CHAR	10	0	Denominator
98	SUBALTERN	☐	REXCITSUBALTERN	REXCITSUBALTERN	CHAR	10	0	Subordinate
99	CLASS	☐	REXCITICICLASS	NUMC2	NUMC	2	0	Class of Buildings
100	UIUOBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
101	UIUINTRENO	☐	REXCUIUINTRENO	RECAINTRENO	CHAR	13	0	Intreno of U.I.U
102	ORIGAOID	☐	REXCITORIGAOID	REBDAOID	CHAR	30	0	Original AO's AOID
103	DERIVAOID	☐	REXCITDERIVAOID	REBDAOID	CHAR	30	0	Derivate AO's AOID
104	.INCLUDE	☐				0	0	ICI Data - data fields
105	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
106	DATETO	☐	RECADATETO	RECADATEEND	DATS	8	0	Date: Valid To
107	ICIAMOUNT	☐	REXCITICIAMOUNT	RECACURR	CURR	15	2	ICI/IMU Tax Amount
108	POSTALCODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
109	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City	TIVXCITICIPARAM
110	ICIRATE	☐	REXCITICIRATE		DEC	5	2	ICI/IMU Rate
111	ISMANUALRATE	☐	REXCITISMANUALRATE	RECABOOL	CHAR	1	0	Manually entered ICI/IMU rate differs from auto. det. rate
112	ICICOLLECTOR	☐	REXCITICICOLLECTOR	RECAXLDESCRIPTION	CHAR	60	0	Name of the Tax Collector
113	ACCNO	☐	REXCITACCNO		CHAR	10	0	Account number
114	CATID	☐	REXCITCATID		CHAR	4	0	Cadastral Category ID
115	CATCOEFF	☐	REXCITCATCOEFF	REXCITRATEGT100	DEC	5	2	Category Coefficient
116	CALCTYPE	☐	REXCITCALCTYPE		CHAR	2	0	Calculation Type
117	AOVALUE	☐	REXCITAOVALUE	RECACURR	CURR	15	2	Value of Architectural Object
118	BASEAMOUNT	☐	REXCITBASEAMOUNT	RECACURR	CURR	15	2	Base amount
119	TAXBASE	☐	REXCITICITAXBASE	RECACURR	CURR	15	2	Taxable Amount
120	MONOWN	☐	REXCITMONOWN		NUMC	2	0	Period of ownership
121	PERCOWN	☐	REXCITPERCOWN	REXCITRATE	DEC	5	2	Ownership Percentage
122	MONEXCL	☐	REXCITMONEXCL		NUMC	2	0	Months of exclusion
123	DETRAMOUNT	☐	REXCITDETRAMOUNT	RECACURR	CURR	15	2	Detraction Amount
124	DETRACTPREC	☐	REXCITDETRACTPREC	REXCITRATE	DEC	5	2	Detraction Percentage
125	RAISPERC	☐	REXCITRAISPERC	REXCITRATE	DEC	5	2	Percentage Increase
126	ISANNUALPAY	☐	REXCITISANNUALPAY	RECABOOL	CHAR	1	0	One Annual Payment (Without Down Payment)
127	DATPRI	☐	REXCITDATPRI	RECADATE	DATS	8	0	Due Date of First Installment (Down Payment)
128	INSTPRIPAID	☐	REXCITINSTPRIPAID	RECABOOL	CHAR	1	0	First Installment (downpayment) Paid
129	DOWNPAYMENT	☐	REXCITDOWNPAYM	RECACURR	CURR	15	2	Down Payment
130	DATSEC	☐	REXCITDATSEC	RECADATE	DATS	8	0	Due Date of Second Installment Payment
131	BALANCE	☐	REXCITBALANCE	RECACURR	CURR	15	2	Balance
132	ISACTIVEICI	☐	REXCITISACTIVEICI	RECABOOL	CHAR	1	0	ICI/IMU Record Locked for Recalculation
133	ASSIGINTRENO	☐	REXCITASSIGINTRENO	RECAINTRENO	CHAR	13	0	Assigned real estate object
134	ASSIGOBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
135	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
136	IS_EXEMPT	☐	REXCITISEXEMPT	RECABOOL	CHAR	1	0	Exemption Status
137	IS_UNINHABIT	☐	REXCITISUNINHABIT	RECABOOL	CHAR	1	0	Uninhabitable Building
138	IS_HISTORIC	☐	REXCITHISTORIC	RECABOOL	CHAR	1	0	Historical Object
139	COUNTRYRATE	☐	REXCITIMUCNTRYRATE		DEC	5	2	IMU Country Rate
140	CITYRATE	☐	REXCITIMUCITYRATE		DEC	5	2	IMU City Rate
141	DOWNPAYMENTCITY	☐	REXCITDOWNPAYMCITY	RECACURR	CURR	15	2	Down Payment to City
142	DOWNPAYMENTCNTRY	☐	REXCITDOWNPAYMCNTRY	RECACURR	CURR	15	2	Down Payment to Country
143	BALANCECITY	☐	REXCITBALANCECITY	RECACURR	CURR	15	2	Balance to City
144	BALANCECOUNTRY	☐	REXCITBALANCECNTRY	RECACURR	CURR	15	2	Balance to Country
145	CITYAMOUNT	☐	REXCITCITYAMOUNT	RECACURR	CURR	15	2	ICI/IMU City Tax Amount
146	COUNTRYAMOUNT	☐	REXCITCNTRYAMOUNT	RECACURR	CURR	15	2	ICI/IMU Country Tax Amount
147	REDUCTION	☐	REXCITREDUCTION	CHAR2	CHAR	2	0	Reduction ID	TIVXCITREDUCT
148	.INCLUDE	☐				0	0	Structures for generating change document update programs
149	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

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

History

Last changed by/on	SAP	20131127
SAP Release Created in	607