SAP ABAP Table RFVISADDEMAND (RE: REse@rch - Object Attributes Relevant to Search)

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	RFVISADDEMAND	Table Relationship Diagram
Short Description	RE: REse@rch - Object Attributes Relevant to Search

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	SIDLDEMAND	☐	RESADSLDEMAND	RESADSLIDENT	CHAR	35	0	Rental Request Identification (Local ID)
2	XMEMOTEXT	☐	RESADXMEMOTEXT	RESADXMEMOTEXT	CHAR	85	0	Memo Text For The Request (User-Defined Text)
3	SOBJGROUP	☐	RESADSOBJGROUP	RESADSOBJGROUP	NUMC	2	0	Rental object group	TIVAR02
4	SPARTID	☐	RESADSPARTID	RESADSPARTID	CHAR	10	0	Identification of Offering/Searching Party (User ID)	VIAR03
5	DFREEFROM	☐	RESADDFREEFROMDE	DATS	DATS	8	0	Occup.as from
6	DFREETILL	☐	RESADDFREETILLDE	DATS	DATS	8	0	Limited lease in until
7	CURRKEY	☐	RESADCURRKEY	WAERS	CUKY	5	0	Currency	TCURC
8	AREAKEY	☐	RESADAREAKEY	MEINS	UNIT	3	0	Area unit	T006
9	SAQUISIT	☐	RESADSAQUISIT	RESADSAQUISIT	CHAR	1	0	Acquisition Form (Rent or Purchase)
10	PRENTEXCL	☐	RESADPRENTEXCL	RESADPRENTALL	CURR	13	2	Total Net Monthly Rent
11	PRENTINCL	☐	RESADPRENTINCL	RESADPRENTALL	CURR	13	2	Total Gross Monthly Rent
12	PRENTAREAEXCL	☐	RESADPRENTAREAEXCL	RESADPRENTAREA	CURR	13	2	Net Rent per Area Unit and Year
13	PRENTAREAINCL	☐	RESADPRENTAREAINCL	RESADPRENTAREA	CURR	13	2	Gross Rent per Area Unit and Year
14	PSIZEALL	☐	RESADPSIZEALL	VVBFLART	QUAN	14	4	Total area
15	PSIZEUSE	☐	RESADPSIZEUSE	VVBFLART	QUAN	14	4	Residential/Usable Space
16	NROOMFULL	☐	RESADNROOMFULL	RESADNROOMFULL	NUMC	2	0	Number of Full Rooms
17	NROOMHALF	☐	RESADNROOMHALF	RESADNROOMHALF	NUMC	1	0	Number of Half Rooms
18	SFLOORCOD	☐	RESADSFLOORCOD	RESADSFLOORCOD	NUMC	1	0	Floor Selection
19	JFLOOREXC	☐	RESADJFLOOREXC	XFELD	CHAR	1	0	Exclude Floor
20	SLOCALGRP	☐	RESADSLOCALGRP	RESADSLOCALGRP	NUMC	1	0	District Location Group Rental Request	TIVAR14
21	STRAFFROU	☐	RESADSTRAFFROU		NUMC	1	0	Transport connections	TIVAR06
22	DBUILDDAT	☐	RESADDBUILDDAT	DATS	DATS	8	0	Building date
23	DRSTORDAT	☐	RESADRSTORDAT	DATS	DATS	8	0	Modernization Date
24	SAGEGROUP	☐	RESADSAGEGROUP	RESADSNEWBUILD	CHAR	1	0	Building Age Class
25	CFAFCODE	☐	RESADCFAFCODE	RESADCFAFCODE	CHAR	20	0	Fixtures and Fittings Characteristic String
26	SPARKGRP	☐	RESADSPARKGRP	RESADSPARKGRP	NUMC	2	0	Group of Real Estate Object Parking Spaces	TIVAR12
27	OCCUPOBLIGO	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
28	OCCUPOBLIGO2	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
29	OCCUPOBLIGO3	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
30	OCCUPOBLIGO4	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
31	.INCLUDE	☐				0	0	RE: REse@rch - Location Description
32	SCOUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
33	SREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
34	SCOUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
35	SCITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
36	ZIPCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
37	LOCATION	☐	ORT01_GP	TEXT35	CHAR	35	0	City
38	SUBLOCAT	☐	ORT02_GP	TEXT35	CHAR	35	0	District
39	STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
40	JISPUBLIC	☐	RESADJISPUBLIC	XFELD	CHAR	1	0	Offer is Available
41	JAUTOINFO	☐	RESADJAUTOINFO	XFELD	CHAR	1	0	Automatic Notification
42	ZIPSTRING	☐	RESADZIPSTRING	RESADZIPSTRING	CHAR	35	0	Character String With Zip Code Details For Rental Request

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RFVISADDEMAND	AREAKEY	T006	MSEHI	KEY	1	CN
2	RFVISADDEMAND	CURRKEY	TCURC	WAERS	KEY	1	CN
3	RFVISADDEMAND	OCCUPOBLIGO	TIV31	RBELBIND	KEY	1	CN
4	RFVISADDEMAND	OCCUPOBLIGO2	TIV31	RBELBIND	KEY	1	CN
5	RFVISADDEMAND	OCCUPOBLIGO3	TIV31	RBELBIND	KEY	1	CN
6	RFVISADDEMAND	OCCUPOBLIGO4	TIV31	RBELBIND	KEY	1	CN
7	RFVISADDEMAND	SCITYC	T005G	CITYC	KEY	1	CN
8	RFVISADDEMAND	SCOUNC	T005E	COUNC	KEY	1	CN
9	RFVISADDEMAND	SCOUNTRY	T005	LAND1	KEY	1	CN
10	RFVISADDEMAND	SLOCALGRP	TIVAR14	SLOCALGRP	KEY	1	CN
11	RFVISADDEMAND	SOBJGROUP	TIVAR02	SOBJGROUP	KEY	1	CN
12	RFVISADDEMAND	SPARKGRP	TIVAR12	SPARKGRP	KEY	1	CN
13	RFVISADDEMAND	SPARTID	VIAR03	SPARTID	KEY	1	CN
14	RFVISADDEMAND	SREGIO	T005S	BLAND	KEY	1	CN
15	RFVISADDEMAND	STRAFFROU	TIVAR06	STRAFFROU	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in