SAP ABAP Table RFVISUPPLY (RE: REsearch - Screen Structure For Offer Overview)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ RE-RT-AO (Application Component) Management of Interested Parties
     ⤷ REAO (Package) RE: Offers and Applications

Basic Data

Table Category	INTTAB	Structure
Structure	RFVISUPPLY	Table Relationship Diagram
Short Description	RE: REsearch - Screen Structure For Offer Overview

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	.INCLUDE	☐				0	0	RE: REse@rch - Maintenance Structure for Table VIAR01
2	.INCLUDE	☐				0	0	RE: REse@rch - Offered RE Objects
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	SIDGSUPPLY	☐	RESADSGSUPPLY	RESADSGSUPPLY	CHAR	20	0	Rental Unit Identification (Global ID)	*
5	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
6	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
7	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
8	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
9	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
10	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
11	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
12	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
13	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
14	JDELETE	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
15	SPARTID	☐	RESADSPARTID	RESADSPARTID	CHAR	10	0	Identification of Offering/Searching Party (User ID)	VIAR03
16	SIDLSUPPLY	☐	RESADSLSUPPLY	RESADSLIDENT	CHAR	35	0	Rental Object (Local ID)
17	SOBJTYPE	☐	RESADSOBJTYPE	RESADSOBJTYPE	NUMC	2	0	Type of Rental Object	TIVAR01
18	JINTERNET	☐	RESADJINTERNET	XFELD	CHAR	1	0	Indicator Internet Release
19	XEYECATCH	☐	RESADXEYECATCH	RESADXEYECATCH	CHAR	85	0	Short Description of Real Estate Object on Offer
20	DFREEFROM	☐	RESADDFREEFROM	DATS	DATS	8	0	Object Available From-Date
21	DFREETILL	☐	RESADDFREETILL	DATS	DATS	8	0	Object Available To-Date
22	CURRKEY	☐	RESADCURRKEY	WAERS	CUKY	5	0	Currency	TCURC
23	AREAKEY	☐	RESADAREAKEY	MEINS	UNIT	3	0	Area unit	T006
24	SAQUISIT	☐	RESADSAQUISIT	RESADSAQUISIT	CHAR	1	0	Acquisition Form (Rent or Purchase)
25	PRENTEXCL	☐	RESADPRENTEXCL	RESADPRENTALL	CURR	13	2	Total Net Monthly Rent
26	PRENTINCL	☐	RESADPRENTINCL	RESADPRENTALL	CURR	13	2	Total Gross Monthly Rent
27	PRENTAREAEXCL	☐	RESADPRENTAREAEXCL	RESADPRENTAREA	CURR	13	2	Net Rent per Area Unit and Year
28	PRENTAREAINCL	☐	RESADPRENTAREAINCL	RESADPRENTAREA	CURR	13	2	Gross Rent per Area Unit and Year
29	PSIZEALL	☐	RESADPSIZEALL	VVBFLART	QUAN	14	4	Total area
30	PSIZEUSE	☐	RESADPSIZEUSE	VVBFLART	QUAN	14	4	Residential/Usable Space
31	NROOMFULL	☐	RESADNROOMFULL	RESADNROOMFULL	NUMC	2	0	Number of Full Rooms
32	NROOMHALF	☐	RESADNROOMHALF	RESADNROOMHALF	NUMC	1	0	Number of Half Rooms
33	SFLOORNUM	☐	RESADSFLOORNUM	VVSSTOCKW	NUMC	3	0	Floor of Rental Object	TIV37
34	SFLOORMAX	☐	RESADSFLOORMAX	VVSSTOCKW	NUMC	3	0	Highest Floor	TIV37
35	SFLOORCOD	☐	RESADSFLOORCOD	RESADSFLOORCOD	NUMC	1	0	Floor Selection
36	SLOCALPOS	☐	RESADSLOCALPOS	RESADSLOCALPOS	NUMC	1	0	District Location of a Real Estate Object (Offer Object)	TIVAR05
37	STRAFFROU	☐	RESADSTRAFFROU		NUMC	1	0	Transport connections	TIVAR06
38	DBUILDDAT	☐	RESADDBUILDDAT	DATS	DATS	8	0	Building date
39	DRSTORDAT	☐	RESADRSTORDAT	DATS	DATS	8	0	Modernization Date
40	CFAFCODE	☐	RESADCFAFCODE	RESADCFAFCODE	CHAR	20	0	Fixtures and Fittings Characteristic String
41	SPARKBAY	☐	RESADSPARKBAY	RESADSPARKBAY	NUMC	2	0	Type of Parking Space	TIVAR04
42	SPARKBAY2	☐	RESADSPARKBAY	RESADSPARKBAY	NUMC	2	0	Type of Parking Space	TIVAR04
43	OCCUPOBLIGO	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
44	JWBSPREFERRED	☐	RESADJWBSPREFERRED	BOOLE	CHAR	1	0	Accommodation Entitlement Certificate Is Advantageous
45	.INCLUDE	☐				0	0	RE: REse@rch - Location Description
46	SCOUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
47	SREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
48	SCOUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
49	SCITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
50	ZIPCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
51	LOCATION	☐	ORT01_GP	TEXT35	CHAR	35	0	City
52	SUBLOCAT	☐	ORT02_GP	TEXT35	CHAR	35	0	District
53	STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
54	.INCLUDE	☐				0	0	RE: REse@rch - IDs of the Screen Objects of an RE Offer
55	IMGDOCID01	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
56	IMGDOCID02	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
57	IMGDOCID03	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
58	TXTDOCID	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
59	CHNGIND	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
60	JMARKED	☐	RESADJMARKED	XFELD	CHAR	1	0	REsearch: Line is selected
61	PCORREL	☐	RESADPCORREL	RESADPCORREL	DEC	5	2	REsearch: Penalty Amount For Offer And Request
62	JFAVORIT	☐	RESADJFAVORIT	XFELD	CHAR	1	0	Entry Is In Favorite List
63	JIMAGES	☐	RESADJIMAGES	XFELD	CHAR	1	0	Real Estate Offer Presentation Includes Graphics
64	YOBJBUILD	☐	RESADYOBJBUILD	GJAHR	NUMC	4	0	Construction Year of Real Estate Object
65	YOBJRSTOR	☐	RESADYOBJRSTOR	GJAHR	NUMC	4	0	Modernization Year of Real Estate Object
66	XOBJTYPE	☐	RESADXOBJTYPE	RESADXOBJTYPE	CHAR	30	0	Object Category Description
67	XADDRESS	☐	RESADXADDRESS	RESADXADDRESS	CHAR	50	0	Address of Real Estate Object
68	XFLOORNUM	☐	XGKBEZ	XKBEZ	CHAR	15	0	Short Description for Floor
69	XFLOORMAX	☐	XGKBEZ	XKBEZ	CHAR	15	0	Short Description for Floor
70	XLOCALPOS	☐	RESADXLOCALPOS	XTEXT30	CHAR	30	0	District Location Text
71	XTRAFFROU	☐	RESADXTRAFFROU	XTEXT30	CHAR	30	0	Text for Transport Connections
72	XPARKBAY	☐	RESADXPARKBAY	RESADXPARKBAY	CHAR	30	0	Text for Parking Space
73	XPARKBAY2	☐	RESADXPARKBAY	RESADXPARKBAY	CHAR	30	0	Text for Parking Space
74	XBELBIND	☐	XKBELBEZ	XKBEZ	CHAR	15	0	Occupancy obligation short text
75	XROOMDATA	☐	RESADXROOMDATA		CHAR	10	0	Room Details Listed as "<Whole Rooms>/"<Half Rooms>"
76	XFAVICON	☐	RESADXFAVICON	ICON	CHAR	4	0	Entry Available in Favorites (Icon)	*
77	XDELETE	☐	RESADXSYMBOL	CHAR20	CHAR	20	0	REsearch: Icon/Symbol Name
78	XCHANGE	☐	RESADXSYMBOL	CHAR20	CHAR	20	0	REsearch: Icon/Symbol Name
79	XSEARCH	☐	RESADXSYMBOL	CHAR20	CHAR	20	0	REsearch: Icon/Symbol Name
80	XCHGIND	☐	RESADXSYMBOL	CHAR20	CHAR	20	0	REsearch: Icon/Symbol Name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RFVISUPPLY	AREAKEY	T006	MSEHI	KEY	1	CN
2	RFVISUPPLY	CURRKEY	TCURC	WAERS	KEY	1	CN
3	RFVISUPPLY	MANDT	T000	MANDT	KEY	1	CN
4	RFVISUPPLY	OCCUPOBLIGO	TIV31	RBELBIND	KEY	1	CN
5	RFVISUPPLY	SCITYC	T005G	CITYC	KEY	1	CN
6	RFVISUPPLY	SCOUNC	T005E	COUNC	KEY	1	CN
7	RFVISUPPLY	SCOUNTRY	T005	LAND1	KEY	1	CN
8	RFVISUPPLY	SFLOORMAX	TIV37	SSTOCKW	KEY	1	CN
9	RFVISUPPLY	SFLOORNUM	TIV37	SSTOCKW	KEY	1	CN
10	RFVISUPPLY	SLOCALPOS	TIVAR05	SLOCALPOS	KEY	1	CN
11	RFVISUPPLY	SOBJTYPE	TIVAR01	SOBJTYPE	KEY	1	CN
12	RFVISUPPLY	SPARKBAY	TIVAR04	SPARKBAY	KEY	1	CN
13	RFVISUPPLY	SPARKBAY2	TIVAR04	SPARKBAY	KEY	1	CN
14	RFVISUPPLY	SPARTID	VIAR03	SPARTID	KEY	1	CN
15	RFVISUPPLY	SREGIO	T005S	BLAND	KEY	1	CN
16	RFVISUPPLY	STRAFFROU	TIVAR06	STRAFFROU	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C