SAP ABAP Table RFVIAR02 (RE: REse@rch - Maintenance Structure for Table VIAR02)

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	RFVIAR02	Table Relationship Diagram
Short Description	RE: REse@rch - Maintenance Structure for Table VIAR02

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	RE: REse@rch - RE Requests
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	SIDGDEMAND	☐	RESADSGDEMAND	RESADSGDEMAND	CHAR	20	0	Rental Request Identification (Global ID)	*
4	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
5	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
6	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
7	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
8	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
9	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
10	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
11	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
12	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
13	JDELETE	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
14	SPARTID	☐	RESADSPARTID	RESADSPARTID	CHAR	10	0	Identification of Offering/Searching Party (User ID)	VIAR03
15	SIDLDEMAND	☐	RESADSLDEMAND	RESADSLIDENT	CHAR	35	0	Rental Request Identification (Local ID)
16	SOBJGROUP	☐	RESADSOBJGROUP	RESADSOBJGROUP	NUMC	2	0	Rental object group	TIVAR02
17	XMEMOTEXT	☐	RESADXMEMOTEXT	RESADXMEMOTEXT	CHAR	85	0	Memo Text For The Request (User-Defined Text)
18	DFREEFROM	☐	RESADDFREEFROMDE	DATS	DATS	8	0	Occup.as from
19	DFREETILL	☐	RESADDFREETILLDE	DATS	DATS	8	0	Limited lease in until
20	CURRKEY	☐	RESADCURRKEY	WAERS	CUKY	5	0	Currency	TCURC
21	AREAKEY	☐	RESADAREAKEY	MEINS	UNIT	3	0	Area unit	T006
22	SAQUISIT	☐	RESADSAQUISIT	RESADSAQUISIT	CHAR	1	0	Acquisition Form (Rent or Purchase)
23	PRENTEXCL	☐	RESADPRENTEXCL	RESADPRENTALL	CURR	13	2	Total Net Monthly Rent
24	PRENTINCL	☐	RESADPRENTINCL	RESADPRENTALL	CURR	13	2	Total Gross Monthly Rent
25	PRENTAREAEXCL	☐	RESADPRENTAREAEXCL	RESADPRENTAREA	CURR	13	2	Net Rent per Area Unit and Year
26	PRENTAREAINCL	☐	RESADPRENTAREAINCL	RESADPRENTAREA	CURR	13	2	Gross Rent per Area Unit and Year
27	PSIZEALL	☐	RESADPSIZEALL	VVBFLART	QUAN	14	4	Total area
28	PSIZEUSE	☐	RESADPSIZEUSE	VVBFLART	QUAN	14	4	Residential/Usable Space
29	NROOMFULL	☐	RESADNROOMFULL	RESADNROOMFULL	NUMC	2	0	Number of Full Rooms
30	NROOMHALF	☐	RESADNROOMHALF	RESADNROOMHALF	NUMC	1	0	Number of Half Rooms
31	SFLOORCOD	☐	RESADSFLOORCOD	RESADSFLOORCOD	NUMC	1	0	Floor Selection
32	JFLOOREXC	☐	RESADJFLOOREXC	XFELD	CHAR	1	0	Exclude Floor
33	SLOCALGRP	☐	RESADSLOCALGRP	RESADSLOCALGRP	NUMC	1	0	District Location Group Rental Request	TIVAR14
34	STRAFFROU	☐	RESADSTRAFFROU		NUMC	1	0	Transport connections	TIVAR06
35	DBUILDDAT	☐	RESADDBUILDDAT	DATS	DATS	8	0	Building date
36	DRSTORDAT	☐	RESADRSTORDAT	DATS	DATS	8	0	Modernization Date
37	SAGEGROUP	☐	RESADSAGEGROUP	RESADSNEWBUILD	CHAR	1	0	Building Age Class
38	CFAFCODE	☐	RESADCFAFCODE	RESADCFAFCODE	CHAR	20	0	Fixtures and Fittings Characteristic String
39	SPARKGRP	☐	RESADSPARKGRP	RESADSPARKGRP	NUMC	2	0	Group of Real Estate Object Parking Spaces	TIVAR12
40	OCCUPOBLIGO	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
41	OCCUPOBLIGO2	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
42	OCCUPOBLIGO3	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
43	OCCUPOBLIGO4	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
44	JISPUBLIC	☐	RESADJISPUBLIC	XFELD	CHAR	1	0	Offer is Available
45	JAUTOINFO	☐	RESADJAUTOINFO	XFELD	CHAR	1	0	Automatic Notification
46	ZIPSTRING	☐	RESADZIPSTRING	RESADZIPSTRING	CHAR	35	0	Character String With Zip Code Details For Rental Request
47	.INCLUDE	☐				0	0	RE: REse@rch - Location Description
48	SCOUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
49	SREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
50	SCOUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
51	SCITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
52	ZIPCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
53	LOCATION	☐	ORT01_GP	TEXT35	CHAR	35	0	City
54	SUBLOCAT	☐	ORT02_GP	TEXT35	CHAR	35	0	District
55	STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
56	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
57	AUTHGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
58	PROCESSMARK	☐	VVIBEARKZ	CHAR4	CHAR	4	0	Processing Indicator for Rental Request	TIVC1
59	PRESELECTION	☐	VVIVORMKZ	CHAR4	CHAR	4	0	Preselection Indicator for Rental Request	TIVC2
60	PROCESSSTAT	☐	VVIBSTAT	CHAR4	CHAR	4	0	Rental Request Processing Status	TIVC3
61	PARTFROM	☐	VVIPARTFROM	CHAR4	CHAR	4	0	Source of Prospect	TIVP1
62	PARTWHY	☐	VVIPARTWHY	CHAR4	CHAR	4	0	Reason for Acquisition	TIVP2
63	PARTWAY	☐	VVIWAY	CHAR4	CHAR	4	0	Enquiry method	TIVP3
64	DAPPLY	☐	DEINB	DDAT	DATS	8	0	Date application was received
65	SCRDSTNDG	☐	SBONI	SBONI	NUMC	2	0	Credit standing application	TIV62
66	XCRDSTNDG	☐	XWBONI	XTEXT50	CHAR	50	0	Reason for credit standing
67	NNUMPERS	☐	APERS	DEC3	DEC	3	0	Number of persons
68	XPASSPORT	☐	XPASSNR	CHAR18	CHAR	18	0	Passport number
69	DPASSSUB	☐	DPASSV	DDAT	DATS	8	0	Date of submission of passport
70	JWBS	☐	JWBS	XFELD	CHAR	1	0	Indicator: Accommodation entitlement certificate exists
71	DWBS	☐	WBSDATUM	DATUM	DATS	8	0	Accommodation entitlement certificate from
72	DWBSVALID	☐	WBSGUELT	DATUM	DATS	8	0	Accommodation entitlement certificate valid to
73	DWBSREFUSE	☐	WBSABL	DATUM	DATS	8	0	Accommodation entitlement certificate refused on
74	WBSPRIORITY	☐	VVWBSDRING	CHAR4	CHAR	4	0	Priority for accommodation entitlement certificate	TIVB7
75	WBSPERSON	☐	WBSPERS	CHAR4	CHAR	4	0	Accomm.entitlement certif: Special group of people	TIVB8
76	WBSAPPEND	☐	WBSZUS	CHAR8	CHAR	8	0	Additional information for accomm.entitlemnt certif.	TIVB9
77	WBSNROOMFULL	☐	WBSAZIMM	DEC3	DEC	3	0	No. of rooms acc.to accommodation entitlement certificate
78	WBSNROOMHALF	☐	WBSAHALBZI	DEC2	DEC	2	0	Half room acc.to accommodation entitlement certificate
79	WBSAREAKEY	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
80	WBSPSIZE	☐	WBSFQM	VVBFLART	QUAN	14	4	Area factor acc.to accommodation entitlement certificate
81	WBSREFERENCE	☐	WBSGS	TEXT20	CHAR	20	0	Accommodation entitlement certificate reference no.
82	WBSMEMO	☐	WBSINFO	TEXT40	CHAR	40	0	Memo on accommodation entitlement certificate
83	INCOME_CUR	☐	VVINCOME_CUR	WAERS	CUKY	5	0	Currency of Net Income	TCURC
84	NET_INCOME	☐	VVNET_INCOME	WERTV8	CURR	15	2	Annual Net Income
85	NATION	☐	VVNATION	LAND1	CHAR	3	0	Nationality	T005
86	PARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
87	SBWNR	☐	SBWNR	SBWNR	NUMC	7	0	Application number	VIMI11
88	SMIWUNR	☐	SMIWUNR	SMIWUNR	NUMC	3	0	Rent request number	VIMI12
89	CHNGIND	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
90	JMARKED	☐	RESADJMARKED	XFELD	CHAR	1	0	REsearch: Line is selected
91	PCORREL	☐	RESADPCORREL	RESADPCORREL	DEC	5	2	REsearch: Penalty Amount For Offer And Request
92	JFAVORIT	☐	RESADJFAVORIT	XFELD	CHAR	1	0	Entry Is In Favorite List
93	YOBJBUILD	☐	RESADYOBJBUILD	GJAHR	NUMC	4	0	Construction Year of Real Estate Object
94	YOBJRSTOR	☐	RESADYOBJRSTOR	GJAHR	NUMC	4	0	Modernization Year of Real Estate Object
95	XOBJGROUP	☐	RESADXOBJGROUP	RESADXOBJGROUP	CHAR	30	0	Object Group Text
96	XADDRESS	☐	RESADXADDRESS	RESADXADDRESS	CHAR	50	0	Address of Real Estate Object
97	XFLOORCOD	☐	RESADXFLOORCOD	DDTEXT	CHAR	60	0	Floor Group Text
98	XLOCALGRP	☐	RESADXLOCALGRP	RESADXLOCALGRP	CHAR	30	0	District Location Group Text
99	XTRAFFROU	☐	RESADXTRAFFROU	XTEXT30	CHAR	30	0	Text for Transport Connections
100	XPARKGRP	☐	RESADXPARKGRP	RESADXPARKGRP	CHAR	30	0	Text For Group of Real Estate Object Parking Spaces
101	XAGEGROUP	☐	RESADXAGEGROUP	DDTEXT	CHAR	60	0	Building Age Class Text
102	XBELBIND1	☐	XKBELBEZ	XKBEZ	CHAR	15	0	Occupancy obligation short text
103	XBELBIND2	☐	XKBELBEZ	XKBEZ	CHAR	15	0	Occupancy obligation short text
104	XBELBIND3	☐	XKBELBEZ	XKBEZ	CHAR	15	0	Occupancy obligation short text
105	XBELBIND4	☐	XKBELBEZ	XKBEZ	CHAR	15	0	Occupancy obligation short text
106	XROOMDATA	☐	RESADXROOMDATA		CHAR	10	0	Room Details Listed as "<Whole Rooms>/"<Half Rooms>"
107	XFAVICON	☐	RESADXFAVICON	ICON	CHAR	4	0	Entry Available in Favorites (Icon)	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RFVIAR02	AREAKEY	T006	MSEHI	KEY	1	CN
2	RFVIAR02	CURRKEY	TCURC	WAERS	KEY	1	CN
3	RFVIAR02	INCOME_CUR	TCURC	WAERS	KEY	1	CN
4	RFVIAR02	MANDT	T000	MANDT	KEY	1	CN
5	RFVIAR02	NATION	T005	LAND1	KEY	1	CN
6	RFVIAR02	OCCUPOBLIGO	TIV31	RBELBIND	KEY	1	CN
7	RFVIAR02	OCCUPOBLIGO2	TIV31	RBELBIND	KEY	1	CN
8	RFVIAR02	OCCUPOBLIGO3	TIV31	RBELBIND	KEY	1	CN
9	RFVIAR02	OCCUPOBLIGO4	TIV31	RBELBIND	KEY	1	CN
10	RFVIAR02	PARTFROM	TIVP1	PARTFROM	KEY	1	CN
11	RFVIAR02	PARTNR	BP000	PARTNR	KEY	1	CN
12	RFVIAR02	PARTWAY	TIVP3	WAY	KEY	1	CN
13	RFVIAR02	PARTWHY	TIVP2	PARTWHY	KEY	1	CN
14	RFVIAR02	PRESELECTION	TIVC2	VORMKZ	KEY	1	CN
15	RFVIAR02	PROCESSMARK	TIVC1	BEARKZ	KEY	1	CN
16	RFVIAR02	PROCESSSTAT	TIVC3	BSTAT	KEY	1	CN
17	RFVIAR02	SBWNR	VIMI11	SBWNR	KEY	1	CN
18	RFVIAR02	SCITYC	T005G	CITYC	KEY	1	CN
19	RFVIAR02	SCOUNC	T005E	COUNC	KEY	1	CN
20	RFVIAR02	SCOUNTRY	T005	LAND1	KEY	1	CN
21	RFVIAR02	SCRDSTNDG	TIV62	SBONI	KEY	1	CN
22	RFVIAR02	SLOCALGRP	TIVAR14	SLOCALGRP	KEY	1	CN
23	RFVIAR02	SMIWUNR	VIMI12	SMIWUNR	KEY	1	CN
24	RFVIAR02	SOBJGROUP	TIVAR02	SOBJGROUP	KEY	1	CN
25	RFVIAR02	SPARKGRP	TIVAR12	SPARKGRP	KEY	1	CN
26	RFVIAR02	SPARTID	VIAR03	SPARTID	KEY	1	CN
27	RFVIAR02	SREGIO	T005S	BLAND	KEY	1	CN
28	RFVIAR02	STRAFFROU	TIVAR06	STRAFFROU	KEY	1	CN
29	RFVIAR02	WBSAPPEND	TIVB9	WBSZUS	KEY	1	CN
30	RFVIAR02	WBSAREAKEY	T006	MSEHI	KEY	1	CN
31	RFVIAR02	WBSPERSON	TIVB8	WBSPERS	KEY	1	CN
32	RFVIAR02	WBSPRIORITY	TIVB7	WBSDRING	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in