SAP ABAP Table RFVIAR03 (RE: REse@rch - Maintenance Structure for Table VIAR03)

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	RFVIAR03	Table Relationship Diagram
Short Description	RE: REse@rch - Maintenance Structure for Table VIAR03

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: REsearch - Offering/Searching Party (Web User)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	SPARTID	☐	RESADSPARTID	RESADSPARTID	CHAR	10	0	Identification of Offering/Searching Party (User ID)	*
4	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
5	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
6	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
7	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
8	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
9	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
10	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
11	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
12	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
13	.INCLUDE	☐				0	0	RE: Data for Saving Last Access
14	ACCNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
15	ACCDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
16	ACCTIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
17	ACCTCOD	☐	SYTCODE	TCODE	CHAR	20	0	Transaction Code	*
18	SUSRTYPE	☐	RESADSUSRTYPE	RESADSUSRTYPE	CHAR	2	0	REsearch User Type (Residential/Commercial)	TIVAR13
19	JHIDDEN	☐	RESADJPARTHID	XFELD	CHAR	1	0	Partner Data Cannot Be Accessed By Others
20	XPASSWORD	☐	RESADXPASSWORD		CHAR	10	0	Password of Offering/Searching Party
21	STITLE	☐	BP_TITLE_OLD	BP_TITLE	NUMC	2	0	Form of Address (Key)	TP01
22	XNAMELAST	☐	BP_NAMLAST	TEXT40	CHAR	40	0	Last Name
23	XNAMEFRST	☐	BP_NAMFRST	TEXT40	CHAR	40	0	First Name
24	XPOSTFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
25	.INCLUDE	☐				0	0	RE: REse@rch - Location Description
26	SCOUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
27	SREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
28	SCOUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
29	SCITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
30	ZIPCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
31	LOCATION	☐	ORT01_GP	TEXT35	CHAR	35	0	City
32	SUBLOCAT	☐	ORT02_GP	TEXT35	CHAR	35	0	District
33	STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
34	XEMAIL	☐	VVEMAIL	VVEMAIL	CHAR	50	0	E-mail Address
35	XHOMEPAGE	☐	RESADXHOMEPAGE	VVEMAIL	CHAR	50	0	Homepage URL
36	XTELNRDAY	☐	RESADXTELNR		CHAR	25	0	REsearch User Telephone Number
37	XTELNREVG	☐	RESADXTELNR		CHAR	25	0	REsearch User Telephone Number
38	XFAXNR	☐	RESADXFAXNR		CHAR	25	0	Fax Number of REsearch User
39	CURRKEY	☐	RESADCURRKEY	WAERS	CUKY	5	0	Currency	TCURC
40	AREAKEY	☐	RESADAREAKEY	MEINS	UNIT	3	0	Area unit	T006
41	JWEBSAFE	☐	RESADJWEBSAFE	FLAG	CHAR	1	0	Object Protected Against Change Attempts Made In Internet
42	CHNGIND	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
43	XPASSWDCP	☐	RESADXPASSWORD		CHAR	10	0	Password of Offering/Searching Party

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RFVIAR03	AREAKEY	T006	MSEHI	KEY	1	CN
2	RFVIAR03	CURRKEY	TCURC	WAERS	KEY	1	CN
3	RFVIAR03	MANDT	T000	MANDT	KEY	1	CN
4	RFVIAR03	SCITYC	T005G	CITYC	KEY	1	CN
5	RFVIAR03	SCOUNC	T005E	COUNC	KEY	1	CN
6	RFVIAR03	SCOUNTRY	T005	LAND1	KEY	1	CN
7	RFVIAR03	SREGIO	T005S	BLAND	KEY	1	CN
8	RFVIAR03	STITLE	TP01	TITLE	KEY	1	CN
9	RFVIAR03	SUSRTYPE	TIVAR13	SUSRTYPE	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in