SAP ABAP Table REXCPTIMI_CP_L (IMI Data for the Cockpit)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	REXCPTIMI_CP_L	Table Relationship Diagram
Short Description	IMI Data for the Cockpit

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	IMI Data for detailed view in the BDT with additional data
2	.INCLUDE	☐				0	0	IMI Data
3	.INCLUDE	☐				0	0	IMI Master Data
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
5	.INCLUDE	☐				0	0	IMI Data - Key Fields
6	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object	VILMPL
7	DATEFROM	☐	REXCPTIMIDATEFROM	RECADATEBEG	DATS	8	0	Valid from date
8	.INCLUDE	☐				0	0	IMI Data - Data fields
9	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
10	DATETO	☐	REXCPTIMIDATETO	RECADATEEND	DATS	8	0	Valid to date
11	IMIAMOUNT	☐	REXCPTIMIAMOUNT	RECACURR	CURR	15	2	Municipal Property Tax Amount
12	CITY	☐	REXCPTMUNICIPALITY	REXCPTMUNICIPALITY	NUMC	4	0	Municipality Code
13	PARISH	☐	REXCPTPARISH	REXCPTPARISH	NUMC	6	0	Parish (Freguesia) Code
14	IMIRATE	☐	REXCPTIMIRATE	REXCPTRATE	DEC	5	2	Municipal Property Tax Rate
15	ISMANUALAMOUNT	☐	REXCPTISMANUALAMOUNT	RECABOOL	CHAR	1	0	Tax Amount Entered Manually
16	VPT	☐	REXCPTVPT	RECACURR	CURR	15	2	Property Taxable Value
17	TAXCATID	☐	REXCPTTAXCAT	REXCPTPROPTAXCAT	CHAR	4	0	Municipal Property Tax Category
18	ISRESIDENTIAL	☐	REXCPTISRESIDENTIAL	RECABOOL	CHAR	1	0	In Residential Use
19	STARTDATE_RES	☐	REXCPTSTARTDATE_RES	RECADATEBEG	DATS	8	0	Start Date of Tax Exemption
20	EXEMPTSTAT	☐	REXCPTEXEMPTSTAT	REXCPTEXEMPTSTAT	CHAR	1	0	Exemption Status
21	EXEMPTPERIODCAT	☐	REXCPTEXPERCAT	REXCPTEXPERCAT	CHAR	2	0	Exemption Period Category
22	FIRSTINSTDATE	☐	REXCPTFIRSTINSTDATE	RECADATE	DATS	8	0	Due Date of First Installment
23	FIRSTINSTAMOUNT	☐	REXCPTFIRSTINSTAMOUNT	RECACURR	CURR	15	2	Amount of First Installment
24	ISFIRSTINSTPAID	☐	REXCPTISFIRSTINSTPAID	RECABOOL	CHAR	1	0	First Installment Paid
25	SECINSTDATE	☐	REXCPTSECINSTDATE	RECADATE	DATS	8	0	Due Date of Second Installment
26	SECINSTAMOUNT	☐	REXCPTSECINSTAMOUNT	RECACURR	CURR	15	2	Amount of Second Installment
27	ISRECORDLOCKED	☐	REXCPTISIMIRECORDLOCKED	RECABOOL	CHAR	1	0	IMI Record Locked for Recalculation
28	ACCTASSIGOBJNR	☐	REXCPTACCASSOBJNR	J_OBJNR	CHAR	22	0	Account Assignment Object Number	*
29	LIABLE_TAX	☐	REXCPTLIABLETAX	RECACURR	CURR	15	2	Liable Property Tax Amount
30	CONSTRUCTIONDATE	☐	REXCPTCONSTDATE	RECADATE	DATS	8	0	Construction Date (of the assigned object)
31	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
32	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
33	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
34	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
35	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
36	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
37	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
38	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
39	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
40	XTAXCATID	☐	REXCPTXTAXCAT	RECAXLDESCRIPTION	CHAR	60	0	Description of Tax Category
41	EXPER	☐	REXCPTEXPER	INT4	INT4	10	0	Exemption Period
42	XEXPEMPTPERIODCAT	☐	REXCPTXTAXCAT	RECAXLDESCRIPTION	CHAR	60	0	Description of Tax Category
43	XMUNICIPALITY	☐	REXCPTXMUNICIPALITY	RECAXLDESCRIPTION	CHAR	60	0	Municipality Name
44	XPARISH	☐	REXCPTXPARISH	RECAXMDESCRIPTION	CHAR	30	0	Name of the Parish (freguesia)
45	ASSIGXIDENT	☐	REXCPTXIDENT	TEXT80	CHAR	80	0	Account Assignment Object
46	EXPERYEAR	☐	REXCPTEXYEAR	INT4	INT4	10	0	Current Year of Exemption Period
47	IMIAMOUNTYEAR	☐	REXCPTIMIAMOUNT	RECACURR	CURR	15	2	Municipal Property Tax Amount
48	CURRENCY2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
49	ASSIGNED	☐	RECABOOL	RECABOOL	CHAR	1	0	General Yes/No Field
50	.INCLUDE	☐				0	0	Parcel: Key Fields
51	LOCHIER	☐	RELMPLLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key of Parcel in Location Structure	TIVBDLOCHIER
52	PLSUBDIVNO	☐	RELMPLSUBDIVNO	RELMPLSUBDIVNO	CHAR	6	0	Tract Number
53	PLNO	☐	RELMPLNO	RELMPLNO	CHAR	20	0	Parcel Number
54	FISCYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
55	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
56	CALC_TAX_AMOUNT	☐	REXCPTCALCTAX	RECACURR	CURR	15	2	Calculated Property Tax
57	TAXDIFF	☐	REXCPTTAXDIFF	RECACURR	CURR	15	2	Property Tax Difference
58	RECNNR	☐	RECNNR	RECNNR	CHAR	13	0	Real Estate Contract Number
59	RECNOBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
60	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REXCPTIMI_CP_L	CURRENCY	TCURC	WAERS
2	REXCPTIMI_CP_L	INTRENO	VILMPL	INTRENO
3	REXCPTIMI_CP_L	LOCHIER	TIVBDLOCHIER	LOCHIER	KEY	1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in	603