SAP table USER_ADDR (Generated Table for View)

SAP table USER_ADDR has 20 primary key fields being MANDT,BNAME,NAME_FIRST,NAME_LAST,NAME_TEXTC,TEL_EXTENS,KOSTL,BUILDING,ROOMNUMBER,DEPARTMENT,INHOUSE_ML,NAME1,CITY1,POST_CODE1,MC_NAMEFIR,MC_NAMELAS,MC_NAME1,MC_CITY1,COMPANY,IDADTYPE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BNAME User Name in User Master Record CHAR 12 0 USR02 XUBNAME
NAME_FIRST First name CHAR 40 0 AD_NAMEFIR
NAME_LAST Last name CHAR 40 0 AD_NAMELAS
NAME_TEXTC Full Name of Person CHAR 80 0 AD_NAMTEXT
TEL_EXTENS First Telephone No.: Extension CHAR 10 0 AD_TLXTNS1
KOSTL Cost center CHAR 8 0 XUKOSTL
BUILDING Building (number or code) CHAR 10 0 AD_BLDNG_P
ROOMNUMBER Room or Apartment Number CHAR 10 0 AD_ROOMNUM
DEPARTMENT Department CHAR 40 0 AD_DPRTMNT
INHOUSE_ML Internal Mail Postal Code CHAR 10 0 AD_IH_MAIL
NAME1 Name 1 CHAR 40 0 AD_NAME1
CITY1 City CHAR 40 0 AD_CITY1
POST_CODE1 City postal code CHAR 10 0 AD_PSTCD1
MC_NAMEFIR First Name in Uppercase for Search Help CHAR 25 0 AD_MC_NMFI
MC_NAMELAS Last Name in Uppercase for Search Help CHAR 25 0 AD_MC_NMLA
MC_NAME1 Name (Field NAME1) in Uppercase for Search Help CHAR 25 0 AD_MC_NAME
MC_CITY1 City name in Uppercase for Search Help CHAR 25 0 AD_MC_CITY
COMPANY Company address, cross-system key CHAR 42 0 USCOMP
IDADTYPE Address Type of the Identity NUMC 2 0 SUIDADTYPE
00 User's Old Type 3 Address
01 Technical User
02 Identity (User Account with BP Person)
03 Identity with BP Person, BP Organization and Type 3 Address
04 Identity with Workplace Address

USER_ADDR foreign key relationships

Table Field Check Table Check Field
0 USER_ADDR BNAME USR02 Logon Data (Kernel-Side Use) BNAME