VIAR02

RE: REse@rch - RE Requests | #transactional | Component: Real Estate Management
Column Name Description
MANDT FK Client
SIDGDEMAND Rental Request Identification (Global ID)
Column Name Description
💲 Currency (CURRKEY):
PRENTEXCL Total Net Monthly Rent
PRENTINCL Total Gross Monthly Rent
PRENTAREAEXCL Net Rent per Area Unit and Year
PRENTAREAINCL Gross Rent per Area Unit and Year
💲 Currency of Net Income (INCOME_CUR):
NET_INCOME Annual Net Income
Column Name Description
📏 Area unit (AREAKEY):
PSIZEALL Total area
PSIZEUSE Residential/Usable Space
📏 Area Unit (WBSAREAKEY):
WBSPSIZE Area factor acc.to accommodation entitlement certificate
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DFREEFROM Occup.as from
DFREETILL Limited lease in until
DBUILDDAT Building date
DRSTORDAT Modernization Date
DAPPLY Date application was received
DPASSSUB Date of submission of passport
DWBS Accommodation entitlement certificate from
DWBSVALID Accommodation entitlement certificate valid to
DWBSREFUSE Accommodation entitlement certificate refused on
Column Name Description
SAQUISIT Acquisition Form (Rent or Purchase) Show values
NROOMFULL Number of Full Rooms Show values
NROOMHALF Number of Half Rooms Show values
SFLOORCOD Floor Selection Show values
JFLOOREXC Exclude Floor Show values
SAGEGROUP Building Age Class Show values
JISPUBLIC Offer is Available Show values
JAUTOINFO Automatic Notification Show values
JWBS Indicator: Accommodation entitlement certificate exists Show values
Column Name Description Domain name
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
JDELETE Real Estate Deletion Indicator/Flag JLOESCH
SIDLDEMAND Rental Request Identification (Local ID) RESADSLIDENT
XMEMOTEXT Memo Text For The Request (User-Defined Text) RESADXMEMOTEXT
CFAFCODE Fixtures and Fittings Characteristic String RESADCFAFCODE
ZIPSTRING Character String With Zip Code Details For Rental Request RESADZIPSTRING
ZIPCODE Postal Code PSTLZ
LOCATION City TEXT35
SUBLOCAT District TEXT35
STREET Street and House Number TEXT35
INTRENO Internal Real Estate Master Data Code VVINTRENO
AUTHGRP Authorization group VVBERGRP
XCRDSTNDG Reason for credit standing XTEXT50
NNUMPERS Number of persons DEC3
XPASSPORT Passport number CHAR18
WBSNROOMFULL No. of rooms acc.to accommodation entitlement certificate DEC3
WBSNROOMHALF Half room acc.to accommodation entitlement certificate DEC2
WBSREFERENCE Accommodation entitlement certificate reference no. TEXT20
WBSMEMO Memo on accommodation entitlement certificate TEXT40
Master Data Relations Join Conditions
Area unit
  • VIAR02.MANDT == T006.MANDT
  • VIAR02.AREAKEY == T006.MSEHI
Currency
  • VIAR02.MANDT == TCURC.MANDT
  • VIAR02.CURRKEY == TCURC.WAERS
Currency of Net Income
  • VIAR02.MANDT == TCURC.MANDT
  • VIAR02.INCOME_CUR == TCURC.WAERS
Client VIAR02.MANDT == T000.MANDT
Nationality
  • Nationality
  • Client
  • VIAR02.NATION == T005.LAND1
  • VIAR02.MANDT == T005.MANDT
Occupancy obligation key
  • VIAR02.MANDT == TIV31.MANDT
  • VIAR02.OCCUPOBLIGO == TIV31.RBELBIND
Occupancy obligation key
  • VIAR02.MANDT == TIV31.MANDT
  • VIAR02.OCCUPOBLIGO2 == TIV31.RBELBIND
