VIAR03

RE: REsearch - Offering/Searching Party (Web User) | #masterdata | Component: Real Estate Management
Column Name Description
MANDT FK Client
SPARTID Identification of Offering/Searching Party (User ID)
Column Name Description
Column Name Description
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
ACCDATE System Date
ACCTIME System Time
Column Name Description
JHIDDEN Partner Data Cannot Be Accessed By Others Show values
JWEBSAFE Object Protected Against Change Attempts Made In Internet Show values
Column Name Description Domain name
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
ACCNAME User Name SYCHAR12
ACCTCOD Transaction Code TCODE
XPASSWORD Password of Offering/Searching Party
XNAMELAST Last Name TEXT40
XNAMEFRST First Name TEXT40
XPOSTFACH PO Box PFACH
ZIPCODE Postal Code PSTLZ
LOCATION City TEXT35
SUBLOCAT District TEXT35
STREET Street and House Number TEXT35
XEMAIL E-mail Address VVEMAIL
XHOMEPAGE Homepage URL VVEMAIL
XTELNRDAY REsearch User Telephone Number
XTELNREVG REsearch User Telephone Number
XFAXNR Fax Number of REsearch User
Master Data Relations Join Conditions
Area unit
  • VIAR03.MANDT == T006.MANDT
  • VIAR03.AREAKEY == T006.MSEHI
Currency
  • VIAR03.MANDT == TCURC.MANDT
  • VIAR03.CURRKEY == TCURC.WAERS
Client VIAR03.MANDT == T000.MANDT
City Code
  • Region (State, Province, County)
  • City Code
  • Client
  • Country/Region Key
  • VIAR03.SREGIO == T005G.REGIO
  • VIAR03.SCITYC == T005G.CITYC
  • VIAR03.MANDT == T005G.MANDT
  • VIAR03.SCOUNTRY == T005G.LAND1
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • VIAR03.MANDT == T005E.MANDT
  • VIAR03.SCOUNC == T005E.COUNC
  • VIAR03.SCOUNTRY == T005E.LAND1
  • VIAR03.SREGIO == T005E.REGIO
Country/Region Key
  • Country/Region Key
  • Client
  • VIAR03.SCOUNTRY == T005.LAND1
  • VIAR03.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • VIAR03.MANDT == T005S.MANDT
  • VIAR03.SCOUNTRY == T005S.LAND1
  • VIAR03.SREGIO == T005S.BLAND
Form of Address (Key)
  • VIAR03.MANDT == TP01.MANDT
  • VIAR03.STITLE == TP01.TITLE
REsearch User Type (Residential/Commercial)