SAP ABAP Table VIAR02 (RE: REse@rch - RE Requests)

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	VIAR02	Table Relationship Diagram
Short Description	RE: REse@rch - RE Requests

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	T000
2	SIDGDEMAND	☑	RESADSGDEMAND	RESADSGDEMAND	CHAR	20	0	Rental Request 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	SIDLDEMAND	☐	RESADSLDEMAND	RESADSLIDENT	CHAR	35	0	Rental Request Identification (Local ID)
15	SOBJGROUP	☐	RESADSOBJGROUP	RESADSOBJGROUP	NUMC	2	0	Rental object group	TIVAR02
16	XMEMOTEXT	☐	RESADXMEMOTEXT	RESADXMEMOTEXT	CHAR	85	0	Memo Text For The Request (User-Defined Text)
17	DFREEFROM	☐	RESADDFREEFROMDE	DATS	DATS	8	0	Occup.as from
18	DFREETILL	☐	RESADDFREETILLDE	DATS	DATS	8	0	Limited lease in until
19	CURRKEY	☐	RESADCURRKEY	WAERS	CUKY	5	0	Currency	TCURC
20	AREAKEY	☐	RESADAREAKEY	MEINS	UNIT	3	0	Area unit	T006
21	SAQUISIT	☐	RESADSAQUISIT	RESADSAQUISIT	CHAR	1	0	Acquisition Form (Rent or Purchase)
22	PRENTEXCL	☐	RESADPRENTEXCL	RESADPRENTALL	CURR	13	2	Total Net Monthly Rent
23	PRENTINCL	☐	RESADPRENTINCL	RESADPRENTALL	CURR	13	2	Total Gross Monthly Rent
24	PRENTAREAEXCL	☐	RESADPRENTAREAEXCL	RESADPRENTAREA	CURR	13	2	Net Rent per Area Unit and Year
25	PRENTAREAINCL	☐	RESADPRENTAREAINCL	RESADPRENTAREA	CURR	13	2	Gross Rent per Area Unit and Year
26	PSIZEALL	☐	RESADPSIZEALL	VVBFLART	QUAN	14	4	Total area
27	PSIZEUSE	☐	RESADPSIZEUSE	VVBFLART	QUAN	14	4	Residential/Usable Space
28	NROOMFULL	☐	RESADNROOMFULL	RESADNROOMFULL	NUMC	2	0	Number of Full Rooms
29	NROOMHALF	☐	RESADNROOMHALF	RESADNROOMHALF	NUMC	1	0	Number of Half Rooms
30	SFLOORCOD	☐	RESADSFLOORCOD	RESADSFLOORCOD	NUMC	1	0	Floor Selection
31	JFLOOREXC	☐	RESADJFLOOREXC	XFELD	CHAR	1	0	Exclude Floor
32	SLOCALGRP	☐	RESADSLOCALGRP	RESADSLOCALGRP	NUMC	1	0	District Location Group Rental Request	TIVAR14
33	STRAFFROU	☐	RESADSTRAFFROU		NUMC	1	0	Transport connections	TIVAR06
34	DBUILDDAT	☐	RESADDBUILDDAT	DATS	DATS	8	0	Building date
35	DRSTORDAT	☐	RESADRSTORDAT	DATS	DATS	8	0	Modernization Date
36	SAGEGROUP	☐	RESADSAGEGROUP	RESADSNEWBUILD	CHAR	1	0	Building Age Class
37	CFAFCODE	☐	RESADCFAFCODE	RESADCFAFCODE	CHAR	20	0	Fixtures and Fittings Characteristic String
38	SPARKGRP	☐	RESADSPARKGRP	RESADSPARKGRP	NUMC	2	0	Group of Real Estate Object Parking Spaces	TIVAR12
39	OCCUPOBLIGO	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
40	OCCUPOBLIGO2	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
41	OCCUPOBLIGO3	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
42	OCCUPOBLIGO4	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
43	JISPUBLIC	☐	RESADJISPUBLIC	XFELD	CHAR	1	0	Offer is Available
44	JAUTOINFO	☐	RESADJAUTOINFO	XFELD	CHAR	1	0	Automatic Notification
45	ZIPSTRING	☐	RESADZIPSTRING	RESADZIPSTRING	CHAR	35	0	Character String With Zip Code Details For Rental Request
46	.INCLUDE	☐				0	0	RE: REse@rch - Location Description
47	SCOUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
48	SREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
49	SCOUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
50	SCITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
51	ZIPCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
52	LOCATION	☐	ORT01_GP	TEXT35	CHAR	35	0	City
53	SUBLOCAT	☐	ORT02_GP	TEXT35	CHAR	35	0	District
54	STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
55	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
56	AUTHGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
57	PROCESSMARK	☐	VVIBEARKZ	CHAR4	CHAR	4	0	Processing Indicator for Rental Request	TIVC1
58	PRESELECTION	☐	VVIVORMKZ	CHAR4	CHAR	4	0	Preselection Indicator for Rental Request	TIVC2
59	PROCESSSTAT	☐	VVIBSTAT	CHAR4	CHAR	4	0	Rental Request Processing Status	TIVC3
60	PARTFROM	☐	VVIPARTFROM	CHAR4	CHAR	4	0	Source of Prospect	TIVP1
61	PARTWHY	☐	VVIPARTWHY	CHAR4	CHAR	4	0	Reason for Acquisition	TIVP2
62	PARTWAY	☐	VVIWAY	CHAR4	CHAR	4	0	Enquiry method	TIVP3
63	DAPPLY	☐	DEINB	DDAT	DATS	8	0	Date application was received
64	SCRDSTNDG	☐	SBONI	SBONI	NUMC	2	0	Credit standing application	TIV62
65	XCRDSTNDG	☐	XWBONI	XTEXT50	CHAR	50	0	Reason for credit standing
66	NNUMPERS	☐	APERS	DEC3	DEC	3	0	Number of persons
67	XPASSPORT	☐	XPASSNR	CHAR18	CHAR	18	0	Passport number
68	DPASSSUB	☐	DPASSV	DDAT	DATS	8	0	Date of submission of passport
69	JWBS	☐	JWBS	XFELD	CHAR	1	0	Indicator: Accommodation entitlement certificate exists
70	DWBS	☐	WBSDATUM	DATUM	DATS	8	0	Accommodation entitlement certificate from
71	DWBSVALID	☐	WBSGUELT	DATUM	DATS	8	0	Accommodation entitlement certificate valid to
72	DWBSREFUSE	☐	WBSABL	DATUM	DATS	8	0	Accommodation entitlement certificate refused on
73	WBSPRIORITY	☐	VVWBSDRING	CHAR4	CHAR	4	0	Priority for accommodation entitlement certificate	TIVB7
74	WBSPERSON	☐	WBSPERS	CHAR4	CHAR	4	0	Accomm.entitlement certif: Special group of people	TIVB8
75	WBSAPPEND	☐	WBSZUS	CHAR8	CHAR	8	0	Additional information for accomm.entitlemnt certif.	TIVB9
76	WBSNROOMFULL	☐	WBSAZIMM	DEC3	DEC	3	0	No. of rooms acc.to accommodation entitlement certificate
77	WBSNROOMHALF	☐	WBSAHALBZI	DEC2	DEC	2	0	Half room acc.to accommodation entitlement certificate
78	WBSAREAKEY	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
79	WBSPSIZE	☐	WBSFQM	VVBFLART	QUAN	14	4	Area factor acc.to accommodation entitlement certificate
80	WBSREFERENCE	☐	WBSGS	TEXT20	CHAR	20	0	Accommodation entitlement certificate reference no.
81	WBSMEMO	☐	WBSINFO	TEXT40	CHAR	40	0	Memo on accommodation entitlement certificate
82	INCOME_CUR	☐	VVINCOME_CUR	WAERS	CUKY	5	0	Currency of Net Income	TCURC
83	NET_INCOME	☐	VVNET_INCOME	WERTV8	CURR	15	2	Annual Net Income
84	NATION	☐	VVNATION	LAND1	CHAR	3	0	Nationality	T005
85	PARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
86	SBWNR	☐	SBWNR	SBWNR	NUMC	7	0	Application number	VIMI11
87	SMIWUNR	☐	SMIWUNR	SMIWUNR	NUMC	3	0	Rent request number	VIMI12

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIAR02	AREAKEY	T006	MSEHI	KEY	1	CN
2	VIAR02	CURRKEY	TCURC	WAERS	KEY	1	CN
3	VIAR02	INCOME_CUR	TCURC	WAERS	KEY	1	CN
4	VIAR02	MANDT	T000	MANDT	KEY	1	CN
5	VIAR02	NATION	T005	LAND1	KEY	1	CN
6	VIAR02	OCCUPOBLIGO	TIV31	RBELBIND	KEY	1	CN
7	VIAR02	OCCUPOBLIGO2	TIV31	RBELBIND	KEY	1	CN
8	VIAR02	OCCUPOBLIGO3	TIV31	RBELBIND	KEY	1	CN
9	VIAR02	OCCUPOBLIGO4	TIV31	RBELBIND	KEY	1	CN
10	VIAR02	PARTFROM	TIVP1	PARTFROM	KEY	1	CN
11	VIAR02	PARTNR	BP000	PARTNR	KEY	1	CN
12	VIAR02	PARTWAY	TIVP3	WAY	KEY	1	CN
13	VIAR02	PARTWHY	TIVP2	PARTWHY	KEY	1	CN
14	VIAR02	PRESELECTION	TIVC2	VORMKZ	KEY	1	CN
15	VIAR02	PROCESSMARK	TIVC1	BEARKZ	KEY	1	CN
16	VIAR02	PROCESSSTAT	TIVC3	BSTAT	KEY	1	CN
17	VIAR02	SBWNR	VIMI11	SBWNR	KEY	1	CN
18	VIAR02	SCITYC	T005G	CITYC	KEY	1	CN
19	VIAR02	SCOUNC	T005E	COUNC	KEY	1	CN
20	VIAR02	SCOUNTRY	T005	LAND1	KEY	1	CN
21	VIAR02	SCRDSTNDG	TIV62	SBONI	KEY	1	CN
22	VIAR02	SLOCALGRP	TIVAR14	SLOCALGRP	KEY	1	CN
23	VIAR02	SMIWUNR	VIMI12	SMIWUNR	KEY	1	CN
24	VIAR02	SOBJGROUP	TIVAR02	SOBJGROUP	KEY	1	CN
25	VIAR02	SPARKGRP	TIVAR12	SPARKGRP	KEY	1	CN
26	VIAR02	SPARTID	VIAR03	SPARTID	KEY	1	CN
27	VIAR02	SREGIO	T005S	BLAND	KEY	1	CN
28	VIAR02	STRAFFROU	TIVAR06	STRAFFROU	KEY	1	CN
29	VIAR02	WBSAPPEND	TIVB9	WBSZUS	KEY	1	CN
30	VIAR02	WBSAREAKEY	T006	MSEHI	KEY	1	CN
31	VIAR02	WBSPERSON	TIVB8	WBSPERS	KEY	1	CN
32	VIAR02	WBSPRIORITY	TIVB7	WBSDRING	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in