SAP VIOROO Offered Object Table

Overview

VIOROO is a standard SAP S/4HANA table that stores Offered Object data. There are total 93 fields in the VIOROO table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VIOROO 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 VIOROO to other SAP tables and standard CDS views available based on VIOROO table in S/4HANA 2020.

Techincal Settings of VIOROO

Below are technical details of the table VIOROO

Buffering not allowed
No buffering
Storage type is Column Store

List of VIOROO Fields

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

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT		CLNT	3
INTRENO	Internal Key of Real Estate Object	RECAINTRENO		CHAR	13
OOID	Offered Object Number	REOROOID		CHAR	20
OBJNR	Object Number	RECAOBJNR	*	CHAR	22
CREATIONTYPE	How the Object Was Created	RECACREATIONTYPE		CHAR	1
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
RESPONSIBLE	Person Responsible	RECARESPONSIBLE	USR02	CHAR	12
USEREXCLUSIVE	User with Exclusive Change Authorization	RECAUSEREXCLUSIVE	USR02	CHAR	12
AUTHGRP	Authorization Group	RECAAUTHGRP		CHAR	40
OOBEG	Available From	REOROOBEG		DATS	8
OOEND	Available To	REOROOEND		DATS	8
MEAS	Measurement Type	REBDMEAS	TIVBDMEAS	CHAR	4
USAGETYPE	Usage Type of Rental Object	REBDUSAGETYPE	TIV01	NUMC	4
RSOBJTYPE	Reservation Object Type	REORRSOBJTYPE	TIVORRSOBJTYPE	CHAR	2
RSAREA	Reservation Area	REORRSAREA	TIVORRSAREA	CHAR	10
ACQUISTYPE	Lease/Buy	REORACQUISTYPE		CHAR	2
XOO	Text for Offered Object	REORXOO		CHAR	255
OOIDEXT	External ID of Reservation Object	REOROOIDEXT		CHAR	45
OBJTYPEREF	Object Type	RECAOBJTYPE		CHAR	2
OBJNRREF	Object Number	RECAOBJNR	*	CHAR	22
OODATAFROM	Offer Data Valid From	REOROODATAFROM		DATS	8
OODATATO	Offer Data Valid To	REOROODATATO		DATS	8
OORESFROM	Offer Reserved From	REOROORESFROM		DATS	8
OORESTO	Offered Object Reserved To	REOROORESTO		DATS	8
BUKRS	Company Code	BUKRS		CHAR	4
BENO	Business Entity Number	REBDBENO		CHAR	8
BUNO	Number of Building	REBDBUNO		CHAR	8
PRNO	Number of Land	REBDPRNO		CHAR	8
RONO	Number of Rental Object	REBDRONO		CHAR	8
OFID	Contract Offer Number	REOROFID		CHAR	13
CDVALUE01	Condition Amount	REORCDVALUE		CURR	15
CDCURR01	Currency of condition item	RECDCONDCURR	*	CUKY	5
CDVALUE02	Condition Amount	REORCDVALUE		CURR	15
CDCURR02	Currency of condition item	RECDCONDCURR	*	CUKY	5
CDVALUE03	Condition Amount	REORCDVALUE		CURR	15
CDCURR03	Currency of condition item	RECDCONDCURR	*	CUKY	5
CDVALUE04	Condition Amount	REORCDVALUE		CURR	15
CDCURR04	Currency of condition item	RECDCONDCURR	*	CUKY	5
MSVALUE01	Measurement Amount	REORMSVALUE		QUAN	17
MSUNIT01	Measurement Unit	REBDMEASUNIT	*	UNIT	3
MSVALUE02	Measurement Amount	REORMSVALUE		QUAN	17
MSUNIT02	Measurement Unit	REBDMEASUNIT	*	UNIT	3
MSVALUE03	Measurement Amount	REORMSVALUE		QUAN	17
MSUNIT03	Measurement Unit	REBDMEASUNIT	*	UNIT	3
MSVALUE04	Measurement Amount	REORMSVALUE		QUAN	17
MSUNIT04	Measurement Unit	REBDMEASUNIT	*	UNIT	3
FLOOR	Floor	REORRRFLOOR		CHAR	2
SSTDORT	Regional location	VVSSTDORT	TIV35	CHAR	10
SLAGEWE	Business entity location number	SLAGEWE	TIV10	NUMC	4
SOBJLAGE	Indicator: District Location of Object	RESOBJLAGE	TIV45	NUMC	2
TRANSPCONN	Transport Connections of Business Entity	SVERKEHR	TIV44	CHAR	1
BUILDYEAR	ConstYr	VVYBAUJAHR		DATS	8
RRCHARACTSTR	Fixtures and Fittings Characteristic String	REORRRCHARACTSTR		CHAR	80
COUNTRY	Country/Region Key	LAND1	T005	CHAR	3
REGION	Region (State Province County)	REGIO	T005S	CHAR	3
POST_CODE1	City postal code	AD_PSTCD1		CHAR	10
CITY1	City	AD_CITY1		CHAR	40
CITY2	District	AD_CITY2		CHAR	40
STREET	Street	AD_STREET		CHAR	60
HOUSE_NUM1	House Number	AD_HSNM1		CHAR	10
NEIGHBORH1	Neighborhood	REBDNEIGHBORHOOD		CHAR	30
NEIGHBORH2	Neighborhood	REBDNEIGHBORHOOD		CHAR	30
NEIGHBORH3	Neighborhood	REBDNEIGHBORHOOD		CHAR	30
AECNEEDED	Accommodation Entitlement Certificate Required	REORAECNEEDED		CHAR	1
AECCLASSSTR	AEC Level String	REORAECCLASSSTR		CHAR	60
OBJNRCN	Outline Agreement	REOROBJNRCN	*	CHAR	22
ACCDETKEY	Account Determination Value	RERAACCDETKEY	TIVRADETKEY	CHAR	10
RESPOBJNRDEF	Responsible Account Assignment Object (Default)	REORRESPOBJNRDEF	*	CHAR	22
RESPOBJNR1	Responsible Account Assignment Object	REORRESPOBJNR	*	CHAR	22
RESPOBJNR2	Responsible Account Assignment Object	REORRESPOBJNR	*	CHAR	22
RESPOBJNR3	Responsible Account Assignment Object	REORRESPOBJNR	*	CHAR	22
RESPOBJNR4	Responsible Account Assignment Object	REORRESPOBJNR	*	CHAR	22
PRICECODE1	Price Code	REORPRICECODE	TIVORPRICECODE	CHAR	10
PRICECODE2	Price Code	REORPRICECODE	TIVORPRICECODE	CHAR	10
PRICECODE3	Price Code	REORPRICECODE	TIVORPRICECODE	CHAR	10
PRICECODE4	Price Code	REORPRICECODE	TIVORPRICECODE	CHAR	10
LOCKEDFROM	Start of Lock Period	REORLOCKEDFROM		DATS	8
LOCKEDTO	End of Lock Period	REORLOCKEDTO		DATS	8
LOCKREASON	Lock Reason	REORLOCKREASON	TIVORLOCKRS	CHAR	4
XLOCKREASONEXT	Other Lock Reason	REORXLOCKREASONEXT		CHAR	100
BILLEDTO	Date Up to Which Postings Were Made	REORBILLEDTO		DATS	8
NTPER	Contract Notice Per	RECNNTPER		DATS	8
NTREQUESTON	Tenant's notice request date	RECNNTREQUESTON		DATS	8
BILLFROM	First Posting From	REORBILLFROM		DATS	8
RSBUKRS	Company Code (Reservation - Post with Invoice)	REORBUKRS		CHAR	4
RESPOBJNRINV	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 VIOROO

