- Home
- Resources
- SAP Tables
- SOADDRESS - SAPoffice: Address of a SAPoffice user
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.
Source: SOADDRESS (SAPoffice: Address of a SAPoffice user)
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 |
Possible values
| 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 |
Possible values
|
| 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 |
MANDT |
SADRP |
Address Management: Personal Data |
MANDT |
| SOADDRESS |
REFNR |
SOADDRESS |
REFNR |
SADRP |
Address Management: Personal Data |
ADRNR |
| SOADDRESS |
REFNR |
* |
|
SADRP |
Address Management: Personal Data |
NATIO |
| SOADDRESS |
SPRAS |
SOADDRESS |
SPRAS |
T002 |
Language Keys (Component BC-I18) |
SPRAS |
