VIAR02 - RE: REse@rch - RE Requests

RE: REse@rch - RE Requests information is stored in SAP table VIAR02.
It is part of development package FVVI in software component RE. This development package consists of objects that can be grouped under "R/3 appl.dev. for Financial Assets Management: Real estate".

Fields for table VIAR02

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
SIDGDEMAND	Rental Request Identification (Global ID)	X	RESADSGDEMAND	CHAR	40
.INCLUDE	RUSER			RUSER	0
RERF	Entered By		RERF	CHAR	24
DERF	First Entered On		DERF	DATS	16
TERF	Time of Creation		TERF	TIMS	12
REHER	Source of Initial Entry		REHER	CHAR	20
RBEAR	Employee ID		RBEAR	CHAR	24
DBEAR	Last Edited On		DBEAR	DATS	16
TBEAR	Last Edited At		TBEAR	TIMS	12
RBHER	Editing Source		RBHER	CHAR	20
JDELETE	Real Estate Deletion Indicator/Flag		JLOESCH	CHAR	2
SPARTID	Identification of Offering/Searching Party (User ID)		RESADSPARTID	CHAR	20	VIAR03
SIDLDEMAND	Rental Request Identification (Local ID)		RESADSLDEMAND	CHAR	70
SOBJGROUP	Rental object group		RESADSOBJGROUP	NUMC	4	TIVAR02
XMEMOTEXT	Memo Text For The Request (User-Defined Text)		RESADXMEMOTEXT	CHAR	170
DFREEFROM	Occup.as from		RESADDFREEFROMDE	DATS	16
DFREETILL	Limited lease in until		RESADDFREETILLDE	DATS	16
CURRKEY	Currency		RESADCURRKEY	CUKY	10	TCURC
AREAKEY	Area unit		RESADAREAKEY	UNIT	6	T006
SAQUISIT	Acquisition Form (Rent or Purchase)		RESADSAQUISIT	CHAR	2
PRENTEXCL	Total Net Monthly Rent		RESADPRENTEXCL	CURR	7
PRENTINCL	Total Gross Monthly Rent		RESADPRENTINCL	CURR	7
PRENTAREAEXCL	Net Rent per Area Unit and Year		RESADPRENTAREAEXCL	CURR	7
PRENTAREAINCL	Gross Rent per Area Unit and Year		RESADPRENTAREAINCL	CURR	7
PSIZEALL	Total area		RESADPSIZEALL	QUAN	8
PSIZEUSE	Residential/Usable Space		RESADPSIZEUSE	QUAN	8
NROOMFULL	Number of Full Rooms		RESADNROOMFULL	NUMC	4
NROOMHALF	Number of Half Rooms		RESADNROOMHALF	NUMC	2
SFLOORCOD	Floor Selection		RESADSFLOORCOD	NUMC	2
JFLOOREXC	Exclude Floor		RESADJFLOOREXC	CHAR	2
SLOCALGRP	District Location Group Rental Request		RESADSLOCALGRP	NUMC	2	TIVAR14
STRAFFROU	Transport connections		RESADSTRAFFROU	NUMC	2	TIVAR06
DBUILDDAT	Building date		RESADDBUILDDAT	DATS	16
DRSTORDAT	Modernization Date		RESADRSTORDAT	DATS	16
SAGEGROUP	Building Age Class		RESADSAGEGROUP	CHAR	2
CFAFCODE	Fixtures and Fittings Characteristic String		RESADCFAFCODE	CHAR	40
SPARKGRP	Group of Real Estate Object Parking Spaces		RESADSPARKGRP	NUMC	4	TIVAR12
OCCUPOBLIGO	Occupancy obligation key		RBELBIND	CHAR	8	TIV31
OCCUPOBLIGO2	Occupancy obligation key		RBELBIND	CHAR	8	TIV31
OCCUPOBLIGO3	Occupancy obligation key		RBELBIND	CHAR	8	TIV31
OCCUPOBLIGO4	Occupancy obligation key		RBELBIND	CHAR	8	TIV31
JISPUBLIC	Offer is Available		RESADJISPUBLIC	CHAR	2
JAUTOINFO	Automatic Notification		RESADJAUTOINFO	CHAR	2
.INCLUDE				RFVISADOBJLOC	0
SCOUNTRY	Country/Region Key		LAND1	CHAR	6	T005
SREGIO	Region (State, Province, County)		REGIO	CHAR	6	T005S
SCOUNC	County Code		COUNC	CHAR	6	T005E
SCITYC	City Code		CITYC	CHAR	8	T005G
LOCATION	City		ORT01_GP	CHAR	70
SUBLOCAT	District		ORT02_GP	CHAR	70
STREET	Street and House Number		STRAS_GP	CHAR	70
INTRENO	Internal Real Estate Master Data Code		VVINTRENO	CHAR	26
AUTHGRP	Authorization group		VVBERGRP	CHAR	80
PROCESSMARK	Processing Indicator for Rental Request		VVIBEARKZ	CHAR	8	TIVC1
PRESELECTION	Preselection Indicator for Rental Request		VVIVORMKZ	CHAR	8	TIVC2
PROCESSSTAT	Rental Request Processing Status		VVIBSTAT	CHAR	8	TIVC3
PARTFROM	Source of Prospect		VVIPARTFROM	CHAR	8	TIVP1
PARTWHY	Reason for Acquisition		VVIPARTWHY	CHAR	8	TIVP2
PARTWAY	Enquiry method		VVIWAY	CHAR	8	TIVP3
DAPPLY	Date application was received		DEINB	DATS	16
SCRDSTNDG	Credit standing application		SBONI	NUMC	4	TIV62
XCRDSTNDG	Reason for credit standing		XWBONI	CHAR	100
NNUMPERS	Number of persons		APERS	DEC	2
XPASSPORT	Passport number		XPASSNR	CHAR	36
DPASSSUB	Date of submission of passport		DPASSV	DATS	16
JWBS	Indicator: Accommodation entitlement certificate exists		JWBS	CHAR	2
DWBS	Accommodation entitlement certificate from		WBSDATUM	DATS	16
DWBSVALID	Accommodation entitlement certificate valid to		WBSGUELT	DATS	16
DWBSREFUSE	Accommodation entitlement certificate refused on		WBSABL	DATS	16
WBSPRIORITY	Priority for accommodation entitlement certificate		VVWBSDRING	CHAR	8	TIVB7
WBSPERSON	Accomm.entitlement certif: Special group of people		WBSPERS	CHAR	8	TIVB8
WBSAPPEND	Additional information for accomm.entitlemnt certif.		WBSZUS	CHAR	16	TIVB9
WBSNROOMFULL	No. of rooms acc.to accommodation entitlement certificate		WBSAZIMM	DEC	2
WBSNROOMHALF	Half room acc.to accommodation entitlement certificate		WBSAHALBZI	DEC	2
WBSAREAKEY	Area Unit		FEINS	UNIT	6	T006
WBSPSIZE	Area factor acc.to accommodation entitlement certificate		WBSFQM	QUAN	8
WBSREFERENCE	Accommodation entitlement certificate reference no.		WBSGS	CHAR	40
WBSMEMO	Memo on accommodation entitlement certificate		WBSINFO	CHAR	80
INCOME_CUR	Currency of Net Income		VVINCOME_CUR	CUKY	10	TCURC
NET_INCOME	Annual Net Income		VVNET_INCOME	CURR	8
NATION	Nationality		VVNATION	CHAR	6	T005
PARTNR	Business Partner Number		BP_PARTNR	CHAR	20	BP000
SBWNR	Application number		SBWNR	NUMC	14	VIMI11
SMIWUNR	Rent request number		SMIWUNR	NUMC	6	VIMI12