SAP ABAP Table RFVISADSUPPLY (RE: REse@rch - Attributes of an Offered Rental Object)

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	RFVISADSUPPLY	Table Relationship Diagram
Short Description	RE: REse@rch - Attributes of an Offered Rental Object

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	JDELETE	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
2	JINTERNET	☐	RESADJINTERNET	XFELD	CHAR	1	0	Indicator Internet Release
3	SIDLSUPPLY	☐	RESADSLSUPPLY	RESADSLIDENT	CHAR	35	0	Rental Object (Local ID)
4	XEYECATCH	☐	RESADXEYECATCH	RESADXEYECATCH	CHAR	85	0	Short Description of Real Estate Object on Offer
5	SOBJTYPE	☐	RESADSOBJTYPE	RESADSOBJTYPE	NUMC	2	0	Type of Rental Object	TIVAR01
6	SPARTID	☐	RESADSPARTID	RESADSPARTID	CHAR	10	0	Identification of Offering/Searching Party (User ID)	VIAR03
7	DFREEFROM	☐	RESADDFREEFROM	DATS	DATS	8	0	Object Available From-Date
8	DFREETILL	☐	RESADDFREETILL	DATS	DATS	8	0	Object Available To-Date
9	CURRKEY	☐	RESADCURRKEY	WAERS	CUKY	5	0	Currency	TCURC
10	AREAKEY	☐	RESADAREAKEY	MEINS	UNIT	3	0	Area unit	T006
11	SAQUISIT	☐	RESADSAQUISIT	RESADSAQUISIT	CHAR	1	0	Acquisition Form (Rent or Purchase)
12	PRENTEXCL	☐	RESADPRENTEXCL	RESADPRENTALL	CURR	13	2	Total Net Monthly Rent
13	PRENTINCL	☐	RESADPRENTINCL	RESADPRENTALL	CURR	13	2	Total Gross Monthly Rent
14	PRENTAREAEXCL	☐	RESADPRENTAREAEXCL	RESADPRENTAREA	CURR	13	2	Net Rent per Area Unit and Year
15	PRENTAREAINCL	☐	RESADPRENTAREAINCL	RESADPRENTAREA	CURR	13	2	Gross Rent per Area Unit and Year
16	PSIZEALL	☐	RESADPSIZEALL	VVBFLART	QUAN	14	4	Total area
17	PSIZEUSE	☐	RESADPSIZEUSE	VVBFLART	QUAN	14	4	Residential/Usable Space
18	NROOMFULL	☐	RESADNROOMFULL	RESADNROOMFULL	NUMC	2	0	Number of Full Rooms
19	NROOMHALF	☐	RESADNROOMHALF	RESADNROOMHALF	NUMC	1	0	Number of Half Rooms
20	SFLOORNUM	☐	RESADSFLOORNUM	VVSSTOCKW	NUMC	3	0	Floor of Rental Object	TIV37
21	SFLOORMAX	☐	RESADSFLOORMAX	VVSSTOCKW	NUMC	3	0	Highest Floor	TIV37
22	SFLOORCOD	☐	RESADSFLOORCOD	RESADSFLOORCOD	NUMC	1	0	Floor Selection
23	SLOCALPOS	☐	RESADSLOCALPOS	RESADSLOCALPOS	NUMC	1	0	District Location of a Real Estate Object (Offer Object)	TIVAR05
24	STRAFFROU	☐	RESADSTRAFFROU		NUMC	1	0	Transport connections	TIVAR06
25	DBUILDDAT	☐	RESADDBUILDDAT	DATS	DATS	8	0	Building date
26	DRSTORDAT	☐	RESADRSTORDAT	DATS	DATS	8	0	Modernization Date
27	CFAFCODE	☐	RESADCFAFCODE	RESADCFAFCODE	CHAR	20	0	Fixtures and Fittings Characteristic String
28	SPARKBAY	☐	RESADSPARKBAY	RESADSPARKBAY	NUMC	2	0	Type of Parking Space	TIVAR04
29	SPARKBAY2	☐	RESADSPARKBAY	RESADSPARKBAY	NUMC	2	0	Type of Parking Space	*
30	OCCUPOBLIGO	☐	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	JWBSPREFERRED	☐	RESADJWBSPREFERRED	BOOLE	CHAR	1	0	Accommodation Entitlement Certificate Is Advantageous

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in