SAP VIOROBJSTATUSX Status of Search (Enhanced) Table

Overview

VIOROBJSTATUSX is a standard SAP S/4HANA table that stores Status of Search (Enhanced) data. There are total 109 fields in the VIOROBJSTATUSX table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VIOROBJSTATUSX belongs to Offer and Rental Request (RE-FX-OR) module and is located in the package RE: Offered Object (RE_OR_OO).

In addition, following links provide an overview of foreign key relationships, if any, that link VIOROBJSTATUSX to other SAP tables and standard CDS views available based on VIOROBJSTATUSX table in S/4HANA 2020.

Techincal Settings of VIOROBJSTATUSX

Below are technical details of the table VIOROBJSTATUSX

Buffering not allowed
No buffering
Storage type is Column Store

List of VIOROBJSTATUSX Fields

The following table gives you an overview of the fields available in VIOROBJSTATUSX

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT		CLNT	3
OBJNR	Object Number	RECAOBJNR		CHAR	22
OBJNROO	Object Number	RECAOBJNR		CHAR	22
OBJSTATUS	Search Status	REOROBJSTATUS	TIVOROBJSTATUS	CHAR	4
VALIDFROM	Date: Search Status Valid From	REOROBJSTATUSVALIDFROM		DATS	8
OBJNRREF	Object Number	RECAOBJNR		CHAR	22
OBJNROFCN	Object Number	RECAOBJNR		CHAR	22
REASON	Reason for Status	REORSTATREAS	TIVOROBJSTATRS	CHAR	2
XCOMMENT	Comment	REORXCOMMENT		CHAR	255
VALIDTO	Datum: Search Status Valid To	REOROBJSTATUSVALIDTO		DATS	8
RERF	Entered By	RERF		CHAR	12
DERF	First Entered On	DERF		DATS	8
TERF	Time of Creation	TERF		TIMS	6
REHER	Source of Initial Entry	REHER		CHAR	10
RBEAR	Employee ID	RBEAR		CHAR	12
DBEAR	Last Edited On	DBEAR		DATS	8
TBEAR	Last Edited At	TBEAR		TIMS	6
RBHER	Editing Source	RBHER		CHAR	10
OOID_O	Offered Object Number	REOROOID		CHAR	20
OBJNR_O	Object Number	RECAOBJNR	*	CHAR	22
CREATIONTYPE_O	How the Object Was Created	RECACREATIONTYPE		CHAR	1
RERF_O	Entered By	RERF		CHAR	12
DERF_O	First Entered On	DERF		DATS	8
TERF_O	Time of Creation	TERF		TIMS	6
REHER_O	Source of Initial Entry	REHER		CHAR	10
RBEAR_O	Employee ID	RBEAR		CHAR	12
DBEAR_O	Last Edited On	DBEAR		DATS	8
TBEAR_O	Last Edited At	TBEAR		TIMS	6
RBHER_O	Editing Source	RBHER		CHAR	10
RESPONSIBLE_O	Person Responsible	RECARESPONSIBLE	USR02	CHAR	12
USEREXCLUSIVE_O	User with Exclusive Change Authorization	RECAUSEREXCLUSIVE	USR02	CHAR	12
AUTHGRP_O	Authorization Group	RECAAUTHGRP		CHAR	40
OOBEG_O	Available From	REOROOBEG		DATS	8
OOEND_O	Available To	REOROOEND		DATS	8
MEAS_O	Measurement Type	REBDMEAS	TIVBDMEAS	CHAR	4
USAGETYPE_O	Usage Type of Rental Object	REBDUSAGETYPE	TIV01	NUMC	4
RSOBJTYPE_O	Reservation Object Type	REORRSOBJTYPE	TIVORRSOBJTYPE	CHAR	2
RSAREA_O	Reservation Area	REORRSAREA	TIVORRSAREA	CHAR	10
ACQUISTYPE_O	Lease/Buy	REORACQUISTYPE		CHAR	2
XOO_O	Text for Offered Object	REORXOO		CHAR	255
OOIDEXT_O	External ID of Reservation Object	REOROOIDEXT		CHAR	45
OBJTYPEREF_O	Object Type	RECAOBJTYPE		CHAR	2
OBJNRREF_O	Object Number	RECAOBJNR	*	CHAR	22
OODATAFROM_O	Offer Data Valid From	REOROODATAFROM		DATS	8
OODATATO_O	Offer Data Valid To	REOROODATATO		DATS	8
OORESFROM_O	Offer Reserved From	REOROORESFROM		DATS	8
OORESTO_O	Offered Object Reserved To	REOROORESTO		DATS	8
BUKRS_O	Company Code	BUKRS		CHAR	4
BENO_O	Business Entity Number	REBDBENO		CHAR	8
BUNO_O	Number of Building	REBDBUNO		CHAR	8
PRNO_O	Number of Land	REBDPRNO		CHAR	8
RONO_O	Number of Rental Object	REBDRONO		CHAR	8
OFID_O	Contract Offer Number	REOROFID		CHAR	13
CDVALUE01_O	Condition Amount	REORCDVALUE		CURR	15
CDCURR01_O	Currency of condition item	RECDCONDCURR	*	CUKY	5
CDVALUE02_O	Condition Amount	REORCDVALUE		CURR	15
CDCURR02_O	Currency of condition item	RECDCONDCURR	*	CUKY	5
CDVALUE03_O	Condition Amount	REORCDVALUE		CURR	15
CDCURR03_O	Currency of condition item	RECDCONDCURR	*	CUKY	5
CDVALUE04_O	Condition Amount	REORCDVALUE		CURR	15
CDCURR04_O	Currency of condition item	RECDCONDCURR	*	CUKY	5
MSVALUE01_O	Measurement Amount	REORMSVALUE		QUAN	17
MSUNIT01_O	Measurement Unit	REBDMEASUNIT	*	UNIT	3
MSVALUE02_O	Measurement Amount	REORMSVALUE		QUAN	17
MSUNIT02_O	Measurement Unit	REBDMEASUNIT	*	UNIT	3
MSVALUE03_O	Measurement Amount	REORMSVALUE		QUAN	17
MSUNIT03_O	Measurement Unit	REBDMEASUNIT	*	UNIT	3
MSVALUE04_O	Measurement Amount	REORMSVALUE		QUAN	17
MSUNIT04_O	Measurement Unit	REBDMEASUNIT	*	UNIT	3
FLOOR_O	Floor	REORRRFLOOR		CHAR	2
SSTDORT_O	Regional location	VVSSTDORT	TIV35	CHAR	10
SLAGEWE_O	Business entity location number	SLAGEWE	TIV10	NUMC	4
SOBJLAGE_O	Indicator: District Location of Object	RESOBJLAGE	TIV45	NUMC	2
TRANSPCONN_O	Transport Connections of Business Entity	SVERKEHR	TIV44	CHAR	1
BUILDYEAR_O	ConstYr	VVYBAUJAHR		DATS	8
RRCHARACTSTR_O	Fixtures and Fittings Characteristic String	REORRRCHARACTSTR		CHAR	80
COUNTRY_O	Country/Region Key	LAND1	T005	CHAR	3
REGION_O	Region (State Province County)	REGIO	T005S	CHAR	3
POST_CODE1_O	City postal code	AD_PSTCD1		CHAR	10
CITY1_O	City	AD_CITY1		CHAR	40
CITY2_O	District	AD_CITY2		CHAR	40
STREET_O	Street	AD_STREET		CHAR	60
HOUSE_NUM1_O	House Number	AD_HSNM1		CHAR	10
NEIGHBORH1_O	Neighborhood	REBDNEIGHBORHOOD		CHAR	30
NEIGHBORH2_O	Neighborhood	REBDNEIGHBORHOOD		CHAR	30
NEIGHBORH3_O	Neighborhood	REBDNEIGHBORHOOD		CHAR	30
AECNEEDED_O	Accommodation Entitlement Certificate Required	REORAECNEEDED		CHAR	1
AECCLASSSTR_O	AEC Level String	REORAECCLASSSTR		CHAR	60
OBJNRCN_O	Outline Agreement	REOROBJNRCN	*	CHAR	22
ACCDETKEY_O	Account Determination Value	RERAACCDETKEY	TIVRADETKEY	CHAR	10
RESPOBJNRDEF_O	Responsible Account Assignment Object (Default)	REORRESPOBJNRDEF	*	CHAR	22
RESPOBJNR1_O	Responsible Account Assignment Object	REORRESPOBJNR	*	CHAR	22
RESPOBJNR2_O	Responsible Account Assignment Object	REORRESPOBJNR	*	CHAR	22
RESPOBJNR3_O	Responsible Account Assignment Object	REORRESPOBJNR	*	CHAR	22
RESPOBJNR4_O	Responsible Account Assignment Object	REORRESPOBJNR	*	CHAR	22
PRICECODE1_O	Price Code	REORPRICECODE	TIVORPRICECODE	CHAR	10
PRICECODE2_O	Price Code	REORPRICECODE	TIVORPRICECODE	CHAR	10
PRICECODE3_O	Price Code	REORPRICECODE	TIVORPRICECODE	CHAR	10
PRICECODE4_O	Price Code	REORPRICECODE	TIVORPRICECODE	CHAR	10
LOCKEDFROM_O	Start of Lock Period	REORLOCKEDFROM		DATS	8
LOCKEDTO_O	End of Lock Period	REORLOCKEDTO		DATS	8
LOCKREASON_O	Lock Reason	REORLOCKREASON	TIVORLOCKRS	CHAR	4
XLOCKREASONEXT_O	Other Lock Reason	REORXLOCKREASONEXT		CHAR	100
BILLEDTO_O	Date Up to Which Postings Were Made	REORBILLEDTO		DATS	8
NTPER_O	Contract Notice Per	RECNNTPER		DATS	8
NTREQUESTON_O	Tenant's notice request date	RECNNTREQUESTON		DATS	8
BILLFROM_O	First Posting From	REORBILLFROM		DATS	8
RSBUKRS_O	Company Code (Reservation - Post with Invoice)	REORBUKRS		CHAR	4
RESPOBJNRINV_O	Responsible Account Assignment Object (Billing)	REORRESPOBJNRINV	*	CHAR	22

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIOROBJSTATUSX

