SAP ABAP Table RFVIAR01 (RE: REse@rch - Maintenance Structure for Table VIAR01)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	INTTAB	Structure
Structure	RFVIAR01	Table Relationship Diagram
Short Description	RE: REse@rch - Maintenance Structure for Table VIAR01

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in