SAP ABAP Table REARALVVIAR02 (RE: REsearch ALV Display For viar02)

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	REARALVVIAR02	Table Relationship Diagram
Short Description	RE: REsearch ALV Display For viar02

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	KZ	☐	XFELD	XFELD	CHAR	1	0	Checkbox
2	.INCLUDE	☐				0	0	RE: REse@rch - RE Requests
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	SIDGDEMAND	☐	RESADSGDEMAND	RESADSGDEMAND	CHAR	20	0	Rental Request 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	SIDLDEMAND	☐	RESADSLDEMAND	RESADSLIDENT	CHAR	35	0	Rental Request Identification (Local ID)
17	SOBJGROUP	☐	RESADSOBJGROUP	RESADSOBJGROUP	NUMC	2	0	Rental object group	TIVAR02
18	XMEMOTEXT	☐	RESADXMEMOTEXT	RESADXMEMOTEXT	CHAR	85	0	Memo Text For The Request (User-Defined Text)
19	DFREEFROM	☐	RESADDFREEFROMDE	DATS	DATS	8	0	Occup.as from
20	DFREETILL	☐	RESADDFREETILLDE	DATS	DATS	8	0	Limited lease in until
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	SFLOORCOD	☐	RESADSFLOORCOD	RESADSFLOORCOD	NUMC	1	0	Floor Selection
33	JFLOOREXC	☐	RESADJFLOOREXC	XFELD	CHAR	1	0	Exclude Floor
34	SLOCALGRP	☐	RESADSLOCALGRP	RESADSLOCALGRP	NUMC	1	0	District Location Group Rental Request	TIVAR14
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	SAGEGROUP	☐	RESADSAGEGROUP	RESADSNEWBUILD	CHAR	1	0	Building Age Class
39	CFAFCODE	☐	RESADCFAFCODE	RESADCFAFCODE	CHAR	20	0	Fixtures and Fittings Characteristic String
40	SPARKGRP	☐	RESADSPARKGRP	RESADSPARKGRP	NUMC	2	0	Group of Real Estate Object Parking Spaces	TIVAR12
41	OCCUPOBLIGO	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
42	OCCUPOBLIGO2	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
43	OCCUPOBLIGO3	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
44	OCCUPOBLIGO4	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
45	JISPUBLIC	☐	RESADJISPUBLIC	XFELD	CHAR	1	0	Offer is Available
46	JAUTOINFO	☐	RESADJAUTOINFO	XFELD	CHAR	1	0	Automatic Notification
47	ZIPSTRING	☐	RESADZIPSTRING	RESADZIPSTRING	CHAR	35	0	Character String With Zip Code Details For Rental Request
48	.INCLUDE	☐				0	0	RE: REse@rch - Location Description
49	SCOUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
50	SREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
51	SCOUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
52	SCITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
53	ZIPCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
54	LOCATION	☐	ORT01_GP	TEXT35	CHAR	35	0	City
55	SUBLOCAT	☐	ORT02_GP	TEXT35	CHAR	35	0	District
56	STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
57	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
58	AUTHGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
59	PROCESSMARK	☐	VVIBEARKZ	CHAR4	CHAR	4	0	Processing Indicator for Rental Request	TIVC1
60	PRESELECTION	☐	VVIVORMKZ	CHAR4	CHAR	4	0	Preselection Indicator for Rental Request	TIVC2
61	PROCESSSTAT	☐	VVIBSTAT	CHAR4	CHAR	4	0	Rental Request Processing Status	TIVC3
62	PARTFROM	☐	VVIPARTFROM	CHAR4	CHAR	4	0	Source of Prospect	TIVP1
63	PARTWHY	☐	VVIPARTWHY	CHAR4	CHAR	4	0	Reason for Acquisition	TIVP2
64	PARTWAY	☐	VVIWAY	CHAR4	CHAR	4	0	Enquiry method	TIVP3
65	DAPPLY	☐	DEINB	DDAT	DATS	8	0	Date application was received
66	SCRDSTNDG	☐	SBONI	SBONI	NUMC	2	0	Credit standing application	TIV62
67	XCRDSTNDG	☐	XWBONI	XTEXT50	CHAR	50	0	Reason for credit standing
68	NNUMPERS	☐	APERS	DEC3	DEC	3	0	Number of persons
69	XPASSPORT	☐	XPASSNR	CHAR18	CHAR	18	0	Passport number
70	DPASSSUB	☐	DPASSV	DDAT	DATS	8	0	Date of submission of passport
71	JWBS	☐	JWBS	XFELD	CHAR	1	0	Indicator: Accommodation entitlement certificate exists
72	DWBS	☐	WBSDATUM	DATUM	DATS	8	0	Accommodation entitlement certificate from
73	DWBSVALID	☐	WBSGUELT	DATUM	DATS	8	0	Accommodation entitlement certificate valid to
74	DWBSREFUSE	☐	WBSABL	DATUM	DATS	8	0	Accommodation entitlement certificate refused on
75	WBSPRIORITY	☐	VVWBSDRING	CHAR4	CHAR	4	0	Priority for accommodation entitlement certificate	TIVB7
76	WBSPERSON	☐	WBSPERS	CHAR4	CHAR	4	0	Accomm.entitlement certif: Special group of people	TIVB8
77	WBSAPPEND	☐	WBSZUS	CHAR8	CHAR	8	0	Additional information for accomm.entitlemnt certif.	TIVB9
78	WBSNROOMFULL	☐	WBSAZIMM	DEC3	DEC	3	0	No. of rooms acc.to accommodation entitlement certificate
79	WBSNROOMHALF	☐	WBSAHALBZI	DEC2	DEC	2	0	Half room acc.to accommodation entitlement certificate
80	WBSAREAKEY	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
81	WBSPSIZE	☐	WBSFQM	VVBFLART	QUAN	14	4	Area factor acc.to accommodation entitlement certificate
82	WBSREFERENCE	☐	WBSGS	TEXT20	CHAR	20	0	Accommodation entitlement certificate reference no.
83	WBSMEMO	☐	WBSINFO	TEXT40	CHAR	40	0	Memo on accommodation entitlement certificate
84	INCOME_CUR	☐	VVINCOME_CUR	WAERS	CUKY	5	0	Currency of Net Income	TCURC
85	NET_INCOME	☐	VVNET_INCOME	WERTV8	CURR	15	2	Annual Net Income
86	NATION	☐	VVNATION	LAND1	CHAR	3	0	Nationality	T005
87	PARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
88	SBWNR	☐	SBWNR	SBWNR	NUMC	7	0	Application number	VIMI11
89	SMIWUNR	☐	SMIWUNR	SMIWUNR	NUMC	3	0	Rent request number	VIMI12
90	XOBJGROUP	☐	RESADXOBJGROUP	RESADXOBJGROUP	CHAR	30	0	Object Group Text
91	XLOCALGRP	☐	RESADXLOCALGRP	RESADXLOCALGRP	CHAR	30	0	District Location Group Text
92	XTRAFFROU	☐	RESADXTRAFFROU	XTEXT30	CHAR	30	0	Text for Transport Connections
93	XPARKGRP	☐	RESADXPARKGRP	RESADXPARKGRP	CHAR	30	0	Text For Group of Real Estate Object Parking Spaces
94	XOCCUPOBLIGO	☐	XMBELBEZ	XMBEZ	CHAR	30	0	Occupancy obligation name
95	XOCCUPOBLIGO2	☐	XMBELBEZ	XMBEZ	CHAR	30	0	Occupancy obligation name
96	XOCCUPOBLIGO3	☐	XMBELBEZ	XMBEZ	CHAR	30	0	Occupancy obligation name
97	XOCCUPOBLIGO4	☐	XMBELBEZ	XMBEZ	CHAR	30	0	Occupancy obligation name
98	XPROCESSMARK	☐	XMBEZ	XMBEZ	CHAR	30	0	Normal name (30 characters)
99	XPRESELECTION	☐	XMBEZ	XMBEZ	CHAR	30	0	Normal name (30 characters)
100	XPROCESSSTAT	☐	XMBEZ	XMBEZ	CHAR	30	0	Normal name (30 characters)
101	XXCRDSTNDG	☐	XMBONI	XMBEZ	CHAR	30	0	Description of credit standing of application
102	XWBSPRIORITY	☐	VVXWBSDR	XMBEZ	CHAR	30	0	Name of level of priority for AEC
103	XWBSPERSON	☐	VVXWBSPERS	XMBEZ	CHAR	30	0	AEC Special groups of people - Description
104	XWBSAPPEND	☐	XWBSZUS	XMBEZ	CHAR	30	0	Addit.info on accomm.entitlement cert. - Description
105	XPARTNR	☐	XBEWERBER	XLBEZ	CHAR	60	0	Name of applicant

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in