Table Name	Field	Cardinality	Check Table
VIOROBJSTATUSX	ACCDETKEY_O	:	TIVRADETKEY
VIOROBJSTATUSX	COUNTRY_O	:	T005
VIOROBJSTATUSX	LOCKREASON_O	C: CN	TIVORLOCKRS
VIOROBJSTATUSX	MEAS_O	:	TIVBDMEAS
VIOROBJSTATUSX	OBJSTATUS	1: CN	TIVOROBJSTATUS
VIOROBJSTATUSX	PRICECODE1_O	:	TIVORPRICECODE
VIOROBJSTATUSX	PRICECODE2_O	:	TIVORPRICECODE
VIOROBJSTATUSX	PRICECODE3_O	:	TIVORPRICECODE
VIOROBJSTATUSX	PRICECODE4_O	:	TIVORPRICECODE
VIOROBJSTATUSX	REASON	1: CN	TIVOROBJSTATRS
VIOROBJSTATUSX	REGION_O	:	T005S
VIOROBJSTATUSX	RESPONSIBLE_O	1: CN	USR02
VIOROBJSTATUSX	RSAREA_O	C: CN	TIVORRSAREA
VIOROBJSTATUSX	RSOBJTYPE_O	C: CN	TIVORRSOBJTYPE
VIOROBJSTATUSX	SLAGEWE_O	:	TIV10
VIOROBJSTATUSX	SOBJLAGE_O	:	TIV45
VIOROBJSTATUSX	SSTDORT_O	:	TIV35
VIOROBJSTATUSX	TRANSPCONN_O	:	TIV44
VIOROBJSTATUSX	USAGETYPE_O	:	TIV01
VIOROBJSTATUSX	USEREXCLUSIVE_O	C: CN	USR02

SAP VIOROBJSTATUSX Status of Search (Enhanced) Table

Overview

Techincal Settings of VIOROBJSTATUSX

List of VIOROBJSTATUSX Fields

Foreign Key Relationships

Other References