Occupancy obligation key
  • VIAR02.MANDT == TIV31.MANDT
  • VIAR02.OCCUPOBLIGO3 == TIV31.RBELBIND
Occupancy obligation key
  • VIAR02.MANDT == TIV31.MANDT
  • VIAR02.OCCUPOBLIGO4 == TIV31.RBELBIND
Source of Prospect
  • VIAR02.MANDT == TIVP1.MANDT
  • VIAR02.PARTFROM == TIVP1.PARTFROM
Business Partner Number
  • VIAR02.MANDT == BP000.MANDT
  • VIAR02.PARTNR == BP000.PARTNR
Enquiry method
  • Enquiry method
  • Client
  • VIAR02.PARTWAY == TIVP3.WAY
  • VIAR02.MANDT == TIVP3.MANDT
Reason for Acquisition
  • Reason for Acquisition
  • Client
  • VIAR02.PARTWHY == TIVP2.PARTWHY
  • VIAR02.MANDT == TIVP2.MANDT
Preselection Indicator for Rental Request
  • VIAR02.MANDT == TIVC2.MANDT
  • VIAR02.PRESELECTION == TIVC2.VORMKZ
Processing Indicator for Rental Request
  • VIAR02.MANDT == TIVC1.MANDT
  • VIAR02.PROCESSMARK == TIVC1.BEARKZ
Rental Request Processing Status
  • VIAR02.MANDT == TIVC3.MANDT
  • VIAR02.PROCESSSTAT == TIVC3.BSTAT
Application number
City Code
  • Region (State, Province, County)
  • City Code
  • Client
  • Country/Region Key
  • VIAR02.SREGIO == T005G.REGIO
  • VIAR02.SCITYC == T005G.CITYC
  • VIAR02.MANDT == T005G.MANDT
  • VIAR02.SCOUNTRY == T005G.LAND1
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • VIAR02.MANDT == T005E.MANDT
  • VIAR02.SCOUNC == T005E.COUNC
  • VIAR02.SCOUNTRY == T005E.LAND1
  • VIAR02.SREGIO == T005E.REGIO
Country/Region Key
  • Country/Region Key
  • Client
  • VIAR02.SCOUNTRY == T005.LAND1
  • VIAR02.MANDT == T005.MANDT
Credit standing application
  • Credit standing application
  • Client
  • VIAR02.SCRDSTNDG == TIV62.SBONI
  • VIAR02.MANDT == TIV62.MANDT
District Location Group Rental Request
Rent request number
  • Application number
  • Rent request number
  • VIAR02.MANDT == VIMI12.MANDT
  • VIAR02.SBWNR == VIMI12.SBWNR
  • VIAR02.SMIWUNR == VIMI12.SMIWUNR
Rental object group
Group of Real Estate Object Parking Spaces
  • Group of Real Estate Object Parking Spaces
  • Client
Identification of Offering/Searching Party (User ID)
  • VIAR02.MANDT == VIAR03.MANDT
  • VIAR02.SPARTID == VIAR03.SPARTID
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • VIAR02.MANDT == T005S.MANDT
  • VIAR02.SCOUNTRY == T005S.LAND1
  • VIAR02.SREGIO == T005S.BLAND
Transport connections
Additional information for accomm.entitlemnt certif.
  • Additional information for accomm.entitlemnt certif.
  • Client
  • VIAR02.WBSAPPEND == TIVB9.WBSZUS
  • VIAR02.MANDT == TIVB9.MANDT
Area Unit
  • VIAR02.MANDT == T006.MANDT
  • VIAR02.WBSAREAKEY == T006.MSEHI
Accomm.entitlement certif: Special group of people
  • VIAR02.MANDT == TIVB8.MANDT
  • VIAR02.WBSPERSON == TIVB8.WBSPERS
Priority for accommodation entitlement certificate
  • VIAR02.MANDT == TIVB7.MANDT
  • VIAR02.WBSPRIORITY == TIVB7.WBSDRING