SAP ABAP Table REARALVVIAR01 (RE: REsearch ALV Display For viar01)

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

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 - Offered RE Objects
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	SIDGSUPPLY	☐	RESADSGSUPPLY	RESADSGSUPPLY	CHAR	20	0	Rental Unit 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	SIDLSUPPLY	☐	RESADSLSUPPLY	RESADSLIDENT	CHAR	35	0	Rental Object (Local ID)
17	SOBJTYPE	☐	RESADSOBJTYPE	RESADSOBJTYPE	NUMC	2	0	Type of Rental Object	TIVAR01
18	JINTERNET	☐	RESADJINTERNET	XFELD	CHAR	1	0	Indicator Internet Release
19	XEYECATCH	☐	RESADXEYECATCH	RESADXEYECATCH	CHAR	85	0	Short Description of Real Estate Object on Offer
20	DFREEFROM	☐	RESADDFREEFROM	DATS	DATS	8	0	Object Available From-Date
21	DFREETILL	☐	RESADDFREETILL	DATS	DATS	8	0	Object Available To-Date
22	CURRKEY	☐	RESADCURRKEY	WAERS	CUKY	5	0	Currency	TCURC
23	AREAKEY	☐	RESADAREAKEY	MEINS	UNIT	3	0	Area unit	T006
24	SAQUISIT	☐	RESADSAQUISIT	RESADSAQUISIT	CHAR	1	0	Acquisition Form (Rent or Purchase)
25	PRENTEXCL	☐	RESADPRENTEXCL	RESADPRENTALL	CURR	13	2	Total Net Monthly Rent
26	PRENTINCL	☐	RESADPRENTINCL	RESADPRENTALL	CURR	13	2	Total Gross Monthly Rent
27	PRENTAREAEXCL	☐	RESADPRENTAREAEXCL	RESADPRENTAREA	CURR	13	2	Net Rent per Area Unit and Year
28	PRENTAREAINCL	☐	RESADPRENTAREAINCL	RESADPRENTAREA	CURR	13	2	Gross Rent per Area Unit and Year
29	PSIZEALL	☐	RESADPSIZEALL	VVBFLART	QUAN	14	4	Total area
30	PSIZEUSE	☐	RESADPSIZEUSE	VVBFLART	QUAN	14	4	Residential/Usable Space
31	NROOMFULL	☐	RESADNROOMFULL	RESADNROOMFULL	NUMC	2	0	Number of Full Rooms
32	NROOMHALF	☐	RESADNROOMHALF	RESADNROOMHALF	NUMC	1	0	Number of Half Rooms
33	SFLOORNUM	☐	RESADSFLOORNUM	VVSSTOCKW	NUMC	3	0	Floor of Rental Object	TIV37
34	SFLOORMAX	☐	RESADSFLOORMAX	VVSSTOCKW	NUMC	3	0	Highest Floor	TIV37
35	SFLOORCOD	☐	RESADSFLOORCOD	RESADSFLOORCOD	NUMC	1	0	Floor Selection
36	SLOCALPOS	☐	RESADSLOCALPOS	RESADSLOCALPOS	NUMC	1	0	District Location of a Real Estate Object (Offer Object)	TIVAR05
37	STRAFFROU	☐	RESADSTRAFFROU		NUMC	1	0	Transport connections	TIVAR06
38	DBUILDDAT	☐	RESADDBUILDDAT	DATS	DATS	8	0	Building date
39	DRSTORDAT	☐	RESADRSTORDAT	DATS	DATS	8	0	Modernization Date
40	CFAFCODE	☐	RESADCFAFCODE	RESADCFAFCODE	CHAR	20	0	Fixtures and Fittings Characteristic String
41	SPARKBAY	☐	RESADSPARKBAY	RESADSPARKBAY	NUMC	2	0	Type of Parking Space	TIVAR04
42	SPARKBAY2	☐	RESADSPARKBAY	RESADSPARKBAY	NUMC	2	0	Type of Parking Space	TIVAR04
43	OCCUPOBLIGO	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
44	JWBSPREFERRED	☐	RESADJWBSPREFERRED	BOOLE	CHAR	1	0	Accommodation Entitlement Certificate Is Advantageous
45	.INCLUDE	☐				0	0	RE: REse@rch - Location Description
46	SCOUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
47	SREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
48	SCOUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
49	SCITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
50	ZIPCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
51	LOCATION	☐	ORT01_GP	TEXT35	CHAR	35	0	City
52	SUBLOCAT	☐	ORT02_GP	TEXT35	CHAR	35	0	District
53	STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
54	.INCLUDE	☐				0	0	RE: REse@rch - IDs of the Screen Objects of an RE Offer
55	IMGDOCID01	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
56	IMGDOCID02	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
57	IMGDOCID03	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
58	TXTDOCID	☐	BDS_DOCID	CHAR42	CHAR	42	0	Business Document Service: Document ID
59	SOBJGROUP	☐	RESADSOBJGROUP	RESADSOBJGROUP	NUMC	2	0	Rental object group	TIVAR02
60	XOBJTYPE	☐	RESADXOBJTYPE	RESADXOBJTYPE	CHAR	30	0	Object Category Description
61	XLOCALPOS	☐	RESADXLOCALPOS	XTEXT30	CHAR	30	0	District Location Text
62	XTRAFFROU	☐	RESADXTRAFFROU	XTEXT30	CHAR	30	0	Text for Transport Connections
63	XPARKBAY	☐	RESADXPARKBAY	RESADXPARKBAY	CHAR	30	0	Text for Parking Space
64	XOCCUPOBLIGO	☐	XMBELBEZ	XMBEZ	CHAR	30	0	Occupancy obligation name
65	XADDRESS	☐	RESADXADDRESS	RESADXADDRESS	CHAR	50	0	Address of Real Estate Object
66	PCORREL	☐	RESADPCORREL	RESADPCORREL	DEC	5	2	REsearch: Penalty Amount For Offer And Request

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in