Table Name	Field	Cardinality	Check Table
VIOROO	ACCDETKEY	:	TIVRADETKEY
VIOROO	COUNTRY	:	T005
VIOROO	LOCKREASON	C: CN	TIVORLOCKRS
VIOROO	MEAS	:	TIVBDMEAS
VIOROO	PRICECODE1	:	TIVORPRICECODE
VIOROO	PRICECODE2	:	TIVORPRICECODE
VIOROO	PRICECODE3	:	TIVORPRICECODE
VIOROO	PRICECODE4	:	TIVORPRICECODE
VIOROO	REGION	:	T005S
VIOROO	RESPONSIBLE	1: CN	USR02
VIOROO	RSAREA	C: CN	TIVORRSAREA
VIOROO	RSOBJTYPE	C: CN	TIVORRSOBJTYPE
VIOROO	SLAGEWE	:	TIV10
VIOROO	SOBJLAGE	:	TIV45
VIOROO	SSTDORT	:	TIV35
VIOROO	TRANSPCONN	:	TIV44
VIOROO	USAGETYPE	:	TIV01
VIOROO	USEREXCLUSIVE	C: CN	USR02

SAP VIOROO Offered Object Table

Overview

Techincal Settings of VIOROO

List of VIOROO Fields

Foreign Key Relationships

Other References