SAP ABAP Table VIAR03 (RE: REsearch - Offering/Searching Party (Web User))

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	TRANSP	Transparent table
Transparent table	VIAR03	Table Relationship Diagram
Short Description	RE: REsearch - Offering/Searching Party (Web User)

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in