SAP ABAP Table RFVIDEMAND (RE: REsearch - Screen Structure for Request 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	RFVIDEMAND	Table Relationship Diagram
Short Description	RE: REsearch - Screen Structure for Request 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 VIAR02
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	CHNGIND	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
91	JMARKED	☐	RESADJMARKED	XFELD	CHAR	1	0	REsearch: Line is selected
92	PCORREL	☐	RESADPCORREL	RESADPCORREL	DEC	5	2	REsearch: Penalty Amount For Offer And Request
93	JFAVORIT	☐	RESADJFAVORIT	XFELD	CHAR	1	0	Entry Is In Favorite List
94	YOBJBUILD	☐	RESADYOBJBUILD	GJAHR	NUMC	4	0	Construction Year of Real Estate Object
95	YOBJRSTOR	☐	RESADYOBJRSTOR	GJAHR	NUMC	4	0	Modernization Year of Real Estate Object
96	XOBJGROUP	☐	RESADXOBJGROUP	RESADXOBJGROUP	CHAR	30	0	Object Group Text
97	XADDRESS	☐	RESADXADDRESS	RESADXADDRESS	CHAR	50	0	Address of Real Estate Object
98	XFLOORCOD	☐	RESADXFLOORCOD	DDTEXT	CHAR	60	0	Floor Group Text
99	XLOCALGRP	☐	RESADXLOCALGRP	RESADXLOCALGRP	CHAR	30	0	District Location Group Text
100	XTRAFFROU	☐	RESADXTRAFFROU	XTEXT30	CHAR	30	0	Text for Transport Connections
101	XPARKGRP	☐	RESADXPARKGRP	RESADXPARKGRP	CHAR	30	0	Text For Group of Real Estate Object Parking Spaces
102	XAGEGROUP	☐	RESADXAGEGROUP	DDTEXT	CHAR	60	0	Building Age Class Text
103	XBELBIND1	☐	XKBELBEZ	XKBEZ	CHAR	15	0	Occupancy obligation short text
104	XBELBIND2	☐	XKBELBEZ	XKBEZ	CHAR	15	0	Occupancy obligation short text
105	XBELBIND3	☐	XKBELBEZ	XKBEZ	CHAR	15	0	Occupancy obligation short text
106	XBELBIND4	☐	XKBELBEZ	XKBEZ	CHAR	15	0	Occupancy obligation short text
107	XROOMDATA	☐	RESADXROOMDATA		CHAR	10	0	Room Details Listed as "<Whole Rooms>/"<Half Rooms>"
108	XFAVICON	☐	RESADXFAVICON	ICON	CHAR	4	0	Entry Available in Favorites (Icon)	*
109	XDELETE	☐	RESADXSYMBOL	CHAR20	CHAR	20	0	REsearch: Icon/Symbol Name
110	XCHANGE	☐	RESADXSYMBOL	CHAR20	CHAR	20	0	REsearch: Icon/Symbol Name
111	XSEARCH	☐	RESADXSYMBOL	CHAR20	CHAR	20	0	REsearch: Icon/Symbol Name
112	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	RFVIDEMAND	AREAKEY	T006	MSEHI	KEY	1	CN
2	RFVIDEMAND	CURRKEY	TCURC	WAERS	KEY	1	CN
3	RFVIDEMAND	INCOME_CUR	TCURC	WAERS	KEY	1	CN
4	RFVIDEMAND	MANDT	T000	MANDT	KEY	1	CN
5	RFVIDEMAND	NATION	T005	LAND1	KEY	1	CN
6	RFVIDEMAND	OCCUPOBLIGO	TIV31	RBELBIND	KEY	1	CN
7	RFVIDEMAND	OCCUPOBLIGO2	TIV31	RBELBIND	KEY	1	CN
8	RFVIDEMAND	OCCUPOBLIGO3	TIV31	RBELBIND	KEY	1	CN
9	RFVIDEMAND	OCCUPOBLIGO4	TIV31	RBELBIND	KEY	1	CN
10	RFVIDEMAND	PARTFROM	TIVP1	PARTFROM	KEY	1	CN
11	RFVIDEMAND	PARTNR	BP000	PARTNR	KEY	1	CN
12	RFVIDEMAND	PARTWAY	TIVP3	WAY	KEY	1	CN
13	RFVIDEMAND	PARTWHY	TIVP2	PARTWHY	KEY	1	CN
14	RFVIDEMAND	PRESELECTION	TIVC2	VORMKZ	KEY	1	CN
15	RFVIDEMAND	PROCESSMARK	TIVC1	BEARKZ	KEY	1	CN
16	RFVIDEMAND	PROCESSSTAT	TIVC3	BSTAT	KEY	1	CN
17	RFVIDEMAND	SBWNR	VIMI11	SBWNR	KEY	1	CN
18	RFVIDEMAND	SCITYC	T005G	CITYC	KEY	1	CN
19	RFVIDEMAND	SCOUNC	T005E	COUNC	KEY	1	CN
20	RFVIDEMAND	SCOUNTRY	T005	LAND1	KEY	1	CN
21	RFVIDEMAND	SCRDSTNDG	TIV62	SBONI	KEY	1	CN
22	RFVIDEMAND	SLOCALGRP	TIVAR14	SLOCALGRP	KEY	1	CN
23	RFVIDEMAND	SMIWUNR	VIMI12	SMIWUNR	KEY	1	CN
24	RFVIDEMAND	SOBJGROUP	TIVAR02	SOBJGROUP	KEY	1	CN
25	RFVIDEMAND	SPARKGRP	TIVAR12	SPARKGRP	KEY	1	CN
26	RFVIDEMAND	SPARTID	VIAR03	SPARTID	KEY	1	CN
27	RFVIDEMAND	SREGIO	T005S	BLAND	KEY	1	CN
28	RFVIDEMAND	STRAFFROU	TIVAR06	STRAFFROU	KEY	1	CN
29	RFVIDEMAND	WBSAPPEND	TIVB9	WBSZUS	KEY	1	CN
30	RFVIDEMAND	WBSAREAKEY	T006	MSEHI	KEY	1	CN
31	RFVIDEMAND	WBSPERSON	TIVB8	WBSPERS	KEY	1	CN
32	RFVIDEMAND	WBSPRIORITY	TIVB7	WBSDRING	KEY	1	CN

History

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