VIAR01

RE: REse@rch - Offered RE Objects | #masterdata | Component: Real Estate Management
Column Name Description
MANDT FK Client
SIDGSUPPLY Rental Unit 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
Column Name Description
πŸ“ Area unit (AREAKEY):
PSIZEALL Total area
PSIZEUSE Residential/Usable Space
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DFREEFROM Object Available From-Date
DFREETILL Object Available To-Date
DBUILDDAT Building date
DRSTORDAT Modernization Date
Column Name Description
JINTERNET Indicator Internet Release Show values
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
JWBSPREFERRED Accommodation Entitlement Certificate Is Advantageous 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
SIDLSUPPLY Rental Object (Local ID) RESADSLIDENT
XEYECATCH Short Description of Real Estate Object on Offer RESADXEYECATCH
CFAFCODE Fixtures and Fittings Characteristic String RESADCFAFCODE
ZIPCODE Postal Code PSTLZ
LOCATION City TEXT35
SUBLOCAT District TEXT35
STREET Street and House Number TEXT35
IMGDOCID01 Business Document Service: Document ID CHAR42
IMGDOCID02 Business Document Service: Document ID CHAR42
IMGDOCID03 Business Document Service: Document ID CHAR42
TXTDOCID Business Document Service: Document ID CHAR42
Master Data Relations Join Conditions
Area unit
  • VIAR01.MANDT == T006.MANDT
  • VIAR01.AREAKEY == T006.MSEHI
Currency
  • VIAR01.MANDT == TCURC.MANDT
  • VIAR01.CURRKEY == TCURC.WAERS
Client VIAR01.MANDT == T000.MANDT
Occupancy obligation key
  • VIAR01.MANDT == TIV31.MANDT
  • VIAR01.OCCUPOBLIGO == TIV31.RBELBIND
City Code
  • Region (State, Province, County)
  • City Code
  • Client
  • Country/Region Key
  • VIAR01.SREGIO == T005G.REGIO
  • VIAR01.SCITYC == T005G.CITYC
  • VIAR01.MANDT == T005G.MANDT
  • VIAR01.SCOUNTRY == T005G.LAND1
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • VIAR01.MANDT == T005E.MANDT
  • VIAR01.SCOUNC == T005E.COUNC
  • VIAR01.SCOUNTRY == T005E.LAND1
  • VIAR01.SREGIO == T005E.REGIO
Country/Region Key
  • Country/Region Key
  • Client
  • VIAR01.SCOUNTRY == T005.LAND1
  • VIAR01.MANDT == T005.MANDT
Highest Floor
  • VIAR01.MANDT == TIV37.MANDT
  • VIAR01.SFLOORMAX == TIV37.SSTOCKW
Floor of Rental Object
  • VIAR01.MANDT == TIV37.MANDT
  • VIAR01.SFLOORNUM == TIV37.SSTOCKW
District Location of a Real Estate Object (Offer Object)
Type of Rental Object
Type of Parking Space
Type of Parking Space
Identification of Offering/Searching Party (User ID)
  • VIAR01.MANDT == VIAR03.MANDT
  • VIAR01.SPARTID == VIAR03.SPARTID
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • VIAR01.MANDT == T005S.MANDT
  • VIAR01.SCOUNTRY == T005S.LAND1
  • VIAR01.SREGIO == T005S.BLAND
Transport connections