SAP ABAP Table VIXCESIBIDATA (IBI master data)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ GLO_REFX_ES_RA (Package) Localization Flexible Real Estate Spain

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VIXCESIBIDATA	Table Relationship Diagram
Short Description	IBI master data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	.INCLUDE	☑				0	0	Key for IBI master data (VIXCESIBIDATA)
3	INTRENO	☑	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
4	DATEFROM	☑	RECADATEFROM	RECADATEBEG	DATS	8	0	Date: Valid From
5	.INCLUDE	☐				0	0	IBI Data - data fields
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
7	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
8	DATETO	☐	RECADATETO	RECADATEEND	DATS	8	0	Date: Valid To
9	IBIAMOUNT	☐	REXCESIBIAMOUNT	RECACURR	CURR	15	2	Property Tax Amount
10	IBICALCAMOUNT	☐	REXCESIBICALCAMOUNT	RECACURR	CURR	15	2	Calculated Property Tax Amount
11	CITY	☐	REXCESMUNICIPALITY		CHAR	5	0	Municipality Code
12	IBIRATE	☐	REXCESIBIRATE	REXCESRATE	DEC	5	2	Property Tax Rate
13	ISMANUALAMOUNT	☐	REXCESISMANUALAMOUNT	RECABOOL	CHAR	1	0	Tax Amount Entered Manually
14	VPT	☐	REXCESVPT	RECACURR	CURR	15	2	Tax Base Amount
15	TAXCATID	☐	REXCESTAXCAT	REXCESPROPTAXCAT	CHAR	4	0	Property Tax Category
16	.INCLUDE	☐				0	0	Discharge
17	DISCHRGID	☐	REXCESDISCHRGID	CHAR4	CHAR	4	0	Tax Discount Code	*
18	DISCHRGAMNT	☐	REXCESDISCHRGAMNT	RECACURR	CURR	15	2	Discount Amount
19	DSCNTAPPL	☐	REXCESDSCNTAPPL	REXCESRATE	DEC	5	2	Applicable Tax Discount Rate
20	.INCLUDE	☐				0	0	Surcharge
21	SURCHRGID	☐	REXCESSURCHRGID	CHAR4	CHAR	4	0	Surcharge Code	TIVXCESPTSURCHRT
22	SURCHRGFROM	☐	REXCESSURCHRGFROM	RECADATE	DATS	8	0	Valid From Date of Surcharge Calculation
23	SURCHRGAMNT	☐	REXCESSURCHRGAMNT	RECACURR	CURR	15	2	Surcharge Amount
24	.INCLUDE	☐				0	0	IBI Installments
25	INSTDATE1	☐	REXCESINSTDATE	RECADATE	DATS	8	0	Due Date of Installment
26	INSTAMOUNT1	☐	REXCESINSTAMOUNT	RECACURR	CURR	15	2	Amount of Installment
27	INSTDATE2	☐	REXCESINSTDATE	RECADATE	DATS	8	0	Due Date of Installment
28	INSTAMOUNT2	☐	REXCESINSTAMOUNT	RECACURR	CURR	15	2	Amount of Installment
29	INSTDATE3	☐	REXCESINSTDATE	RECADATE	DATS	8	0	Due Date of Installment
30	INSTAMOUNT3	☐	REXCESINSTAMOUNT	RECACURR	CURR	15	2	Amount of Installment
31	INSTDATE4	☐	REXCESINSTDATE	RECADATE	DATS	8	0	Due Date of Installment
32	INSTAMOUNT4	☐	REXCESINSTAMOUNT	RECACURR	CURR	15	2	Amount of Installment
33	INSTDATE5	☐	REXCESINSTDATE	RECADATE	DATS	8	0	Due Date of Installment
34	INSTAMOUNT5	☐	REXCESINSTAMOUNT	RECACURR	CURR	15	2	Amount of Installment
35	INSTDATE6	☐	REXCESINSTDATE	RECADATE	DATS	8	0	Due Date of Installment
36	INSTAMOUNT6	☐	REXCESINSTAMOUNT	RECACURR	CURR	15	2	Amount of Installment
37	INSTDATE7	☐	REXCESINSTDATE	RECADATE	DATS	8	0	Due Date of Installment
38	INSTAMOUNT7	☐	REXCESINSTAMOUNT	RECACURR	CURR	15	2	Amount of Installment
39	INSTDATE8	☐	REXCESINSTDATE	RECADATE	DATS	8	0	Due Date of Installment
40	INSTAMOUNT8	☐	REXCESINSTAMOUNT	RECACURR	CURR	15	2	Amount of Installment
41	INSTDATE9	☐	REXCESINSTDATE	RECADATE	DATS	8	0	Due Date of Installment
42	INSTAMOUNT9	☐	REXCESINSTAMOUNT	RECACURR	CURR	15	2	Amount of Installment
43	INSTDATE10	☐	REXCESINSTDATE	RECADATE	DATS	8	0	Due Date of Installment
44	INSTAMOUNT10	☐	REXCESINSTAMOUNT	RECACURR	CURR	15	2	Amount of Installment
45	INSTDATE11	☐	REXCESINSTDATE	RECADATE	DATS	8	0	Due Date of Installment
46	INSTAMOUNT11	☐	REXCESINSTAMOUNT	RECACURR	CURR	15	2	Amount of Installment
47	INSTDATE12	☐	REXCESINSTDATE	RECADATE	DATS	8	0	Due Date of Installment
48	INSTAMOUNT12	☐	REXCESINSTAMOUNT	RECACURR	CURR	15	2	Amount of Installment
49	ISRECORDLOCKED	☐	REXCESISIBIRECORDLOCKED	RECABOOL	CHAR	1	0	IBI Record Locked for Recalculation
50	ACCTASSIGOBJNR	☐	REXCESACCASSOBJNR	J_OBJNR	CHAR	22	0	Account Assignment Object Number	*
51	LIABLE_TAX	☐	REXCESLIABLETAX	RECACURR	CURR	15	2	Liable Property Tax Amount
52	AWKEY1	☐	REXCESAWKEY	AWKEY	CHAR	20	0	Reference Key
53	AWTYP1	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
54	AWKEY2	☐	REXCESAWKEY	AWKEY	CHAR	20	0	Reference Key
55	AWTYP2	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
56	AWKEY3	☐	REXCESAWKEY	AWKEY	CHAR	20	0	Reference Key
57	AWTYP3	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
58	AWKEY4	☐	REXCESAWKEY	AWKEY	CHAR	20	0	Reference Key
59	AWTYP4	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
60	AWKEY5	☐	REXCESAWKEY	AWKEY	CHAR	20	0	Reference Key
61	AWTYP5	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
62	AWKEY6	☐	REXCESAWKEY	AWKEY	CHAR	20	0	Reference Key
63	AWTYP6	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
64	AWKEY7	☐	REXCESAWKEY	AWKEY	CHAR	20	0	Reference Key
65	AWTYP7	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
66	AWKEY8	☐	REXCESAWKEY	AWKEY	CHAR	20	0	Reference Key
67	AWTYP8	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
68	AWKEY9	☐	REXCESAWKEY	AWKEY	CHAR	20	0	Reference Key
69	AWTYP9	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
70	AWKEY10	☐	REXCESAWKEY	AWKEY	CHAR	20	0	Reference Key
71	AWTYP10	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
72	AWKEY11	☐	REXCESAWKEY	AWKEY	CHAR	20	0	Reference Key
73	AWTYP11	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
74	AWKEY12	☐	REXCESAWKEY	AWKEY	CHAR	20	0	Reference Key
75	AWTYP12	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
76	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
77	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
78	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
79	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
80	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
81	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
82	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
83	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
84	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
85	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIXCESIBIDATA	CURRENCY	TCURC	WAERS	REF	1	CN
2	VIXCESIBIDATA	SURCHRGID	TIVXCESPTSURCHRT	SURCHRGID	REF	1	CN

History

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