VIOROO

Offered Object | #masterdata | Component: Offer and Rental Request
Column Name Description
MANDT Client
INTRENO Internal Key of Real Estate Object
Column Name Description
πŸ’² Currency of Condition Item (CDCURR01):
CDVALUE01 Condition Amount
πŸ’² Currency of Condition Item (CDCURR02):
CDVALUE02 Condition Amount
πŸ’² Currency of Condition Item (CDCURR03):
CDVALUE03 Condition Amount
πŸ’² Currency of Condition Item (CDCURR04):
CDVALUE04 Condition Amount
Column Name Description
πŸ“ Measurement Unit (MSUNIT01):
MSVALUE01 Measurement Amount
πŸ“ Measurement Unit (MSUNIT02):
MSVALUE02 Measurement Amount
πŸ“ Measurement Unit (MSUNIT03):
MSVALUE03 Measurement Amount
πŸ“ Measurement Unit (MSUNIT04):
MSVALUE04 Measurement Amount
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
OOBEG Available From
OOEND Available To
OODATAFROM Offer Data Valid From
OODATATO Offer Data Valid To
OORESFROM Offer Reserved From
OORESTO Offered Object Reserved To
BUILDYEAR ConstYr
LOCKEDFROM Start of Lock Period
LOCKEDTO End of Lock Period
BILLEDTO Date Up to Which Postings Were Made
NTPER Contract Notice Per
NTREQUESTON Tenant's notice request date
BILLFROM First Posting From
Column Name Description
CREATIONTYPE How the Object Was Created Show values
FLOOR Floor Show values
AECNEEDED Accommodation Entitlement Certificate Required Show values
Column Name Description Domain name
OOID Offered Object Number REOROOID
OBJNR Object Number J_OBJNR
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
AUTHGRP Authorization Group RECAAUTHGRP
ACQUISTYPE Lease/Buy REORACQUISTYPE
XOO Text for Offered Object REORXLDESCRIPTION
OOIDEXT External ID of Reservation Object REOROOIDEXT
OBJTYPEREF Object Type J_OBART
OBJNRREF Object Number J_OBJNR
BUKRS Company Code BUKRS
BENO Business Entity Number REBDBENO
BUNO Number of Building REBDBUNO
PRNO Number of Land REBDPRNO
RONO Number of Rental Object REBDRONO
OFID Contract Offer Number REOROFID
RRCHARACTSTR Fixtures and Fittings Characteristic String REORCHARACTSTR
POST_CODE1 City postal code CHAR10
CITY1 City TEXT40
CITY2 District TEXT40
STREET Street TEXT60
HOUSE_NUM1 House Number TEXT10
NEIGHBORH1 Neighborhood REBDNEIGHBORHOOD
NEIGHBORH2 Neighborhood REBDNEIGHBORHOOD
NEIGHBORH3 Neighborhood REBDNEIGHBORHOOD
AECCLASSSTR AEC Level String REORAECCLASSSTR
OBJNRCN Outline Agreement J_OBJNR
RESPOBJNRDEF Responsible Account Assignment Object (Default) J_OBJNR
RESPOBJNR1 Responsible Account Assignment Object J_OBJNR
RESPOBJNR2 Responsible Account Assignment Object J_OBJNR
RESPOBJNR3 Responsible Account Assignment Object J_OBJNR
RESPOBJNR4 Responsible Account Assignment Object J_OBJNR
XLOCKREASONEXT Other Lock Reason RECAXCOMMENT
RSBUKRS Company Code (Reservation - Post with Invoice) BUKRS
RESPOBJNRINV Responsible Account Assignment Object (Billing) J_OBJNR
Master Data Relations | to Other Relations ↓ Join Conditions
Account Determination Value
Country/Region Key
  • Country/Region Key
  • Client
  • VIOROO.COUNTRY == T005.LAND1
  • VIOROO.MANDT == T005.MANDT
Lock Reason
Measurement Type
  • Measurement Type
  • Client
Price Code
Price Code
Price Code
Price Code
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • VIOROO.MANDT == T005S.MANDT
  • VIOROO.COUNTRY == T005S.LAND1
  • VIOROO.REGION == T005S.BLAND
Person Responsible
  • VIOROO.MANDT == USR02.MANDT
  • VIOROO.RESPONSIBLE == USR02.BNAME
Reservation Area
Reservation Object Type
  • Reservation Object Type
  • Client
Indicator: District Location of Object
  • VIOROO.MANDT == TIV45.MANDT
  • VIOROO.SOBJLAGE == TIV45.SOBJLAGE
Transport Connections of Business Entity
  • Transport Connections of Business Entity
  • Client
  • VIOROO.TRANSPCONN == TIV44.SVERKEHR
  • VIOROO.MANDT == TIV44.MANDT
Usage Type of Rental Object
  • Usage Type of Rental Object
  • Client
  • VIOROO.USAGETYPE == TIV01.SNUNR
  • VIOROO.MANDT == TIV01.MANDT
User with Exclusive Change Authorization
  • VIOROO.MANDT == USR02.MANDT
  • VIOROO.USEREXCLUSIVE == USR02.BNAME
Other Relations | to Master Data Relations ↑ Join Conditions
Business entity location number
  • VIOROO.MANDT == TIV10.MANDT
  • VIOROO.SLAGEWE == TIV10.SLAGEWE
Regional location
  • VIOROO.MANDT == TIV35.MANDT
  • VIOROO.SSTDORT == TIV35.SSTDORT