SAP ABAP Table VIOROO_TAB (Offered Object: Non-Key Fields)

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	INTTAB	Structure
Structure	VIOROO_TAB	Table Relationship Diagram
Short Description	Offered Object: Non-Key Fields

Delivery and Maintenance

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

Foreign Keys

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

History

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