SAP ABAP Table VIOROO (Offered Object)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-OR (Application Component) Offer and Rental Request
     ⤷ RE_OR_OO (Package) RE: Offered Object

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VIOROO	Table Relationship Diagram
Short Description	Offered Object

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	INTRENO	☑	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
3	.INCLUDE	☐				0	0	Offered Object: Key Fields
4	OOID	☐	REOROOID	REOROOID	CHAR	20	0	Offered Object Number
5	.INCLUDE	☐				0	0	Offered Object: Non-Key Fields
6	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
7	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
8	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
9	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
10	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
11	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
12	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
13	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
14	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
15	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
16	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
17	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
18	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
19	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
20	OOBEG	☐	REOROOBEG	RECADATEBEG	DATS	8	0	Available From
21	OOEND	☐	REOROOEND	RECADATEEND	DATS	8	0	Available To
22	MEAS	☐	REBDMEAS	REBDMEAS	CHAR	4	0	Measurement Type	TIVBDMEAS
23	USAGETYPE	☐	REBDUSAGETYPE	SNUNR	NUMC	4	0	Usage Type of Rental Object	TIV01
24	RSOBJTYPE	☐	REORRSOBJTYPE	REORRSOBJTYPE	CHAR	2	0	Reservation Object Type	TIVORRSOBJTYPE
25	RSAREA	☐	REORRSAREA	REORRSAREA	CHAR	10	0	Reservation Area	TIVORRSAREA
26	ACQUISTYPE	☐	REORACQUISTYPE	REORACQUISTYPE	CHAR	2	0	Lease/Buy
27	XOO	☐	REORXOO	REORXLDESCRIPTION	CHAR	255	0	Text for Offered Object
28	OOIDEXT	☐	REOROOIDEXT	REOROOIDEXT	CHAR	45	0	External ID of Reservation Object
29	OBJTYPEREF	☐	RECAOBJTYPE	J_OBART	CHAR	2	0	Object Type	*
30	OBJNRREF	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
31	OODATAFROM	☐	REOROODATAFROM	RECADATEEND	DATS	8	0	Offer Data Valid From
32	OODATATO	☐	REOROODATATO	RECADATEEND	DATS	8	0	Offer Data Valid To
33	OORESFROM	☐	REOROORESFROM	RECADATEBEG	DATS	8	0	Offer Reserved From
34	OORESTO	☐	REOROORESTO	RECADATEEND	DATS	8	0	Offered Object Reserved To
35	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
36	BENO	☐	REBDBENO	REBDBENO	CHAR	8	0	Business Entity Number	*
37	BUNO	☐	REBDBUNO	REBDBUNO	CHAR	8	0	Number of Building
38	PRNO	☐	REBDPRNO	REBDPRNO	CHAR	8	0	Number of Land
39	RONO	☐	REBDRONO	REBDRONO	CHAR	8	0	Number of Rental Object
40	OFID	☐	REOROFID	REOROFID	CHAR	13	0	Contract Offer Number
41	.INCLU-01	☐				0	0	Amount for Condition Group
42	CDVALUE01	☐	REORCDVALUE	RECACURR	CURR	15	2	Condition Amount
43	CDCURR01	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
44	.INCLU-02	☐				0	0	Amount for Condition Group
45	CDVALUE02	☐	REORCDVALUE	RECACURR	CURR	15	2	Condition Amount
46	CDCURR02	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
47	.INCLU-03	☐				0	0	Amount for Condition Group
48	CDVALUE03	☐	REORCDVALUE	RECACURR	CURR	15	2	Condition Amount
49	CDCURR03	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
50	.INCLU-04	☐				0	0	Amount for Condition Group
51	CDVALUE04	☐	REORCDVALUE	RECACURR	CURR	15	2	Condition Amount
52	CDCURR04	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
53	.INCLU-01	☐				0	0	Measurement Amount
54	MSVALUE01	☐	REORMSVALUE	REBDMEASVALUE	QUAN	17	4	Measurement Amount
55	MSUNIT01	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
56	.INCLU-02	☐				0	0	Measurement Amount
57	MSVALUE02	☐	REORMSVALUE	REBDMEASVALUE	QUAN	17	4	Measurement Amount
58	MSUNIT02	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
59	.INCLU-03	☐				0	0	Measurement Amount
60	MSVALUE03	☐	REORMSVALUE	REBDMEASVALUE	QUAN	17	4	Measurement Amount
61	MSUNIT03	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
62	.INCLU-04	☐				0	0	Measurement Amount
63	MSVALUE04	☐	REORMSVALUE	REBDMEASVALUE	QUAN	17	4	Measurement Amount
64	MSUNIT04	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
65	FLOOR	☐	REORRRFLOOR	REORRRFLOOR	CHAR	2	0	Floor
66	SSTDORT	☐	VVSSTDORT	VVSSTDORT	CHAR	10	0	Regional location	TIV35
67	SLAGEWE	☐	SLAGEWE	SLAGEWE	NUMC	4	0	Business entity location number	TIV10
68	SOBJLAGE	☐	RESOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator: District Location of Object	TIV45
69	TRANSPCONN	☐	SVERKEHR	SVERKEHR	CHAR	1	0	Transport Connections of Business Entity	TIV44
70	BUILDYEAR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
71	RRCHARACTSTR	☐	REORRRCHARACTSTR	REORCHARACTSTR	CHAR	80	0	Fixtures and Fittings Characteristic String
72	.INCLUDE	☐				0	0	Address for Real Estate Search
73	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
74	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
75	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
76	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
77	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
78	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
79	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
80	NEIGHBORH1	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood
81	NEIGHBORH2	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood
82	NEIGHBORH3	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood
83	AECNEEDED	☐	REORAECNEEDED	RECABOOL	CHAR	1	0	Accommodation Entitlement Certificate Required
84	AECCLASSSTR	☐	REORAECCLASSSTR	REORAECCLASSSTR	CHAR	60	0	AEC Level String
85	OBJNRCN	☐	REOROBJNRCN	J_OBJNR	CHAR	22	0	Outline Agreement	*
86	ACCDETKEY	☐	RERAACCDETKEY	RERAACCDETKEY	CHAR	10	0	Account Determination Value	TIVRADETKEY
87	RESPOBJNRDEF	☐	REORRESPOBJNRDEF	J_OBJNR	CHAR	22	0	Responsible Account Assignment Object (Default)	*
88	RESPOBJNR1	☐	REORRESPOBJNR	J_OBJNR	CHAR	22	0	Responsible Account Assignment Object	*
89	RESPOBJNR2	☐	REORRESPOBJNR	J_OBJNR	CHAR	22	0	Responsible Account Assignment Object	*
90	RESPOBJNR3	☐	REORRESPOBJNR	J_OBJNR	CHAR	22	0	Responsible Account Assignment Object	*
91	RESPOBJNR4	☐	REORRESPOBJNR	J_OBJNR	CHAR	22	0	Responsible Account Assignment Object	*
92	PRICECODE1	☐	REORPRICECODE	REORPRICECODE	CHAR	10	0	Price Code	TIVORPRICECODE
93	PRICECODE2	☐	REORPRICECODE	REORPRICECODE	CHAR	10	0	Price Code	TIVORPRICECODE
94	PRICECODE3	☐	REORPRICECODE	REORPRICECODE	CHAR	10	0	Price Code	TIVORPRICECODE
95	PRICECODE4	☐	REORPRICECODE	REORPRICECODE	CHAR	10	0	Price Code	TIVORPRICECODE
96	LOCKEDFROM	☐	REORLOCKEDFROM	RECADATEBEG	DATS	8	0	Start of Lock Period
97	LOCKEDTO	☐	REORLOCKEDTO	RECADATE	DATS	8	0	End of Lock Period
98	LOCKREASON	☐	REORLOCKREASON	REORLOCKREASON	CHAR	4	0	Lock Reason	TIVORLOCKRS
99	XLOCKREASONEXT	☐	REORXLOCKREASONEXT	RECAXCOMMENT	CHAR	100	0	Other Lock Reason
100	BILLEDTO	☐	REORBILLEDTO	RECADATE	DATS	8	0	Date Up to Which Postings Were Made
101	NTPER	☐	RECNNTPER	RECADATE	DATS	8	0	Contract Notice Per
102	NTREQUESTON	☐	RECNNTREQUESTON	RECADATE	DATS	8	0	Tenant's notice request date
103	BILLFROM	☐	REORBILLFROM	RECADATE	DATS	8	0	First Posting From
104	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIOROO	ACCDETKEY	TIVRADETKEY	ACCDETKEY
2	VIOROO	COUNTRY	T005	LAND1
3	VIOROO	LOCKREASON	TIVORLOCKRS	LOCKREASON	REF	C	CN
4	VIOROO	MEAS	TIVBDMEAS	MEAS
5	VIOROO	PRICECODE1	TIVORPRICECODE	PRICECODE
6	VIOROO	PRICECODE2	TIVORPRICECODE	PRICECODE
7	VIOROO	PRICECODE3	TIVORPRICECODE	PRICECODE
8	VIOROO	PRICECODE4	TIVORPRICECODE	PRICECODE
9	VIOROO	REGION	T005S	BLAND
10	VIOROO	RESPONSIBLE	USR02	BNAME	REF	1	CN
11	VIOROO	RSAREA	TIVORRSAREA	RSAREA	REF	C	CN
12	VIOROO	RSOBJTYPE	TIVORRSOBJTYPE	RSOBJTYPE	REF	C	CN
13	VIOROO	SLAGEWE	TIV10	SLAGEWE
14	VIOROO	SOBJLAGE	TIV45	SOBJLAGE
15	VIOROO	SSTDORT	TIV35	SSTDORT
16	VIOROO	TRANSPCONN	TIV44	SVERKEHR
17	VIOROO	USAGETYPE	TIV01	SNUNR
18	VIOROO	USEREXCLUSIVE	USR02	BNAME	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	600