SAP ABAP Table AVIXCITCADRO (Change Document Structure Cadaster master data (VIXCITCADRO))

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	AVIXCITCADRO	Table Relationship Diagram
Short Description	Change Document Structure Cadaster master data (VIXCITCADRO)

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	Temporary rental object data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	.INCLUDE	☐				0	0	Key for Cadaster temporary data of AO merging/splitting (VIX
4	PROCESSID	☐	REXCITCADPROC	VVSSOLLID	NUMC	8	0	ID of Splitting/Merging Process
5	KEY_DATE	☐	DATUM	DATUM	DATS	8	0	Date
6	ORIG_INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
7	NEW_INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
8	.INCLUDE	☐				0	0	Rental object
9	CADOPERATION	☐	REXCITCADOP	REXCITCADOP	CHAR	1	0	Process Type with Architectural Object
10	.INCLUDE	☐				0	0	Rental Object: Non-Key Fields
11	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
12	IMKEY	☐	RECAIMKEY	IMKEY	CHAR	8	0	Internal Key of Real Estate Object (FI)
13	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
14	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
15	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
16	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
17	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
18	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
19	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
20	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
21	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
22	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
23	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
24	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
25	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
26	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
27	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
28	ROTYPE	☐	REBDROTYPE	REBDROTYPE	CHAR	2	0	Rental Object Type
29	SNUNR	☐	REBDUSAGETYPE	SNUNR	NUMC	4	0	Usage Type of Rental Object	TIV01
30	XMETXT	☐	REBDXRO	RECAXLDESCRIPTION	CHAR	60	0	Rental Object Name
31	SGRNR	☐	REBDPRNO	REBDPRNO	CHAR	8	0	Number of Land
32	SGENR	☐	REBDBUNO	REBDBUNO	CHAR	8	0	Number of Building
33	SALTNR	☐	SALTNR	SALTNR	CHAR	20	0	Number of rental unit in existing real estate system
34	CANBECOMMON	☐	REBDCANBECOMMON	RECABOOL	CHAR	1	0	Common Usage Possible
35	FIRSTPOSTING	☐	RECDCFSTARTFROM	RECADATE	DATS	8	0	Cash Flow Generated Starting On
36	DBEZU	☐	DBEZU	DDAT	DATS	8	0	Date of initial usage
37	DWTVERM	☐	DWTVERM	DATUM	DATS	8	0	Date: Subsequent rental
38	DRESAB	☐	DRESA	DDAT	DATS	8	0	Date: Reserved from
39	DRESBIS	☐	DRESB	DDAT	DATS	8	0	Date: Reserved upto
40	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
41	RLRAFIXFITCATE	☐	REAJRLRAFIXFITCATE	REAJRLRAFIXFITCATE	CHAR	6	0	Fixtures and Fittings Category	TIVAJRLRAFFCT
42	RLRALOC	☐	REAJRLRALOC	REAJRLRALOC	CHAR	6	0	Location Class	TIVAJRLRALOC
43	PZUABSP	☐	REBDSUREPERCENT	REBDSUREPERCENT	DEC	4	2	Increase or Reduction for Representative List of Rents
44	SPOSINMSP	☐	REBDRLRABASEIND	REAJRLRAADJMBASE	CHAR	1	0	Method for Calculating Base Rent of Rep. List of Rents
45	PPOSINMSP	☐	REBDRLRAPERCENT	DECV3_2	DEC	5	2	Percentage for Positioning RU in RLR Spread
46	PERHOE	☐	PERHOE	DEC3_2	DEC	5	2	Percentage rate increase
47	RPROZGRD	☐	RPROZGRD	RPROZGRD	CHAR	2	0	Reason for variance in rate of percentage increase	TIV43
48	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	TIV38
49	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
50	JEIGWOHN	☐	VVJEIGWOHN	JANE	CHAR	1	0	Rental Unit in Separate Ownership (COA)
51	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
52	SSTCKBIS	☐	VVSSTCKBIS	VVSSTOCKW	NUMC	3	0	For RUs with Multiple Floors: Top Floor of RU	TIV37
53	DRESTAUR	☐	VVDRESTAUR	DATUM	DATS	8	0	Date of reconstruction/extensive modernization
54	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
55	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
56	CFPOSTINGFROM	☐	RECDCFPOSTINGFROM	RECADATE	DATS	8	0	First Posting From
57	HASCOP	☐	RESCHASCOP	RECABOOL	CHAR	1	0	Uses Current Occupancy Principle
58	RLRA	☐	REAJRLRA	REAJRLRA	CHAR	6	0	Representative List of Rents	TIVAJRLRA
59	USESRLRA	☐	REAJUSESRLRA	RECABOOL	CHAR	1	0	Representative List of Rents Is Used
60	BUILDYEAR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
61	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
62	COMMONOWNED	☐	REBDCOMMONOWNED	RECABOOL	CHAR	1	0	Rental Object Is Common Property
63	OOLOCK	☐	REOROOLOCK	RECABOOL	CHAR	1	0	Do Not Consider Object for Real Estate Search
64	NEIGHBORH1	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
65	NEIGHBORH2	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
66	NEIGHBORH3	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
67	.INCLUDE	☐				0	0
68	.INCLU--AP	☐				0	0	Country Specific fields for Switzerland
69	.INCLUDE	☐				0	0	Rental Object Customer fields
70	EDID	☐	REXCCHEDID	REXCCHEDID	NUMC	2	0	Federal Building Entrance Identification Number (EDID)
71	EGID	☐	REXCCHEGID	REXCCHEGID	NUMC	9	0	Federal Building Identification Number (EGID)
72	FLOOR	☐	REXCCHROFLOOR	REXCCHROFLOOR	NUMC	4	0	Code of Floor	*
73	FLOORLOC	☐	REXCCHROFLOORLOC	REXCCHROFLOORLOC	CHAR	40	0	Location of Dwelling on a Floor
74	EWID	☐	REXCCHEWID	REXCCHEWID	NUMC	3	0	Federal Dwelling Identification Number (EWID)
75	KITCHEN	☐	REXCCHROKITCHEN	REXCCHROKITCHEN	NUMC	4	0	Code of Cooking Facilities	*
76	ADMINNO	☐	REXCCHROADMINNO	REXCCHROADMINNO	CHAR	12	0	Administrative Dwelling Number
77	DOORNO	☐	REXCCHRODOORNO	REXCCHRODOORNO	CHAR	8	0	Door Number of Dwelling
78	OBJCOND	☐	REXCCHROCOND	REXCCHROCOND	NUMC	4	0	Code of Dwelling Status	*
79	YEARDECONSTR	☐	REXCCHBUDECONYEAR	DATUM	DATS	8	0	Year of Demolition
80	NUMROOMS	☐	REXCCHRONUMROOMS	REXCCHRONUMROOMS	NUMC	4	0	Number of Rooms in the Dwelling
81	LIVINGAREA	☐	REXCCHROAREA	REXCCHGWRFORMATUNITFIELD	DEC	10	2	Floor Area of Dwelling in M2
82	USAGETYPE	☐	REXCCHROUSAGETYPE	REXCCHROUSAGETYPE	NUMC	4	0	Code of Usage Type	*
83	GEMEINDECH	☐	RELMLRDISTRICT	RELMLRDISTRICT	CHAR	6	0	Land Register District	*
84	.INCLU--AP	☐				0	0	Country-Specific fields for Portugal
85	.INCLUDE	☐				0	0	Country-Specific Fields for Portugal - Rental Object
86	VPT	☐	REXCPTVPT_NOSIGN	REXCPTVPT_NOSIGN	CURR	15	2	Property Taxable Value
87	VPTCURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
88	CONDK	☐	REXCPTRACONS		CHAR	4	0	Conservation Level	TIVXCPTRACONS
89	.INCLUDE	☐				0	0	Structures for generating change document update programs
90	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	AVIXCITCADRO	CONDK	TIVXCPTRACONS	CONSLEVEL
2	AVIXCITCADRO	CURRENCY	TCURC	WAERS	KEY	1	CN
3	AVIXCITCADRO	NEIGHBORH1	TIVBDNEIGHBORH	NEIGHBORHOOD
4	AVIXCITCADRO	NEIGHBORH2	TIVBDNEIGHBORH	NEIGHBORHOOD
5	AVIXCITCADRO	NEIGHBORH3	TIVBDNEIGHBORH	NEIGHBORHOOD
6	AVIXCITCADRO	RESPONSIBLE	USR02	BNAME	REF	1	CN
7	AVIXCITCADRO	RLGESCH	TIV38	RLGESCH	REF	C	CN
8	AVIXCITCADRO	RLRA	TIVAJRLRA	RLRA	KEY	1	CN
9	AVIXCITCADRO	RLRAFIXFITCATE	TIVAJRLRAFFCT	RLRAFIXFITCATE	REF	C	CN
10	AVIXCITCADRO	RLRALOC	TIVAJRLRALOC	RLRALOC	REF	C	CN
11	AVIXCITCADRO	RPROZGRD	TIV43	RPROZGRD	KEY	1	CN
12	AVIXCITCADRO	SGEBT	TIV12	SGEBT	REF	C	CN
13	AVIXCITCADRO	SNUNR	TIV01	SNUNR
14	AVIXCITCADRO	SSTCKBIS	TIV37	SSTOCKW	REF	C	CN
15	AVIXCITCADRO	SSTOCKW	TIV37	SSTOCKW	REF	C	CN
16	AVIXCITCADRO	USEREXCLUSIVE	USR02	BNAME	REF	C	CN
17	AVIXCITCADRO	VPTCURRENCY	TCURC	WAERS

History

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