SAP VIXCESIBIDATA IBI master data Table

Overview

VIXCESIBIDATA is a standard SAP S/4HANA table that stores IBI master data data. There are total 78 fields in the VIXCESIBIDATA table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VIXCESIBIDATA belongs to Localization (FI-LOC) module and is located in the package Localization Flexible Real Estate Spain (GLO_REFX_ES_RA).

In addition, following links provide an overview of foreign key relationships, if any, that link VIXCESIBIDATA to other SAP tables and standard CDS views available based on VIXCESIBIDATA table in S/4HANA 2020.

Techincal Settings of VIXCESIBIDATA

Below are technical details of the table VIXCESIBIDATA

Buffering not allowed
No buffering
Storage type is Column Store

List of VIXCESIBIDATA Fields

The following table gives you an overview of the fields available in VIXCESIBIDATA

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT	*	CLNT	3
INTRENO	Internal Key of Real Estate Object	RECAINTRENO		CHAR	13
DATEFROM	Date: Valid From	RECADATEFROM		DATS	8
BUKRS	Company Code	BUKRS	*	CHAR	4
CURRENCY	Currency Key	WAERS	TCURC	CUKY	5
DATETO	Date: Valid To	RECADATETO		DATS	8
IBIAMOUNT	Property Tax Amount	REXCESIBIAMOUNT		CURR	15
IBICALCAMOUNT	Calculated Property Tax Amount	REXCESIBICALCAMOUNT		CURR	15
IBIRATE	Property Tax Rate	REXCESIBIRATE		DEC	5
ISMANUALAMOUNT	Tax Amount Entered Manually	REXCESISMANUALAMOUNT		CHAR	1
VPT	Tax Base Amount	REXCESVPT		CURR	15
TAXCATID	Property Tax Category	REXCESTAXCAT		CHAR	4
DISCHRGID	Tax Discount Code	REXCESDISCHRGID	*	CHAR	4
DISCHRGAMNT	Discount Amount	REXCESDISCHRGAMNT		CURR	15
DSCNTAPPL	Applicable Tax Discount Rate	REXCESDSCNTAPPL		DEC	5
SURCHRGID	Surcharge Code	REXCESSURCHRGID	TIVXCESPTSURCHRT	CHAR	4
SURCHRGFROM	Valid From Date of Surcharge Calculation	REXCESSURCHRGFROM		DATS	8
SURCHRGAMNT	Surcharge Amount	REXCESSURCHRGAMNT		CURR	15
INSTDATE1	Due Date of Installment	REXCESINSTDATE		DATS	8
INSTAMOUNT1	Amount of Installment	REXCESINSTAMOUNT		CURR	15
INSTDATE2	Due Date of Installment	REXCESINSTDATE		DATS	8
INSTAMOUNT2	Amount of Installment	REXCESINSTAMOUNT		CURR	15
INSTDATE3	Due Date of Installment	REXCESINSTDATE		DATS	8
INSTAMOUNT3	Amount of Installment	REXCESINSTAMOUNT		CURR	15
INSTDATE4	Due Date of Installment	REXCESINSTDATE		DATS	8
INSTAMOUNT4	Amount of Installment	REXCESINSTAMOUNT		CURR	15
INSTDATE5	Due Date of Installment	REXCESINSTDATE		DATS	8
INSTAMOUNT5	Amount of Installment	REXCESINSTAMOUNT		CURR	15
INSTDATE6	Due Date of Installment	REXCESINSTDATE		DATS	8
INSTAMOUNT6	Amount of Installment	REXCESINSTAMOUNT		CURR	15
INSTDATE7	Due Date of Installment	REXCESINSTDATE		DATS	8
INSTAMOUNT7	Amount of Installment	REXCESINSTAMOUNT		CURR	15
INSTDATE8	Due Date of Installment	REXCESINSTDATE		DATS	8
INSTAMOUNT8	Amount of Installment	REXCESINSTAMOUNT		CURR	15
INSTDATE9	Due Date of Installment	REXCESINSTDATE		DATS	8
INSTAMOUNT9	Amount of Installment	REXCESINSTAMOUNT		CURR	15
INSTDATE10	Due Date of Installment	REXCESINSTDATE		DATS	8
INSTAMOUNT10	Amount of Installment	REXCESINSTAMOUNT		CURR	15
INSTDATE11	Due Date of Installment	REXCESINSTDATE		DATS	8
INSTAMOUNT11	Amount of Installment	REXCESINSTAMOUNT		CURR	15
INSTDATE12	Due Date of Installment	REXCESINSTDATE		DATS	8
INSTAMOUNT12	Amount of Installment	REXCESINSTAMOUNT		CURR	15
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	15
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
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

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIXCESIBIDATA

Table Name	Field	Cardinality	Check Table
VIXCESIBIDATA	CURRENCY	1: CN	TCURC
VIXCESIBIDATA	DISCHRGID	:	*
VIXCESIBIDATA	SURCHRGID	1: CN	TIVXCESPTSURCHRT

SAP VIXCESIBIDATA IBI master data Table

Overview

Techincal Settings of VIXCESIBIDATA

List of VIXCESIBIDATA Fields

Foreign Key Relationships

Other References