SAP FKK_USER_DETAILS table - Reference Structure for Addresses (Contact Partner) details in SAP

Description: User Name in User Master Record
Field Name: USERNAME
Data Element: XUBNAME
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: XUBNAME
MemoryID: XUS
AppClass: SUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

Description: Address Number
Field Name: ADDR_NO
Data Element: AD_ADDRNUM
Data Type: CHAR
length (Dec): 10(0)
Check table: ADRC
Conversion Routine: ALPHA
Domain Name: AD_ADDRNUM
MemoryID: ADR
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ADDR_NO

Description: Title text
Field Name: TITLE_P
Data Element: AD_TITLETX
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TITLE_P

Description: First name
Field Name: FIRSTNAME
Data Element: AD_NAMEFIR
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRSTNAME

Description: Last name
Field Name: LASTNAME
Data Element: AD_NAMELAS
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTNAME

Description: Middle name or second forename of a person
Field Name: MIDDLENAME
Data Element: AD_NAMEMID
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MIDDLENAME

Description: Full Name of Person
Field Name: FULLNAME
Data Element: AD_NAMTEXT
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: TEXT80
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FULLNAME

Description: Department
Field Name: DEPARTMENT
Data Element: AD_DPRTMNT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEPARTMENT

Description: Building (number or code)
Field Name: BUILDING_P
Data Element: AD_BLDNG_P
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUILDING_P

Description: Room or Apartment Number
Field Name: ROOM_NO_P
Data Element: AD_ROOMNUM
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROOM_NO_P

Description: Name 1
Field Name: NAME
Data Element: AD_NAME1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

Description: ISO Code of the Country/Region
Field Name: COUNTRYISO
Data Element: INTCA
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: INTCA
MemoryID:
AppClass:
SHLP: F4_INTCA
SHLP Field: INTCA
ConvExit:

See all SAP tables containing field COUNTRYISO

Description: Language Key
Field Name: LANGU
Data Element: SPRAS
Data Type: LANG
length (Dec): 1(0)
Check table: T002
Conversion Routine: ISOLA
Domain Name: SPRAS
MemoryID: SPR
AppClass: STXD
SHLP: H_T002
SHLP Field: SPRAS
ConvExit: ISOLA

See all SAP tables containing field LANGU

Description: 2-Character SAP Language Code
Field Name: LANGU_ISO
Data Element: LAISO
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: LAISO
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LANGU_ISO

Description: Address time zone
Field Name: TIME_ZONE
Data Element: AD_TZONE
Data Type: CHAR
length (Dec): 6(0)
Check table: TTZZ
Conversion Routine:
Domain Name: TZNZONE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIME_ZONE

Description: First telephone no.: dialling code+number
Field Name: TEL1_NUMBR
Data Element: AD_TLNMBR1
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEL1_NUMBR

Description: First Telephone No.: Extension
Field Name: TEL1_EXT
Data Element: AD_TLXTNS1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEL1_EXT

Description: Mobile Number
Field Name: MOBILE_NUMBER
Data Element: MOBILE_PHONE_KK
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: CHAR18
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MOBILE_NUMBER

Description: First Fax No.: Area Code + Number
Field Name: FAX_NUMBER
Data Element: AD_FXNMBR1
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAX_NUMBER

Description: First fax no.: extension
Field Name: FAX_EXTENS
Data Element: AD_FXXTNS1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAX_EXTENS

Description: E-Mail Address
Field Name: E_MAIL
Data Element: AD_SMTPADR
Data Type: CHAR
length (Dec): 241(0)
Check table:
Conversion Routine: SXIDN
Domain Name: AD_SMTPADR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SXIDN

See all SAP tables containing field E_MAIL