SAP Table SOADDRESS

SAPoffice: Address of a SAPoffice user

SOADDRESS (SAPoffice: Address of a SAPoffice user) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SOADDRESS to other SAP tables.

SOADDRESS table fields

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

SOADDRESS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SOADDRESS CMPYADR SOADDRESS MANDT SADR Address Management: Company Data MANDT
SOADDRESS CMPYADR SOADDRESS CMPYADR SADR Address Management: Company Data ADRNR
SOADDRESS CMPYADR SOADDRESS NATIO SADR Address Management: Company Data NATIO
SOADDRESS MANDT SOADDRESS MANDT T000 Clients MANDT
SOADDRESS REFNR SOADDRESS REFNR SADRP Address Management: Personal Data ADRNR
SOADDRESS REFNR * SADRP Address Management: Personal Data NATIO
SOADDRESS REFNR SOADDRESS MANDT SADRP Address Management: Personal Data MANDT
SOADDRESS SPRAS SOADDRESS SPRAS T002 Language Keys (Component BC-I18) SPRAS