SAP ABAP Table VIRPRE1 (Real estate: CO reporting, master data)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM (Application Component) Customer Relationship Management
⤷

CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷

FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	INTTAB	Structure
Structure	VIRPRE1	Table Relationship Diagram
Short Description	Real estate: CO reporting, master data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	*
2	OBART	J_OBART	J_OBART	CHAR	2	0	Object Type	*
3	OBJNR	J_OBJNREXT	J_OBJNREXT	CHAR	22	0	Object
4	OBJNRX	VVJ_OBJNRX	VVJ_OBJNRX	CHAR	30	0	Object no: Real estate extended object number reporting
5	OBJNRX2	VVJ_OBJNR2	VVJ_OBJNR2	CHAR	30	0	Object no: Real Estate extended object number (partner)
6	GJAHR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	PERIO	JAHRPER	JAHRPER	NUMC	7	0	Period/year
8	PERDE	PERIODE	NUM3	NUMC	3	0	Period
9	DSTICH	VVDSTICH	DATUM	DATS	8	0	Key date
10	ANLKL	ANLKL	ANLKL	CHAR	8	0	Asset Class	*
11	AFAPL	AFAPL	AFAPL	CHAR	4	0	Chart of depreciaton for asset valuation	*
12	AFABE	AFABE_D	AFABE	NUMC	2	0	Real depreciation area	*
13	E_SMIVE	VVESMIVE	VVSMIVE	CHAR	13	0	Contract No. of Collective Lease-Outs
14	IND_SECTOR	VVMVINDSEC	BRSCH	CHAR	4	0	Industry of master tenant	*
15	KSTAR	KSTAR	KSTAR	CHAR	10	0	Cost Element	*
16	SKOART	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	*
17	SFLART	SFLART	SFLART	NUMC	4	0	Area type	*
18	SNUNR	SNUNR	SNUNR	NUMC	4	0	Rental unit external usage type	*
19	SMVART	SMVART	SMVART	CHAR	4	0	External Real Estate contract type	*
20	SSTDORT	VVSSTDORT	VVSSTDORT	CHAR	10	0	Regional location	*
21	SLAGEWE	SLAGEWE	SLAGEWE	NUMC	4	0	Business entity location number	*
22	SOBJLAGE	RESOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator: District Location of Object	*
23	SBAUJAHR	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
24	TXT04	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
25	BKOND	VVBKOND	WRTV7	CURR	13	2	Condition: amount
26	BKOND_A	VVBKONDA	WRTV7	CURR	13	2	Condition (in display currency)
27	BKONDMAX	VVBKONDMAX	WRTV7	CURR	13	2	Maximum condition
28	BKONDMAX_A	VVBKONDMXA	WRTV7	CURR	13	2	Maximum condition (in display currency)
29	BKONDMAXR	VVBKONDMAXR	WRTV7	CURR	13	2	Relative maximum condition
30	BKONDMAXR_A	VVBKONDMAXR_A	WRTV7	CURR	13	2	Relative maximum condition (in display currency)
31	BKONDMIN	VVBKONDMIN	WRTV7	CURR	13	2	Minimum condition
32	BKONDMIN_A	VVBKONDMIA	WRTV7	CURR	13	2	Minimum condition (in display currency)
33	BKONDMINR	VVBKONDMINR	WRTV7	CURR	13	2	Relative minimum condition
34	BKONDMINR_A	VVBKONDMINR_A	WRTV7	CURR	13	2	Relative minimum condition (in display currency)
35	WRTTP	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
36	VERSN	VERSN	COVERSI	CHAR	3	0	Version	TKVS
37	WKGXXX	VVWKGXXX	WERTV8	CURR	15	2	Value/CACur
38	WTGXXX	VVWTGXXX	WERTV8	CURR	15	2	Value TCur
39	WOGXXX	VVWOGXXX	WERTV8	CURR	15	2	Value OCur
40	WKGMAX	VVWKGMAX	WERTV8	CURR	15	2	Maximum value controlling area currency
41	WKGMAXR	VVWKGMAXR	WERTV8	CURR	15	2	Relative maximum value in controlling area currency
42	WKGMIN	VVWKGMIN	WERTV8	CURR	15	2	Minimum value CACur
43	WKGMINR	VVWKGMINR	WERTV8	CURR	15	2	Relative minimum value in CACur value
44	WAERS	WAERS	WAERS	CUKY	5	0	Currency Key	*
45	FQMFLART	VVBFLART	VVBFLART	QUAN	14	4	Area of area type
46	FEINS	FEINS	MEINS	UNIT	3	0	Area unit	*
47	SABRG	SABRG	SABRG	NUMC	4	0	Apportionment unit	*
48	BABRE	VVBABRE	VVBABRE	QUAN	14	4	Settlement units
49	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
50	BMWST	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
51	BMWST_A	VVBMWSTA	WRTV7	CURR	13	2	Value-added tax amount included (in displaly currency)
52	AMMRHY	VVAMMRHY	NUMC03	NUMC	3	0	Number of months in period
53	SKAUTART	SKAUA	SKAUA	CHAR	1	0	Type of Rental Collateral	*
54	BKAUTION	BKAUT	WRTV7	CURR	13	2	Security deposit amount
55	BKAUTION_A	VVBKAUTA	WRTV7	CURR	13	2	Deposit amount (in display currency)
56	ISTAT	VVISTAT	J_ISTAT	CHAR	5	0	Occupancy type	*
57	FQMFLART_A	VVBFLART_A	VVBFLART	QUAN	14	4	Area (display unit)
58	FEINS_A	VVFEINS_A	MEINS	UNIT	3	0	Area unit (for display)	*
59	WKGXXX_A	VVWKGXXX_A	WERTV8	CURR	15	2	Value CCurrency (in display currency)
60	WTGXXX_A	VVWTGXXX_A	WERTV8	CURR	15	2	Value TCurr (in display currency)
61	WOGXXX_A	VVWOGXXX_A	WERTV8	CURR	15	2	Value OCurr (in display currency)
62	WKGMAX_A	VVWKGMAX_A	WERTV8	CURR	15	2	Maxumum value CCurr (in display currency)
63	WKGMAXR_A	VVWKGMAXR_A	WERTV8	CURR	15	2	Relative maximum value CCurrency (in display currency)
64	WKGMIN_A	VVWKGMIN_A	WERTV8	CURR	15	2	Minimum value CACur (in display currency)
65	WKGMINR_A	VVWKGMINR_A	WERTV8	CURR	15	2	Relative minimum value CACur (in display currency)
66	WAERS_A	VVWAERS_A	WAERS	CUKY	5	0	Currency key (for display)	*
67	OBJCNT	VVOBJCNT	VVOBJCNT	QUAN	6	0	Number of real estate objects
68	GJE_BCHWRT	GJE_BCHWRT	ANLKWERT	CURR	13	2	Asset net book value at end of fiscal year
69	GJE_BCHWRT_A	VVGJE_BCHW_A	ANLKWERT	CURR	13	2	Asset book value at fiscal year end (display currency)
70	ANSW_GJE	ANSW_GJE	ANLKWERT	CURR	13	2	Acquisition value at fiscal year end
71	ANSW_GJE_A	VVANSW_GJE_A	ANLKWERT	CURR	13	2	Fiscal year end acquisition value (display currency)
72	AFA_GJE	AFA_GJE	ANLKWERT	CURR	13	2	Depreciation at fiscal year end
73	AFA_GJE_A	VVAFA_GJE_A	ANLKWERT	CURR	13	2	Fiscal year end depreciation (display currency)
74	NAFA_GJE	NAFA_GJE	ANLKWERT	CURR	13	2	Ordinary depreciation at fiscal year end
75	NAFA_GJE_A	VVNAFA_GJE_A	ANLKWERT	CURR	13	2	Fiscal year end ordinary depreciation (display currency)
76	KAAFA	KAAFA	ANLKWERT	CURR	13	2	Cumulative unplanned depreciation
77	KAAFA_A	VVKAAFA_A	ANLKWERT	CURR	13	2	Cumulative unplanned depreciation (display currency)
78	AAFAP	AAFAP	ANLKWERT	CURR	13	2	Scheduled unplanned depreciation for the year
79	AAFAP_A	VVAAFAP_A	ANLKWERT	CURR	13	2	Planned unplanned depreciation of year (display currency)
80	AAFAL	AAFAL	ANLKWERT	CURR	13	2	Proportional unplanned depreciation for the year
81	AAFAL_A	VVAAFAL_A	ANLKWERT	CURR	13	2	Prorated unplanned depreciation of year (display currency)
82	AAFAV	AAFAV	ANLKWERT	CURR	13	2	Proportional cumulative unplanned depreciation
83	AAFAV_A	VVAAFAV_A	ANLKWERT	CURR	13	2	Prorated cum. unplanned depreciaiton (display currency)
84	ZUSAA	DZUSAA	ANLKWERT	CURR	13	2	Write-up on unplanned depreciation
85	ZUSAA_A	VVZUSAA_A	ANLKWERT	CURR	13	2	Appreciations unplanned depreciations (display curency)
86	KSAFA	KSAFA	ANLKWERT	CURR	13	2	Cumulative special depreciation
87	KSAFA_A	VVKSAFA_A	ANLKWERT	CURR	13	2	Cumulative special depreciation (display currency)
88	SAFAP	SAFAP	ANLKWERT	CURR	13	2	Planned special depreciation for the year
89	SAFAP_A	VVSAFAP_A	ANLKWERT	CURR	13	2	Planned special depreciation of year (display currency)
90	SAFAL	SAFAL	ANLKWERT	CURR	13	2	Proportional special depreciation for the year
91	SAFAL_A	VVSAFAL_A	ANLKWERT	CURR	13	2	Prorated special depreciation of year (display currency)
92	SAFAV	SAFAV	ANLKWERT	CURR	13	2	Proportional cumulative special depreciation
93	SAFAV_A	VVSAFAV_A	ANLKWERT	CURR	13	2	Prorated cumulative special depreciation (display currency)
94	ZUSSA	DZUSSA	ANLKWERT	CURR	13	2	Write-up on special depreciation
95	ZUSSA_A	VVZUSSA_A	ANLKWERT	CURR	13	2	Appreciation special depreciation (display currency)
96	ANSWL	ANSWL	ANLKWERT	CURR	13	2	Transactions for the year affecting asset values
97	ANSWL_A	VVANSWL_A	ANLKWERT	CURR	13	2	Yearly flows affecting acquisition value (display currency)
98	ABGAN	ABGAN	ANLKWERT	CURR	13	2	Total retirements and retiring transfers
99	ABGAN_A	VVABGAN_A	ANLKWERT	CURR	13	2	Total retirements and retiring transfer postings (DispCurr)
100	OWNSHARE	VVOWNSH2	VVOWNER_SHARE2	QUAN	8	2	IPD: Ownership share in percentage
101	DEVELOP	VVDEVEL2	VVDEVELOPMENT2	QUAN	1	0	ROZ: Object in development
102	DEVMONTH	VVDEVMO2	VVDEVELOP_MONTH2	QUAN	2	0	ROZ: Number of months in development
103	DUMMEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
104	LEERGD	VVLEERGD	VVLEERGD	NUMC	2	0	Vacancy reason	*
105	.INCLUDE				0	0	Select.character.drilldown report from logical database IDF
106	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
107	BUKVW	VVBUKRSVW	BUKRS	CHAR	4	0	Company code of property manager	*
108	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
109	SWENR	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
110	SGRNR	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
111	SGENR	SGENR	SGENR	CHAR	8	0	Building Number	*
112	SMENR	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
113	SMIVE	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
114	SNKSL	SNKSL	SNKSL	CHAR	4	0	Service Charge Key	*
115	SEMPSL	SEMPSL	SEMPSL	CHAR	5	0	Settlement Unit	*
116	SVWNR	VVSVWNR	VVSVWNR	CHAR	13	0	Management Contract Number	*
117	SKOPO	VVSKOPO	VVSKOPO	NUMC	2	0	Detailed identification for condition items	*
118	STAGR	STAGR	STAGR	CHAR	6	0	Statistical key figure	*
119	SMEXXX	SMEXXX	CQUA8	QUAN	15	3	Statistical quantity
120	SMAXXX	SMAXXX	CQUA8	QUAN	15	3	Maximum statistical quantity
121	SKOTYP	SKOTYP	SKOTYP	NUMC	3	0	Condition category	*
122	VRGNG	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction	*
123	BEKNZ	BEKNZ	BEKNZ	CHAR	1	0	Debit/credit indicator
124	KOKRS	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
125	AZIMM	AZIMM	DEC3	DEC	3	0	Number of rooms
126	AHALBZI	AHALBZI	DEC2	DEC	2	0	Number of half rooms
127	PRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center	*