SAP ABAP Table AVIXCITICIDATA (Change Document Structure ICI master data (VIXCITICIDATA))

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_XC_RA_IT (Package) RE: XC - Localisation of Flexible Real Estate for Italy

Basic Data

Table Category	INTTAB	Structure
Structure	AVIXCITICIDATA	Table Relationship Diagram
Short Description	Change Document Structure ICI master data (VIXCITICIDATA)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	ICI master data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	.INCLUDE	☐				0	0	Key for ICI master data (VIXCITICIDATA)
4	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object	VIBDAO
5	DATEFROM	☐	RECADATEFROM	RECADATEBEG	DATS	8	0	Date: Valid From
6	.INCLUDE	☐				0	0	ICI Data - data fields
7	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
8	DATETO	☐	RECADATETO	RECADATEEND	DATS	8	0	Date: Valid To
9	ICIAMOUNT	☐	REXCITICIAMOUNT	RECACURR	CURR	15	2	ICI/IMU Tax Amount
10	POSTALCODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code	*
11	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City	TIVXCITICIPARAM
12	ICIRATE	☐	REXCITICIRATE		DEC	5	2	ICI/IMU Rate
13	ISMANUALRATE	☐	REXCITISMANUALRATE	RECABOOL	CHAR	1	0	Manually entered ICI/IMU rate differs from auto. det. rate
14	ICICOLLECTOR	☐	REXCITICICOLLECTOR	RECAXLDESCRIPTION	CHAR	60	0	Name of the Tax Collector
15	ACCNO	☐	REXCITACCNO		CHAR	10	0	Account number
16	CATID	☐	REXCITCATID		CHAR	4	0	Cadastral Category ID	*
17	CATCOEFF	☐	REXCITCATCOEFF	REXCITRATEGT100	DEC	5	2	Category Coefficient
18	CALCTYPE	☐	REXCITCALCTYPE		CHAR	2	0	Calculation Type	*
19	AOVALUE	☐	REXCITAOVALUE	RECACURR	CURR	15	2	Value of Architectural Object
20	BASEAMOUNT	☐	REXCITBASEAMOUNT	RECACURR	CURR	15	2	Base amount
21	TAXBASE	☐	REXCITICITAXBASE	RECACURR	CURR	15	2	Taxable Amount
22	MONOWN	☐	REXCITMONOWN		NUMC	2	0	Period of ownership
23	PERCOWN	☐	REXCITPERCOWN	REXCITRATE	DEC	5	2	Ownership Percentage
24	MONEXCL	☐	REXCITMONEXCL		NUMC	2	0	Months of exclusion
25	DETRAMOUNT	☐	REXCITDETRAMOUNT	RECACURR	CURR	15	2	Detraction Amount
26	DETRACTPREC	☐	REXCITDETRACTPREC	REXCITRATE	DEC	5	2	Detraction Percentage
27	RAISPERC	☐	REXCITRAISPERC	REXCITRATE	DEC	5	2	Percentage Increase
28	ISANNUALPAY	☐	REXCITISANNUALPAY	RECABOOL	CHAR	1	0	One Annual Payment (Without Down Payment)
29	DATPRI	☐	REXCITDATPRI	RECADATE	DATS	8	0	Due Date of First Installment (Down Payment)
30	INSTPRIPAID	☐	REXCITINSTPRIPAID	RECABOOL	CHAR	1	0	First Installment (downpayment) Paid
31	DOWNPAYMENT	☐	REXCITDOWNPAYM	RECACURR	CURR	15	2	Down Payment
32	DATSEC	☐	REXCITDATSEC	RECADATE	DATS	8	0	Due Date of Second Installment Payment
33	BALANCE	☐	REXCITBALANCE	RECACURR	CURR	15	2	Balance
34	ISACTIVEICI	☐	REXCITISACTIVEICI	RECABOOL	CHAR	1	0	ICI/IMU Record Locked for Recalculation
35	ASSIGINTRENO	☐	REXCITASSIGINTRENO	RECAINTRENO	CHAR	13	0	Assigned real estate object
36	ASSIGOBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
37	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
38	IS_EXEMPT	☐	REXCITISEXEMPT	RECABOOL	CHAR	1	0	Exemption Status
39	IS_UNINHABIT	☐	REXCITISUNINHABIT	RECABOOL	CHAR	1	0	Uninhabitable Building
40	IS_HISTORIC	☐	REXCITHISTORIC	RECABOOL	CHAR	1	0	Historical Object
41	COUNTRYRATE	☐	REXCITIMUCNTRYRATE		DEC	5	2	IMU Country Rate
42	CITYRATE	☐	REXCITIMUCITYRATE		DEC	5	2	IMU City Rate
43	DOWNPAYMENTCITY	☐	REXCITDOWNPAYMCITY	RECACURR	CURR	15	2	Down Payment to City
44	DOWNPAYMENTCNTRY	☐	REXCITDOWNPAYMCNTRY	RECACURR	CURR	15	2	Down Payment to Country
45	BALANCECITY	☐	REXCITBALANCECITY	RECACURR	CURR	15	2	Balance to City
46	BALANCECOUNTRY	☐	REXCITBALANCECNTRY	RECACURR	CURR	15	2	Balance to Country
47	CITYAMOUNT	☐	REXCITCITYAMOUNT	RECACURR	CURR	15	2	ICI/IMU City Tax Amount
48	COUNTRYAMOUNT	☐	REXCITCNTRYAMOUNT	RECACURR	CURR	15	2	ICI/IMU Country Tax Amount
49	REDUCTION	☐	REXCITREDUCTION	CHAR2	CHAR	2	0	Reduction ID	TIVXCITREDUCT
50	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
51	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
52	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
53	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
54	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
55	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
56	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
57	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
58	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
59	.INCLUDE	☐				0	0
60	.INCLUDE	☐				0	0	Structures for generating change document update programs
61	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AVIXCITICIDATA	BUKRS	T001	BUKRS
2	AVIXCITICIDATA	CITY	TIVXCITICIPARAM	CITY
3	AVIXCITICIDATA	CURRENCY	TCURC	WAERS	REF
4	AVIXCITICIDATA	INTRENO	VIBDAO	INTRENO
5	AVIXCITICIDATA	MANDT	T000	MANDT	KEY
6	AVIXCITICIDATA	REDUCTION	TIVXCITREDUCT	REDUCTION		1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in	600