VIXCESIBIDATA - IBI master data

IBI master data information is stored in SAP table VIXCESIBIDATA.
It is part of development package GLO_REFX_ES_RA in software component FI-LOC. This development package consists of objects that can be grouped under "Localization Flexible Real Estate Spain".

Fields for table VIXCESIBIDATA

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	3	*
.INCLUDE	KEY	X		VIXCESIBIDATA_KEY	0
INTRENO	Internal Key of Real Estate Object	X	RECAINTRENO	CHAR	13
DATEFROM	Date: Valid From	X	RECADATEFROM	DATS	8
.INCLUDE	DATA			VIXCESIBIDATA_TAB	0
BUKRS	Company Code		BUKRS	CHAR	4	*
CURRENCY	Currency Key		WAERS	CUKY	5	TCURC
DATETO	Date: Valid To		RECADATETO	DATS	8
IBIAMOUNT	Property Tax Amount		REXCESIBIAMOUNT	CURR	8
IBICALCAMOUNT	Calculated Property Tax Amount		REXCESIBICALCAMOUNT	CURR	8
CITY	Municipality Code		REXCESMUNICIPALITY	CHAR	5
IBIRATE	Property Tax Rate		REXCESIBIRATE	DEC	3
ISMANUALAMOUNT	Tax Amount Entered Manually		REXCESISMANUALAMOUNT	CHAR	1
VPT	Tax Base Amount		REXCESVPT	CURR	8
TAXCATID	Property Tax Category		REXCESTAXCAT	CHAR	4
.INCLUDE				REXCESDISCHRG	0
DISCHRGID	Tax Discount Code		REXCESDISCHRGID	CHAR	4	*
DISCHRGAMNT	Discount Amount		REXCESDISCHRGAMNT	CURR	8
DSCNTAPPL	Applicable Tax Discount Rate		REXCESDSCNTAPPL	DEC	3
.INCLUDE				REXCESSURCHRG	0
SURCHRGID	Surcharge Code		REXCESSURCHRGID	CHAR	4	TIVXCESPTSURCHRT
SURCHRGFROM	Valid From Date of Surcharge Calculation		REXCESSURCHRGFROM	DATS	8
SURCHRGAMNT	Surcharge Amount		REXCESSURCHRGAMNT	CURR	8
.INCLUDE				REXCESIBIINSTLMNT	0
INSTDATE1	Due Date of Installment		REXCESINSTDATE	DATS	8
INSTAMOUNT1	Amount of Installment		REXCESINSTAMOUNT	CURR	8
INSTDATE2	Due Date of Installment		REXCESINSTDATE	DATS	8
INSTAMOUNT2	Amount of Installment		REXCESINSTAMOUNT	CURR	8
INSTDATE3	Due Date of Installment		REXCESINSTDATE	DATS	8
INSTAMOUNT3	Amount of Installment		REXCESINSTAMOUNT	CURR	8
INSTDATE4	Due Date of Installment		REXCESINSTDATE	DATS	8
INSTAMOUNT4	Amount of Installment		REXCESINSTAMOUNT	CURR	8
INSTDATE5	Due Date of Installment		REXCESINSTDATE	DATS	8
INSTAMOUNT5	Amount of Installment		REXCESINSTAMOUNT	CURR	8
INSTDATE6	Due Date of Installment		REXCESINSTDATE	DATS	8
INSTAMOUNT6	Amount of Installment		REXCESINSTAMOUNT	CURR	8
INSTDATE7	Due Date of Installment		REXCESINSTDATE	DATS	8
INSTAMOUNT7	Amount of Installment		REXCESINSTAMOUNT	CURR	8
INSTDATE8	Due Date of Installment		REXCESINSTDATE	DATS	8
INSTAMOUNT8	Amount of Installment		REXCESINSTAMOUNT	CURR	8
INSTDATE9	Due Date of Installment		REXCESINSTDATE	DATS	8
INSTAMOUNT9	Amount of Installment		REXCESINSTAMOUNT	CURR	8
INSTDATE10	Due Date of Installment		REXCESINSTDATE	DATS	8
INSTAMOUNT10	Amount of Installment		REXCESINSTAMOUNT	CURR	8
INSTDATE11	Due Date of Installment		REXCESINSTDATE	DATS	8
INSTAMOUNT11	Amount of Installment		REXCESINSTAMOUNT	CURR	8
INSTDATE12	Due Date of Installment		REXCESINSTDATE	DATS	8
INSTAMOUNT12	Amount of Installment		REXCESINSTAMOUNT	CURR	8
ISRECORDLOCKED	IBI Record Locked for Recalculation		REXCESISIBIRECORDLOCKED	CHAR	1
ACCTASSIGOBJNR	Account Assignment Object Number		REXCESACCASSOBJNR	CHAR	22	*
LIABLE_TAX	Liable Property Tax Amount		REXCESLIABLETAX	CURR	8
AWKEY1	Reference Key		REXCESAWKEY	CHAR	20
AWTYP1	Reference procedure		AWTYP	CHAR	5	*
AWKEY2	Reference Key		REXCESAWKEY	CHAR	20
AWTYP2	Reference procedure		AWTYP	CHAR	5	*
AWKEY3	Reference Key		REXCESAWKEY	CHAR	20
AWTYP3	Reference procedure		AWTYP	CHAR	5	*
AWKEY4	Reference Key		REXCESAWKEY	CHAR	20
AWTYP4	Reference procedure		AWTYP	CHAR	5	*
AWKEY5	Reference Key		REXCESAWKEY	CHAR	20
AWTYP5	Reference procedure		AWTYP	CHAR	5	*
AWKEY6	Reference Key		REXCESAWKEY	CHAR	20
AWTYP6	Reference procedure		AWTYP	CHAR	5	*
AWKEY7	Reference Key		REXCESAWKEY	CHAR	20
AWTYP7	Reference procedure		AWTYP	CHAR	5	*
AWKEY8	Reference Key		REXCESAWKEY	CHAR	20
AWTYP8	Reference procedure		AWTYP	CHAR	5	*
AWKEY9	Reference Key		REXCESAWKEY	CHAR	20
AWTYP9	Reference procedure		AWTYP	CHAR	5	*
AWKEY10	Reference Key		REXCESAWKEY	CHAR	20
AWTYP10	Reference procedure		AWTYP	CHAR	5	*
AWKEY11	Reference Key		REXCESAWKEY	CHAR	20
AWTYP11	Reference procedure		AWTYP	CHAR	5	*
AWKEY12	Reference Key		REXCESAWKEY	CHAR	20
AWTYP12	Reference procedure		AWTYP	CHAR	5	*
PARTNER	Business Partner Number		BU_PARTNER	CHAR	10	*
.INCLUDE	RUSER			RUSER	0
RERF	Entered By		RERF	CHAR	12
DERF	First Entered On		DERF	DATS	8
TERF	Time of Creation		TERF	TIMS	6
REHER	Source of Initial Entry		REHER	CHAR	10
RBEAR	Employee ID		RBEAR	CHAR	12
DBEAR	Last Edited On		DBEAR	DATS	8
TBEAR	Last Edited At		TBEAR	TIMS	6
RBHER	Editing Source		RBHER	CHAR	10