SAP ABAP Table VIAR01 (RE: REse@rch - Offered RE Objects)

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	TRANSP	Transparent table
Transparent table	VIAR01	Table Relationship Diagram
Short Description	RE: REse@rch - Offered RE Objects

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SIDGSUPPLY	☑	RESADSGSUPPLY	RESADSGSUPPLY	CHAR	20	0	Rental Unit Identification (Global ID)
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	JDELETE	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
13	SPARTID	☐	RESADSPARTID	RESADSPARTID	CHAR	10	0	Identification of Offering/Searching Party (User ID)	VIAR03
14	SIDLSUPPLY	☐	RESADSLSUPPLY	RESADSLIDENT	CHAR	35	0	Rental Object (Local ID)
15	SOBJTYPE	☐	RESADSOBJTYPE	RESADSOBJTYPE	NUMC	2	0	Type of Rental Object	TIVAR01
16	JINTERNET	☐	RESADJINTERNET	XFELD	CHAR	1	0	Indicator Internet Release
17	XEYECATCH	☐	RESADXEYECATCH	RESADXEYECATCH	CHAR	85	0	Short Description of Real Estate Object on Offer
18	DFREEFROM	☐	RESADDFREEFROM	DATS	DATS	8	0	Object Available From-Date
19	DFREETILL	☐	RESADDFREETILL	DATS	DATS	8	0	Object Available To-Date
20	CURRKEY	☐	RESADCURRKEY	WAERS	CUKY	5	0	Currency	TCURC
21	AREAKEY	☐	RESADAREAKEY	MEINS	UNIT	3	0	Area unit	T006
22	SAQUISIT	☐	RESADSAQUISIT	RESADSAQUISIT	CHAR	1	0	Acquisition Form (Rent or Purchase)
23	PRENTEXCL	☐	RESADPRENTEXCL	RESADPRENTALL	CURR	13	2	Total Net Monthly Rent
24	PRENTINCL	☐	RESADPRENTINCL	RESADPRENTALL	CURR	13	2	Total Gross Monthly Rent
25	PRENTAREAEXCL	☐	RESADPRENTAREAEXCL	RESADPRENTAREA	CURR	13	2	Net Rent per Area Unit and Year
26	PRENTAREAINCL	☐	RESADPRENTAREAINCL	RESADPRENTAREA	CURR	13	2	Gross Rent per Area Unit and Year
27	PSIZEALL	☐	RESADPSIZEALL	VVBFLART	QUAN	14	4	Total area
28	PSIZEUSE	☐	RESADPSIZEUSE	VVBFLART	QUAN	14	4	Residential/Usable Space
29	NROOMFULL	☐	RESADNROOMFULL	RESADNROOMFULL	NUMC	2	0	Number of Full Rooms
30	NROOMHALF	☐	RESADNROOMHALF	RESADNROOMHALF	NUMC	1	0	Number of Half Rooms
31	SFLOORNUM	☐	RESADSFLOORNUM	VVSSTOCKW	NUMC	3	0	Floor of Rental Object	TIV37
32	SFLOORMAX	☐	RESADSFLOORMAX	VVSSTOCKW	NUMC	3	0	Highest Floor	TIV37
33	SFLOORCOD	☐	RESADSFLOORCOD	RESADSFLOORCOD	NUMC	1	0	Floor Selection
34	SLOCALPOS	☐	RESADSLOCALPOS	RESADSLOCALPOS	NUMC	1	0	District Location of a Real Estate Object (Offer Object)	TIVAR05
35	STRAFFROU	☐	RESADSTRAFFROU		NUMC	1	0	Transport connections	TIVAR06
36	DBUILDDAT	☐	RESADDBUILDDAT	DATS	DATS	8	0	Building date
37	DRSTORDAT	☐	RESADRSTORDAT	DATS	DATS	8	0	Modernization Date
38	CFAFCODE	☐	RESADCFAFCODE	RESADCFAFCODE	CHAR	20	0	Fixtures and Fittings Characteristic String
39	SPARKBAY	☐	RESADSPARKBAY	RESADSPARKBAY	NUMC	2	0	Type of Parking Space	TIVAR04
40	SPARKBAY2	☐	RESADSPARKBAY	RESADSPARKBAY	NUMC	2	0	Type of Parking Space	TIVAR04
41	OCCUPOBLIGO	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
42	JWBSPREFERRED	☐	RESADJWBSPREFERRED	BOOLE	CHAR	1	0	Accommodation Entitlement Certificate Is Advantageous
43	.INCLUDE	☐				0	0	RE: REse@rch - Location Description
44	SCOUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
45	SREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
46	SCOUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
47	SCITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
48	ZIPCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
49	LOCATION	☐	ORT01_GP	TEXT35	CHAR	35	0	City
50	SUBLOCAT	☐	ORT02_GP	TEXT35	CHAR	35	0	District
51	STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
52	.INCLUDE	☐				0	0	RE: REse@rch - IDs of the Screen Objects of an RE Offer
53	IMGDOCID01	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
54	IMGDOCID02	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
55	IMGDOCID03	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
56	TXTDOCID	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in