SAP ABAP Table REXCITICI_L (ICI List reporting)

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	REXCITICI_L	Table Relationship Diagram
Short Description	ICI List reporting

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

Foreign Keys

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

History

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