VIXCITICIDATA - ICI master data

ICI master data information is stored in SAP table VIXCITICIDATA.
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 VIXCITICIDATA

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
.INCLUDE	KEY	X		VIXCITICIDATA_KEY	0
INTRENO	Internal Key of Real Estate Object	X	RECAINTRENO	CHAR	26	VIBDAO
DATEFROM	Date: Valid From	X	RECADATEFROM	DATS	16
.INCLUDE	DATA			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
.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
.INCLUDE	CI_VIXCITICIDATA			CI_VIXCITICIDATA	0