SAP table SOADDRESS (SAPoffice: Address of a SAPoffice user)

Field Description Data Type Length Decimals Checktable Data Element
USERID SAPoffice: User ID of an Office user CHAR 17 0 SO_USR_ID
SAPNAME SAP name of a SAPoffice user CHAR 12 0 SO_SAP_NAM
OFFICENAME SAPoffice user name CHAR 12 0 SO_USR_NAM
FULLNAME Name in address management CHAR 35 0 SO_ADRNAM
DELETED SAPoffice: Office user was deleted CHAR 1 0 SO_USR_DEL
MANDT Client CLNT 3 0 T000 MANDT
ADRNR Address CHAR 10 0 * ADRNR
NATIO International address version ID CHAR 1 0 * INTER
ANRED Title CHAR 15 0 ANRED
ABTEI Addresses: Department CHAR 30 0 DEPTM
COSTC Addresses: Cost center CHAR 10 0 COST_CT
ROOMN Addresses: Room number CHAR 6 0 ROOM_NR
BUILD Addresses: Building number CHAR 6 0 BUIL_NR
NAME1 Name 1 CHAR 35 0 NAME1_BAS
NAME2 Name 2 CHAR 35 0 NAME2_BAS
STDCOM Addresses: Communication type CHAR 3 0 COM_ART
SPRAS Language Key LANG 1 0 T002 SPRAS
CHNAM Addresses: Changed by CHAR 12 0 CH_NAM
CHDAT Addresses: Change date DATS 8 0 CH_DAT
CHTIM Addresses: Changed at TIMS 6 0 CH_TIM
CRNAM Addresses: Created by CHAR 12 0 CR_NAM
CRDAT Addresses: Creation date DATS 8 0 CR_DAT
CRTIM Addresses: Creation time TIMS 6 0 CR_TIM
KLASSE Addresses: class assigned to an address CHAR 18 0 SO_KLASSE
DBNAME Addresses: System ID CHAR 10 0 SYM_DST
CMPYADR Addresses: Address Number CHAR 10 0 SADR CADNR
ANREK Addresses: Form of address key CHAR 2 0 ANREK
SORT1 Sort field CHAR 10 0 SORTL_BAS
SORT2 Sort field CHAR 20 0 SORT20
FNAME A person's first name (Addresses) CHAR 35 0 AD_FNAME
UCFNAME A person's first name in uppercase (Addresses) CHAR 25 0 AD_UCFNAME
LNAME A person's last name (Addresses) CHAR 35 0 AD_LNAME
UCLNAME A person's last name (Addresses) CHAR 25 0 AD_UCLNAME
UCABTEI Department in Uppercase (Addresses) CHAR 25 0 AD_UCABTEI
UCNAMECMPY Company Name in Uppercase (Addresses) CHAR 25 0 AD_UCNAMCP
USRTYPE Flag: Person is internal SAP user CHAR 1 0 AD_USRTYPE
REFNR Address reference for alias names CHAR 10 0 SADRP ADRNR_REF

SOADDRESS foreign key relationships

Table Field Check Table Check Field
0 SOADDRESS CMPYADR SADR Address Management: Company Data MANDT
0 SOADDRESS CMPYADR SADR Address Management: Company Data NATIO
1 SOADDRESS REFNR SADRP Address Management: Personal Data MANDT
1 SOADDRESS REFNR SADRP Address Management: Personal Data ADRNR
1 SOADDRESS REFNR SADRP Address Management: Personal Data NATIO