SAP ABAP Table REXCITCADAO_L (ALV output of AO splitting/merging)

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	REXCITCADAO_L	Table Relationship Diagram
Short Description	ALV output of AO splitting/merging

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	Key for Cadaster temporary data of AO merging/splitting (VIX
2	PROCESSID	☐	REXCITCADPROC	VVSSOLLID	NUMC	8	0	ID of Splitting/Merging Process
3	KEY_DATE	☐	DATUM	DATUM	DATS	8	0	Date
4	ORIG_INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
5	NEW_INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
6	.INCLUDE	☐				0	0	Architectural Object: Key
7	AOID	☐	REBDAOID	REBDAOID	CHAR	30	0	Identification of Architectural Object
8	ORIG_AOID	☐	REBDAOID	REBDAOID	CHAR	30	0	Identification of Architectural Object
9	ASSIGROTXT	☐	REBDXRO	RECAXLDESCRIPTION	CHAR	60	0	Rental Object Name
10	.INCLUDE	☐				0	0	Architectural object
11	CADOPERATION	☐	REXCITCADOP	REXCITCADOP	CHAR	1	0	Process Type with Architectural Object
12	.INCLUDE	☐				0	0	Architectural Object: Header
13	AOTYPE	☐	REBDAOTYPE	REBDAOTYPE	CHAR	4	0	Architectural Object Type	TIVBDAROBJTYPE
14	AONR	☐	REBDAONR	REBDAONR	CHAR	13	0	Number of Architectural Object
15	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
16	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
17	PARTSEPARATOR	☐	REBDPARTSEPARATOR	REBDPARTSEPARATOR	CHAR	10	0	AOID Code: Separator
18	PARTAOID	☐	REBDPARTAOID	REBDPARTAOID	CHAR	30	0	AOID Code
19	XAO	☐	REBDXAO	RECAXLDESCRIPTION	CHAR	60	0	Name of Architectural Object
20	AOFUNCTION	☐	REBDAOFUNCTION	REBDAOFUNCTION	CHAR	4	0	Function of Architectural Object	TIVBDARFUNC
21	USAGECOMMON	☐	REBDUSCOMMON	REBDUSCOMMON	CHAR	1	0	Common Usage
22	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
23	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
24	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
25	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
26	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
27	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
28	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
29	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
30	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
31	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
32	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
33	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
34	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
35	LASTRENO	☐	DRENOV	DATUM	DATS	8	0	Date of last redecoration
36	MEASSTRC	☐	REBDMEASSTRC	REBDMEASSTRC	CHAR	4	0	Measurement Structure	*
37	DOORPLT	☐	REBDDOORPLT	REBDDOORPLT	CHAR	15	0	Short description
38	.INCLUDE	☐				0	0	Architectural Object: Attributes of Business Entity
39	SINSTBEZ	☐	SINSTBEZ	SINSTBEZ	NUMC	5	0	Maintenance district	TIV16
40	SVERKEHR	☐	SVERKEHR	SVERKEHR	CHAR	1	0	Transport Connections of Business Entity	TIV44
41	SLAGEWE	☐	SLAGEWE	SLAGEWE	NUMC	4	0	Business entity location number	TIV10
42	SOBJLAGE	☐	RESOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator: District Location of Object	TIV45
43	.INCLUDE	☐				0	0	Architectural Object: Attributes of Property
44	RGRNART	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map	TIVC4
45	RBEPLAN	☐	RBEPLAN	XMBEZ	CHAR	30	0	Development plan
46	DBEPLAN	☐	DBEPLAN	DDAT	DATS	8	0	Date of development plan
47	RNBPLAN	☐	RNBPLAN	RGRNART	CHAR	4	0	Usage type according to development plan	TIVB3
48	XNUTZGRU	☐	XNUTZGRU	XMBEZ	CHAR	30	0	Current usage of property
49	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
50	JUNUTZA	☐	VVJUNUTZA	JANE	CHAR	1	0	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36
51	NZGRZ	☐	NZGRZ	DEC1_2	DEC	3	2	Permitted Usage: Site Occupancy Index
52	NZGFZ	☐	NZGFZ	DEC2_2	DEC	4	2	Permitted Usage: Floor Area Ratio
53	NZBMZ	☐	NZBMZ	DEC3_2	DEC	5	2	Permitted Usage: Construction Dimension Number
54	NTGRZ	☐	NTGRZ	DEC1_2	DEC	3	2	Actual Usage: Site Occupancy Index
55	NTGFZ	☐	NTGFZ	DEC2_2	DEC	4	2	Actual Usage: Floor Area Ratio
56	NTBMZ	☐	NTBMZ	DEC3_2	DEC	5	2	Actual Usage: Construction Dimension Number
57	SGRART	☐	VVSGRART	VVSGRART	NUMC	4	0	Property type	TIV56
58	SGRQAL	☐	VVSGRQAL	VVSGRQAL	NUMC	3	0	Property: Quality of location	TIV57
59	SGRFRM	☐	VVSGRFRM	VVSGRFRM	NUMC	3	0	Property ground type	TIV58
60	SGRGZS	☐	VVSGRGZS	VVSGRGZS	NUMC	3	0	Overall condition of property	TIV59
61	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
62	ZULBAUH	☐	REBDALLOWEDHEIGHT	REBDALLOWEDHEIGHT	INT2	5	0	Allowed Building Height (as Integer)
63	.INCLUDE	☐				0	0	Architectural Object: Attributes of Building
64	RGEBART	☐	RGEBART	SOBJART	NUMC	2	0	Type of building	TIV5A
65	RGEBZUST	☐	RGEBZUST	VVRZUSTAND	NUMC	2	0	General condition of building	TIV83
66	YBAUJAHR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
67	JNURJAHR	☐	VVJNURJ	JANE	CHAR	1	0	Indicator: Only regard construction date in terms of years
68	YMODERN	☐	VVYMODERN	DATUM	DATS	8	0	Year of modernization
69	YAUFBAU	☐	VVYAUFBAU	DATUM	DATS	8	0	Year of reconstruction
70	DBAUBEGI	☐	DBAUBEGI	DDAT	DATS	8	0	Construction start date
71	DBAUVOR	☐	DBAUVOR	DDAT	DATS	8	0	Date of planning inquiry
72	DVORBES	☐	DVORBES	DDAT	DATS	8	0	Date of prior notice
73	DANTBAU	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
74	DBAUGENE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
75	XBAUGENE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
76	DFERTIG	☐	DFERTIG	DDAT	DATS	8	0	Completion
77	DSCHLUSS	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
78	DBEZUGSF	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
79	RDAZUST	☐	RECADUMMYN2	NUMC2	NUMC	2	0	Dummy: No Longer Used
80	RFAZUST	☐	RECADUMMYN2	NUMC2	NUMC	2	0	Dummy: No Longer Used
81	JDENKMAL	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
82	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
83	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
84	BANZGE	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
85	AUGESCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
86	SSTCKBIS	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	TIV37
87	SLIFTBIS	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	TIV37
88	NSTCKLFT	☐	VVNSTCKLFT	NUMC3	NUMC	3	0	Number of highest floor reached by elevator
89	.INCLUDE	☐				0	0	Cadastral Master Data - data fields
90	CITYCODE	☐	REXCITCITYCODE	REXCITCITYCODE	CHAR	4	0	City Code
91	ADMINDIVISION	☐	REXCITADMDIV	REXCITADMDIV	CHAR	10	0	Administrative Division
92	CENSUSDIVISION	☐	REXCITCENSUSDIV	REXCITCENSUSDIV	CHAR	10	0	Census Division
93	CITYDIVISION	☐	REXCITCITYDIV	REXCITCITYDIV	CHAR	10	0	City Division
94	SHEET	☐	REXCITSHEET	REXCITSHEET	CHAR	10	0	Sheet
95	PARCEL	☐	REXCITPARCEL	REXCITPARCEL	CHAR	10	0	Parcel
96	QUALITY	☐	REXCITICIQUALITY	CHAR25	CHAR	25	0	Quality
97	DENOMINATOR	☐	REXCITDENOMINATOR	REXCITDENOMINATOR	CHAR	10	0	Denominator
98	SUBALTERN	☐	REXCITSUBALTERN	REXCITSUBALTERN	CHAR	10	0	Subordinate
99	CLASS	☐	REXCITICICLASS	NUMC2	NUMC	2	0	Class of Buildings
100	UIUOBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
101	UIUINTRENO	☐	REXCUIUINTRENO	RECAINTRENO	CHAR	13	0	Intreno of U.I.U
102	ORIGAOID	☐	REXCITORIGAOID	REBDAOID	CHAR	30	0	Original AO's AOID
103	DERIVAOID	☐	REXCITDERIVAOID	REBDAOID	CHAR	30	0	Derivate AO's AOID
104	.INCLUDE	☐				0	0	ICI Data - data fields
105	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
106	DATETO	☐	RECADATETO	RECADATEEND	DATS	8	0	Date: Valid To
107	ICIAMOUNT	☐	REXCITICIAMOUNT	RECACURR	CURR	15	2	ICI/IMU Tax Amount
108	POSTALCODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
109	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City	TIVXCITICIPARAM
110	ICIRATE	☐	REXCITICIRATE		DEC	5	2	ICI/IMU Rate
111	ISMANUALRATE	☐	REXCITISMANUALRATE	RECABOOL	CHAR	1	0	Manually entered ICI/IMU rate differs from auto. det. rate
112	ICICOLLECTOR	☐	REXCITICICOLLECTOR	RECAXLDESCRIPTION	CHAR	60	0	Name of the Tax Collector
113	ACCNO	☐	REXCITACCNO		CHAR	10	0	Account number
114	CATID	☐	REXCITCATID		CHAR	4	0	Cadastral Category ID
115	CATCOEFF	☐	REXCITCATCOEFF	REXCITRATEGT100	DEC	5	2	Category Coefficient
116	CALCTYPE	☐	REXCITCALCTYPE		CHAR	2	0	Calculation Type
117	AOVALUE	☐	REXCITAOVALUE	RECACURR	CURR	15	2	Value of Architectural Object
118	BASEAMOUNT	☐	REXCITBASEAMOUNT	RECACURR	CURR	15	2	Base amount
119	TAXBASE	☐	REXCITICITAXBASE	RECACURR	CURR	15	2	Taxable Amount
120	MONOWN	☐	REXCITMONOWN		NUMC	2	0	Period of ownership
121	PERCOWN	☐	REXCITPERCOWN	REXCITRATE	DEC	5	2	Ownership Percentage
122	MONEXCL	☐	REXCITMONEXCL		NUMC	2	0	Months of exclusion
123	DETRAMOUNT	☐	REXCITDETRAMOUNT	RECACURR	CURR	15	2	Detraction Amount
124	DETRACTPREC	☐	REXCITDETRACTPREC	REXCITRATE	DEC	5	2	Detraction Percentage
125	RAISPERC	☐	REXCITRAISPERC	REXCITRATE	DEC	5	2	Percentage Increase
126	ISANNUALPAY	☐	REXCITISANNUALPAY	RECABOOL	CHAR	1	0	One Annual Payment (Without Down Payment)
127	DATPRI	☐	REXCITDATPRI	RECADATE	DATS	8	0	Due Date of First Installment (Down Payment)
128	INSTPRIPAID	☐	REXCITINSTPRIPAID	RECABOOL	CHAR	1	0	First Installment (downpayment) Paid
129	DOWNPAYMENT	☐	REXCITDOWNPAYM	RECACURR	CURR	15	2	Down Payment
130	DATSEC	☐	REXCITDATSEC	RECADATE	DATS	8	0	Due Date of Second Installment Payment
131	BALANCE	☐	REXCITBALANCE	RECACURR	CURR	15	2	Balance
132	ISACTIVEICI	☐	REXCITISACTIVEICI	RECABOOL	CHAR	1	0	ICI/IMU Record Locked for Recalculation
133	ASSIGINTRENO	☐	REXCITASSIGINTRENO	RECAINTRENO	CHAR	13	0	Assigned real estate object
134	ASSIGOBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
135	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
136	IS_EXEMPT	☐	REXCITISEXEMPT	RECABOOL	CHAR	1	0	Exemption Status
137	IS_UNINHABIT	☐	REXCITISUNINHABIT	RECABOOL	CHAR	1	0	Uninhabitable Building
138	IS_HISTORIC	☐	REXCITHISTORIC	RECABOOL	CHAR	1	0	Historical Object
139	COUNTRYRATE	☐	REXCITIMUCNTRYRATE		DEC	5	2	IMU Country Rate
140	CITYRATE	☐	REXCITIMUCITYRATE		DEC	5	2	IMU City Rate
141	DOWNPAYMENTCITY	☐	REXCITDOWNPAYMCITY	RECACURR	CURR	15	2	Down Payment to City
142	DOWNPAYMENTCNTRY	☐	REXCITDOWNPAYMCNTRY	RECACURR	CURR	15	2	Down Payment to Country
143	BALANCECITY	☐	REXCITBALANCECITY	RECACURR	CURR	15	2	Balance to City
144	BALANCECOUNTRY	☐	REXCITBALANCECNTRY	RECACURR	CURR	15	2	Balance to Country
145	CITYAMOUNT	☐	REXCITCITYAMOUNT	RECACURR	CURR	15	2	ICI/IMU City Tax Amount
146	COUNTRYAMOUNT	☐	REXCITCNTRYAMOUNT	RECACURR	CURR	15	2	ICI/IMU Country Tax Amount
147	REDUCTION	☐	REXCITREDUCTION	CHAR2	CHAR	2	0	Reduction ID	TIVXCITREDUCT

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REXCITCADAO_L	AOFUNCTION	TIVBDARFUNC	AOFUNCTION	REF	1	CN
2	REXCITCADAO_L	AOTYPE	TIVBDAROBJTYPE	AOTYPE	KEY	1	CN
3	REXCITCADAO_L	BUKRS	T001	BUKRS
4	REXCITCADAO_L	CITY	TIVXCITICIPARAM	CITY
5	REXCITCADAO_L	CURRENCY	TCURC	WAERS	REF
6	REXCITCADAO_L	JERBBAU	TDO9	SOBJERBBAU	KEY	1	CN
7	REXCITCADAO_L	REDUCTION	TIVXCITREDUCT	REDUCTION		1	CN
8	REXCITCADAO_L	RESPONSIBLE	USR02	BNAME	REF	1	CN
9	REXCITCADAO_L	RGEBART	TIV5A	SOBJART	REF	C	CN
10	REXCITCADAO_L	RGEBZUST	TIV83	RZUSTAND	REF	C	CN
11	REXCITCADAO_L	RGRNART	TIVC4	RGRNART	KEY	1	CN
12	REXCITCADAO_L	RNBPLAN	TIVB3	RNBPLAN		1	CN
13	REXCITCADAO_L	SGRART	TIV56	SGRART	REF	C	CN
14	REXCITCADAO_L	SGRFRM	TIV58	SGRFRM	REF	C	CN
15	REXCITCADAO_L	SGRGZS	TIV59	SGRGZS	REF	C	CN
16	REXCITCADAO_L	SGRQAL	TIV57	SGRQAL	REF	C	CN
17	REXCITCADAO_L	SINSTBEZ	TIV16	SINSTBEZ	REF	C	CN
18	REXCITCADAO_L	SLAGEWE	TIV10	SLAGEWE	REF	C	CN
19	REXCITCADAO_L	SLIFTBIS	TIV37	SSTOCKW	REF	C	CN
20	REXCITCADAO_L	SOBJLAGE	TIV45	SOBJLAGE	REF	C	CN
21	REXCITCADAO_L	SSTCKBIS	TIV37	SSTOCKW	REF	C	CN
22	REXCITCADAO_L	SUNUTZA	TIV36	SUNART	REF	C	CN
23	REXCITCADAO_L	SVERKEHR	TIV44	SVERKEHR	REF	C	CN
24	REXCITCADAO_L	USEREXCLUSIVE	USR02	BNAME	REF	C	CN

History

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