VIOROBJSTATUSX

Status of Search (Enhanced) | #masterdata | Component: Offer and Rental Request
Column Name Description
MANDT Client
OBJNR Object Number
OBJNROO Object Number
OBJSTATUS FK Search Status
VALIDFROM Date: Search Status Valid From
OBJNRREF Object Number
OBJNROFCN Object Number
Column Name Description
πŸ’² Currency of Condition Item (CDCURR01_O):
CDVALUE01_O Condition Amount
πŸ’² Currency of Condition Item (CDCURR02_O):
CDVALUE02_O Condition Amount
πŸ’² Currency of Condition Item (CDCURR03_O):
CDVALUE03_O Condition Amount
πŸ’² Currency of Condition Item (CDCURR04_O):
CDVALUE04_O Condition Amount
Column Name Description
πŸ“ Measurement Unit (MSUNIT01_O):
MSVALUE01_O Measurement Amount
πŸ“ Measurement Unit (MSUNIT02_O):
MSVALUE02_O Measurement Amount
πŸ“ Measurement Unit (MSUNIT03_O):
MSVALUE03_O Measurement Amount
πŸ“ Measurement Unit (MSUNIT04_O):
MSVALUE04_O Measurement Amount
Column Name Description
VALIDFROM Date: Search Status Valid From
VALIDTO Datum: Search Status Valid To
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DERF_O First Entered On
TERF_O Time of Creation
DBEAR_O Last Edited On
TBEAR_O Last Edited At
OOBEG_O Available From
OOEND_O Available To
OODATAFROM_O Offer Data Valid From
OODATATO_O Offer Data Valid To
OORESFROM_O Offer Reserved From
OORESTO_O Offered Object Reserved To
BUILDYEAR_O ConstYr
LOCKEDFROM_O Start of Lock Period
LOCKEDTO_O End of Lock Period
BILLEDTO_O Date Up to Which Postings Were Made
NTPER_O Contract Notice Per
NTREQUESTON_O Tenant's notice request date
BILLFROM_O First Posting From
Column Name Description
CREATIONTYPE_O How the Object Was Created Show values
FLOOR_O Floor Show values
AECNEEDED_O Accommodation Entitlement Certificate Required Show values
Column Name Description Domain name
XCOMMENT Comment REORXCOMMENT
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
OOID_O Offered Object Number REOROOID
OBJNR_O Object Number J_OBJNR
RERF_O Entered By SYCHAR12
REHER_O Source of Initial Entry CHAR10
RBEAR_O Employee ID SYCHAR12
RBHER_O Editing Source CHAR10
AUTHGRP_O Authorization Group RECAAUTHGRP
ACQUISTYPE_O Lease/Buy REORACQUISTYPE
XOO_O Text for Offered Object REORXLDESCRIPTION
OOIDEXT_O External ID of Reservation Object REOROOIDEXT
OBJTYPEREF_O Object Type J_OBART
OBJNRREF_O Object Number J_OBJNR
BUKRS_O Company Code BUKRS
BENO_O Business Entity Number REBDBENO
BUNO_O Number of Building REBDBUNO
PRNO_O Number of Land REBDPRNO
RONO_O Number of Rental Object REBDRONO
OFID_O Contract Offer Number REOROFID
RRCHARACTSTR_O Fixtures and Fittings Characteristic String REORCHARACTSTR
POST_CODE1_O City postal code CHAR10
CITY1_O City TEXT40
CITY2_O District TEXT40
STREET_O Street TEXT60
HOUSE_NUM1_O House Number TEXT10
NEIGHBORH1_O Neighborhood REBDNEIGHBORHOOD
NEIGHBORH2_O Neighborhood REBDNEIGHBORHOOD
NEIGHBORH3_O Neighborhood REBDNEIGHBORHOOD
AECCLASSSTR_O AEC Level String REORAECCLASSSTR
OBJNRCN_O Outline Agreement J_OBJNR
RESPOBJNRDEF_O Responsible Account Assignment Object (Default) J_OBJNR
RESPOBJNR1_O Responsible Account Assignment Object J_OBJNR
RESPOBJNR2_O Responsible Account Assignment Object J_OBJNR
RESPOBJNR3_O Responsible Account Assignment Object J_OBJNR
RESPOBJNR4_O Responsible Account Assignment Object J_OBJNR
XLOCKREASONEXT_O Other Lock Reason RECAXCOMMENT
RSBUKRS_O Company Code (Reservation - Post with Invoice) BUKRS
RESPOBJNRINV_O 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
  • VIOROBJSTATUSX.COUNTRY_O == T005.LAND1
  • VIOROBJSTATUSX.MANDT == T005.MANDT
Lock Reason
Measurement Type
  • Measurement Type
  • Client
Search Status VIOROBJSTATUSX.OBJSTATUS == TIVOROBJSTATUS.OBJSTATUS
Price Code
Price Code
Price Code
Price Code
Reason for Status
  • Search Status
  • Reason for Status
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • VIOROBJSTATUSX.MANDT == T005S.MANDT
  • VIOROBJSTATUSX.COUNTRY_O == T005S.LAND1
  • VIOROBJSTATUSX.REGION_O == T005S.BLAND
Person Responsible
  • VIOROBJSTATUSX.MANDT == USR02.MANDT
  • VIOROBJSTATUSX.RESPONSIBLE_O == USR02.BNAME
Reservation Area
Reservation Object Type
  • Reservation Object Type
  • Client
Indicator: District Location of Object
  • VIOROBJSTATUSX.MANDT == TIV45.MANDT
  • VIOROBJSTATUSX.SOBJLAGE_O == TIV45.SOBJLAGE
Transport Connections of Business Entity
  • Transport Connections of Business Entity
  • Client
  • VIOROBJSTATUSX.TRANSPCONN_O == TIV44.SVERKEHR
  • VIOROBJSTATUSX.MANDT == TIV44.MANDT
Usage Type of Rental Object
  • Usage Type of Rental Object
  • Client
  • VIOROBJSTATUSX.USAGETYPE_O == TIV01.SNUNR
  • VIOROBJSTATUSX.MANDT == TIV01.MANDT
User with Exclusive Change Authorization
  • VIOROBJSTATUSX.MANDT == USR02.MANDT
  • VIOROBJSTATUSX.USEREXCLUSIVE_O == USR02.BNAME
Other Relations | to Master Data Relations ↑ Join Conditions
Business entity location number
  • VIOROBJSTATUSX.MANDT == TIV10.MANDT
  • VIOROBJSTATUSX.SLAGEWE_O == TIV10.SLAGEWE
Regional location
  • VIOROBJSTATUSX.MANDT == TIV35.MANDT
  • VIOROBJSTATUSX.SSTDORT_O == TIV35.SSTDORT