VIXCITCADAO - Temporary architectural object data

Temporary architectural object data information is stored in SAP table VIXCITCADAO.
It is part of development package RE_XC_RA_IT in software component RE-FX. This development package consists of objects that can be grouped under "".

Fields for table VIXCITCADAO

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
.INCLUDE		X		VIXCITCADOBJ_KEY	0
PROCESSID	ID of Splitting/Merging Process	X	REXCITCADPROC	NUMC	16
KEY_DATE	Date	X	DATUM	DATS	16
ORIG_INTRENO	Internal Key of Real Estate Object	X	RECAINTRENO	CHAR	26
NEW_INTRENO	Internal Key of Real Estate Object	X	RECAINTRENO	CHAR	26
.INCLUDE				VIBDAO_KEY	0
AOID	Identification of Architectural Object		REBDAOID	CHAR	60
.INCLUDE				VIXCITCADAO_TAB	0
CADOPERATION	Process Type with Architectural Object		REXCITCADOP	CHAR	2
.INCLUDE	HDR			VIBDAO_HDR	0
AOTYPE	Architectural Object Type		REBDAOTYPE	CHAR	8	TIVBDAROBJTYPE
AONR	Number of Architectural Object		REBDAONR	CHAR	26
VALIDFROM	Date: Object Valid From		REBDOBJVALIDFROM	DATS	16
VALIDTO	Date: Object Valid To		REBDOBJVALIDTO	DATS	16
PARTSEPARATOR	AOID Code: Separator		REBDPARTSEPARATOR	CHAR	20
PARTAOID	AOID Code		REBDPARTAOID	CHAR	60
XAO	Name of Architectural Object		REBDXAO	CHAR	120
AOFUNCTION	Function of Architectural Object		REBDAOFUNCTION	CHAR	8	TIVBDARFUNC
USAGECOMMON	Common Usage		REBDUSCOMMON	CHAR	2
OBJNR	Object Number		RECAOBJNR	CHAR	44	*
AUTHGRP	Authorization Group		RECAAUTHGRP	CHAR	80
.INCLUDE	RUSER			RUSER	0
RERF	Entered By		RERF	CHAR	24
DERF	First Entered On		DERF	DATS	16
TERF	Time of Creation		TERF	TIMS	12
REHER	Source of Initial Entry		REHER	CHAR	20
RBEAR	Employee ID		RBEAR	CHAR	24
DBEAR	Last Edited On		DBEAR	DATS	16
TBEAR	Last Edited At		TBEAR	TIMS	12
RBHER	Editing Source		RBHER	CHAR	20
RESPONSIBLE	Person Responsible		RECARESPONSIBLE	CHAR	24	USR02
USEREXCLUSIVE	User with Exclusive Change Authorization		RECAUSEREXCLUSIVE	CHAR	24	USR02
LASTRENO	Date of last redecoration		DRENOV	DATS	16
MEASSTRC	Measurement Structure		REBDMEASSTRC	CHAR	8	*
DOORPLT	Short description		REBDDOORPLT	CHAR	30
.INCLUDE	VIBDAO_DATA_BE			VIBDAO_DATA_BE	0
SINSTBEZ	Maintenance district		SINSTBEZ	NUMC	10	TIV16
SVERKEHR	Transport Connections of Business Entity		SVERKEHR	CHAR	2	TIV44
SLAGEWE	Business entity location number		SLAGEWE	NUMC	8	TIV10
SOBJLAGE	Indicator: District Location of Object		RESOBJLAGE	NUMC	4	TIV45
.INCLUDE	VIBDAO_DATA_PR			VIBDAO_DATA_PR	0
RGRNART	Usage Type of Property According to Land Use Map		RGRNART	CHAR	4	TIVC4
RBEPLAN	Development plan		RBEPLAN	CHAR	60
DBEPLAN	Date of development plan		DBEPLAN	DATS	16
RNBPLAN	Usage type according to development plan		RNBPLAN	CHAR	8	TIVB3
XNUTZGRU	Current usage of property		XNUTZGRU	CHAR	60
SUNUTZA	Main usage type		VVSUNART	CHAR	16	TIV36
JUNUTZA	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36		VVJUNUTZA	CHAR	2
NZGRZ	Permitted Usage: Site Occupancy Index		NZGRZ	DEC	2
NZGFZ	Permitted Usage: Floor Area Ratio		NZGFZ	DEC	3
NZBMZ	Permitted Usage: Construction Dimension Number		NZBMZ	DEC	3
NTGRZ	Actual Usage: Site Occupancy Index		NTGRZ	DEC	2
NTGFZ	Actual Usage: Floor Area Ratio		NTGFZ	DEC	3
NTBMZ	Actual Usage: Construction Dimension Number		NTBMZ	DEC	3
SGRART	Property type		VVSGRART	NUMC	8	TIV56
SGRQAL	Property: Quality of location		VVSGRQAL	NUMC	6	TIV57
SGRFRM	Property ground type		VVSGRFRM	NUMC	6	TIV58
SGRGZS	Overall condition of property		VVSGRGZS	NUMC	6	TIV59
JERBBAU	Heritable building right indicator		JERBBAU	CHAR	2	TDO9
.INCLUDE	VIBDAO_DATA_BU			VIBDAO_DATA_BU	0
RGEBART	Type of building		RGEBART	NUMC	4	TIV5A
RGEBZUST	General condition of building		RGEBZUST	NUMC	4	TIV83
YBAUJAHR	ConstYr		VVYBAUJAHR	DATS	16
JNURJAHR	Indicator: Only regard construction date in terms of years		VVJNURJ	CHAR	2
YMODERN	Year of modernization		VVYMODERN	DATS	16
YAUFBAU	Year of reconstruction		VVYAUFBAU	DATS	16
DBAUBEGI	Construction start date		DBAUBEGI	DATS	16
DBAUVOR	Date of planning inquiry		DBAUVOR	DATS	16
DVORBES	Date of prior notice		DVORBES	DATS	16
DANTBAU	Application for building permit		DANTBAU	DATS	16
DBAUGENE	Building permit		DBAUGENE	DATS	16
XBAUGENE	Note on building permit		XBAUGENE	CHAR	60
DFERTIG	Completion		DFERTIG	DATS	16
DSCHLUSS	Final Inspection		DSCHLUSS	DATS	16
DBEZUGSF	Ready for occupancy		DBEZUGSF	DATS	16
RDAZUST	Dummy: No Longer Used		RECADUMMYN2	NUMC	4
RFAZUST	Dummy: No Longer Used		RECADUMMYN2	NUMC	4
JDENKMAL	Protection of Historical Sites		JDENKMAL	CHAR	2
DFRDVON	Public funding from		VVDFRDVON	DATS	16
DFRDBIS	Public funding to		VVDFRDBIS	DATS	16
BANZGE	Number of floors		VVBANZGE	DEC	3
AUGESCH	Number of basements		AUGESCH	DEC	2
SSTCKBIS	Uppermost Floor of a Building		VVSTCKBIS	NUMC	6	TIV37
SLIFTBIS	Elevator to Floor in Building		VVLIFTBIS	NUMC	6	TIV37
NSTCKLFT	Number of highest floor reached by elevator		VVNSTCKLFT	NUMC	6
.INCLUDE				VIXCITCADAST_TAB	0
CITYCODE	City Code		REXCITCITYCODE	CHAR	8
ADMINDIVISION	Administrative Division		REXCITADMDIV	CHAR	20
CENSUSDIVISION	Census Division		REXCITCENSUSDIV	CHAR	20
CITYDIVISION	City Division		REXCITCITYDIV	CHAR	20
SHEET	Sheet		REXCITSHEET	CHAR	20
PARCEL	Parcel		REXCITPARCEL	CHAR	20
QUALITY	Quality		REXCITICIQUALITY	CHAR	50
DENOMINATOR	Denominator		REXCITDENOMINATOR	CHAR	20
SUBALTERN	Subordinate		REXCITSUBALTERN	CHAR	20
CLASS	Class of Buildings		REXCITICICLASS	NUMC	4
UIUOBJNR	Object Number		RECAOBJNR	CHAR	44	*
UIUINTRENO	Intreno of U.I.U		REXCUIUINTRENO	CHAR	26
ORIGAOID	Original AO's AOID		REXCITORIGAOID	CHAR	60
DERIVAOID	Derivate AO's AOID		REXCITDERIVAOID	CHAR	60
.INCLUDE				VIXCITICIDATA_TAB	0
CURRENCY	Currency Key		WAERS	CUKY	10	TCURC
DATETO	Date: Valid To		RECADATETO	DATS	16
ICIAMOUNT	ICI/IMU Tax Amount		REXCITICIAMOUNT	CURR	8
POSTALCODE	City postal code		AD_PSTCD1	CHAR	20
CITY	City		AD_CITY1	CHAR	80	TIVXCITICIPARAM
ICIRATE	ICI/IMU Rate		REXCITICIRATE	DEC	3
ISMANUALRATE	Manually Entered Tax Rate Differs		REXCITISMANUALRATE	CHAR	2
ICICOLLECTOR	Name of the Tax Collector		REXCITICICOLLECTOR	CHAR	120
ACCNO	Account number		REXCITACCNO	CHAR	20
CATID	Cadastral Category ID		REXCITCATID	CHAR	8
CATCOEFF	Category Coefficient		REXCITCATCOEFF	DEC	3
CALCTYPE	Calculation Type		REXCITCALCTYPE	CHAR	4
AOVALUE	Value of Architectural Object		REXCITAOVALUE	CURR	8
BASEAMOUNT	Base amount		REXCITBASEAMOUNT	CURR	8
TAXBASE	Taxable Amount		REXCITICITAXBASE	CURR	8
MONOWN	Period of ownership		REXCITMONOWN	NUMC	4
PERCOWN	Ownership Percentage		REXCITPERCOWN	DEC	4
MONEXCL	Months of exclusion		REXCITMONEXCL	NUMC	4
DETRAMOUNT	Detraction Amount		REXCITDETRAMOUNT	CURR	8
DETRACTPREC	Detraction Percentage		REXCITDETRACTPREC	DEC	3
RAISPERC	Percentage Increase		REXCITRAISPERC	DEC	3
ISANNUALPAY	One Annual Payment (Without Down Payment)		REXCITISANNUALPAY	CHAR	2
DATPRI	Due Date of First Installment (Down Payment)		REXCITDATPRI	DATS	16
INSTPRIPAID	First Installment (Down Payment) Paid		REXCITINSTPRIPAID	CHAR	2
DOWNPAYMENT	Down Payment		REXCITDOWNPAYM	CURR	8
DATSEC	Due Date of Second Installment Payment		REXCITDATSEC	DATS	16
BALANCE	Balance		REXCITBALANCE	CURR	8
ISACTIVEICI	ICI/IMU/TASI Record Locked for Recalculation		REXCITISACTIVEICI	CHAR	2
ASSIGINTRENO	Assigned real estate object		REXCITASSIGINTRENO	CHAR	26
ASSIGOBJNR	Object Number		RECAOBJNR	CHAR	44	*
BUKRS	Company Code		BUKRS	CHAR	8	T001
IS_EXEMPT	Exemption Status		REXCITISEXEMPT	CHAR	2
IS_UNINHABIT	Uninhabitable Building		REXCITISUNINHABIT	CHAR	2
IS_HISTORIC	Historical Object		REXCITHISTORIC	CHAR	2
COUNTRYRATE	IMU Country/Region Rate		REXCITIMUCNTRYRATE	DEC	3
CITYRATE	IMU City Rate		REXCITIMUCITYRATE	DEC	3
DOWNPAYMENTCITY	Down Payment to City		REXCITDOWNPAYMCITY	CURR	8
DOWNPAYMENTCNTRY	Down Payment to Country/Region		REXCITDOWNPAYMCNTRY	CURR	8
BALANCECITY	Balance to City		REXCITBALANCECITY	CURR	8
BALANCECOUNTRY	Balance to Country/Region		REXCITBALANCECNTRY	CURR	8
CITYAMOUNT	ICI/IMU City Tax Amount		REXCITCITYAMOUNT	CURR	8
COUNTRYAMOUNT	ICI/IMU Country Tax Amount		REXCITCNTRYAMOUNT	CURR	8
REDUCTION	Reduction ID		REXCITREDUCTION	CHAR	4	TIVXCITREDUCT
NOIMUCALC	No IMU Calculation		REXCITNOIMUCALC	CHAR	2