USR03

User address data | #masterdata | Component: User and Authorization Management
Column Name Description
MANDT FK Client
BNAME User Name in User Master Record
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
NAME1 Name of user within the company XUNAME1
NAME2 Name of user within the company XUNAME1
NAME3 Name of user within the company XUNAME1
NAME4 Name of user within the company XUNAME1
SALUT Form of address for letters XUSALUT
ABTLG Department ABTEI
KOSTL Cost center CHAR8
BUINR Building number XUBUINR
ROONR Room number XUROONR
STRAS Street and House Number TEXT30
PFACH PO box XUPFACH
PSTLZ Postal code XUPSTLZ
ORT01 Location TEXT25
TELPR Telephone number (private) XUTELNR
TELNR Telephone number (work) XUTELNR
TEL01 Telephone number TEL01
TEL02 Telephone number TEL01
TELX1 Telex number TEXT30
TELFX Fax Number TEXT31
TELTX Teletex number TEXT30
ORT02 Location TEXT25
PSTL2 District Postal Code XUPSTLZ
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • USR03.LAND1 == T005.LAND1
  • USR03.MANDT == T005.MANDT
Client USR03.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • USR03.MANDT == T005S.MANDT
  • USR03.LAND1 == T005S.LAND1
  • USR03.REGIO == T005S.BLAND
Language Key USR03.SPRAS == T002.SPRAS
Time Zone
  • USR03.MANDT == TTZZ.CLIENT
  • USR03.TZONE == TTZZ.TZONE