SAP ABAP Table VIXCPTIMIDATA (IMI Master Data)

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	TRANSP	Transparent table
Transparent table	VIXCPTIMIDATA	Table Relationship Diagram
Short Description	IMI 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	IMI Data - Key Fields
3	INTRENO	☑	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object	VILMPL
4	DATEFROM	☑	REXCPTIMIDATEFROM	RECADATEBEG	DATS	8	0	Valid from date
5	.INCLUDE	☐				0	0	IMI Data - Data fields
6	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
7	DATETO	☐	REXCPTIMIDATETO	RECADATEEND	DATS	8	0	Valid to date
8	IMIAMOUNT	☐	REXCPTIMIAMOUNT	RECACURR	CURR	15	2	Municipal Property Tax Amount
9	CITY	☐	REXCPTMUNICIPALITY	REXCPTMUNICIPALITY	NUMC	4	0	Municipality Code
10	PARISH	☐	REXCPTPARISH	REXCPTPARISH	NUMC	6	0	Parish (Freguesia) Code
11	IMIRATE	☐	REXCPTIMIRATE	REXCPTRATE	DEC	5	2	Municipal Property Tax Rate
12	ISMANUALAMOUNT	☐	REXCPTISMANUALAMOUNT	RECABOOL	CHAR	1	0	Tax Amount Entered Manually
13	VPT	☐	REXCPTVPT	RECACURR	CURR	15	2	Property Taxable Value
14	TAXCATID	☐	REXCPTTAXCAT	REXCPTPROPTAXCAT	CHAR	4	0	Municipal Property Tax Category
15	ISRESIDENTIAL	☐	REXCPTISRESIDENTIAL	RECABOOL	CHAR	1	0	In Residential Use
16	STARTDATE_RES	☐	REXCPTSTARTDATE_RES	RECADATEBEG	DATS	8	0	Start Date of Tax Exemption
17	EXEMPTSTAT	☐	REXCPTEXEMPTSTAT	REXCPTEXEMPTSTAT	CHAR	1	0	Exemption Status
18	EXEMPTPERIODCAT	☐	REXCPTEXPERCAT	REXCPTEXPERCAT	CHAR	2	0	Exemption Period Category
19	FIRSTINSTDATE	☐	REXCPTFIRSTINSTDATE	RECADATE	DATS	8	0	Due Date of First Installment
20	FIRSTINSTAMOUNT	☐	REXCPTFIRSTINSTAMOUNT	RECACURR	CURR	15	2	Amount of First Installment
21	ISFIRSTINSTPAID	☐	REXCPTISFIRSTINSTPAID	RECABOOL	CHAR	1	0	First Installment Paid
22	SECINSTDATE	☐	REXCPTSECINSTDATE	RECADATE	DATS	8	0	Due Date of Second Installment
23	SECINSTAMOUNT	☐	REXCPTSECINSTAMOUNT	RECACURR	CURR	15	2	Amount of Second Installment
24	ISRECORDLOCKED	☐	REXCPTISIMIRECORDLOCKED	RECABOOL	CHAR	1	0	IMI Record Locked for Recalculation
25	ACCTASSIGOBJNR	☐	REXCPTACCASSOBJNR	J_OBJNR	CHAR	22	0	Account Assignment Object Number	*
26	LIABLE_TAX	☐	REXCPTLIABLETAX	RECACURR	CURR	15	2	Liable Property Tax Amount
27	CONSTRUCTIONDATE	☐	REXCPTCONSTDATE	RECADATE	DATS	8	0	Construction Date (of the assigned object)
28	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
29	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
30	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
31	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
32	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
33	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
34	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
35	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
36	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	VIXCPTIMIDATA	CURRENCY	TCURC	WAERS
2	VIXCPTIMIDATA	INTRENO	VILMPL	INTRENO

History

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