SOADDRESS SAP (SAPoffice: Address of a SAPoffice user) Structure details
Description: SAPoffice: Address of a SAPoffice user
Structure field list including key, data, relationships and ABAP select examples
SOADDRESS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "SAPoffice: Address of a SAPoffice user" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_SOADDRESS TYPE SOADDRESS.
The SOADDRESS table consists of various fields, each holding specific information or linking keys about SAPoffice: Address of a SAPoffice user data available in SAP. These include USERID (SAPoffice: User ID of an Office user), SAPNAME (SAP name of a SAPoffice user), OFFICENAME (SAPoffice user name), FULLNAME (Name in address management).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP SOADDRESS structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| USERID | SAPoffice: User ID of an Office user | SO_USR_ID | CHAR | 17 | SO_OBJ_ID | ||||
| SAPNAME | SAP name of a SAPoffice user | SO_SAP_NAM | CHAR | 12 | USERNAME | ||||
| OFFICENAME | SAPoffice user name | SO_USR_NAM | CHAR | 12 | USERNAME | ||||
| FULLNAME | Name in address management | SO_ADRNAM | CHAR | 35 | SO_STRI035 | ||||
| DELETED | SAPoffice: Office user was deleted | SO_USR_DEL | CHAR | 1 | SO_FLAG | ||||
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| ADRNR | Address | ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
| NATIO | International address version ID | INTER | CHAR | 1 | Assigned to domain | NATION | |||
| ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
| ABTEI | Addresses: Department | DEPTM | CHAR | 30 | TEXT30 | ||||
| COSTC | Addresses: Cost center | COST_CT | CHAR | 10 | TEXT10 | ||||
| ROOMN | Addresses: Room number | ROOM_NR | CHAR | 6 | TEXT6 | ||||
| BUILD | Addresses: Building number | BUIL_NR | CHAR | 6 | TEXT6 | ||||
| NAME1 | Name 1 | NAME1_BAS | CHAR | 35 | NAME | ||||
| NAME2 | Name 2 | NAME2_BAS | CHAR | 35 | NAME | ||||
| STDCOM | Addresses: Communication type | COM_ART | CHAR | 3 | COM_ART | ||||
| SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
| CHNAM | Addresses: Changed by | CH_NAM | CHAR | 12 | USERNAME | ||||
| CHDAT | Addresses: Change date | CH_DAT | DATS | 8 | DATUM | ||||
| CHTIM | Addresses: Changed at | CH_TIM | TIMS | 6 | UZEIT | ||||
| CRNAM | Addresses: Created by | CR_NAM | CHAR | 12 | USERNAME | ||||
| CRDAT | Addresses: Creation date | CR_DAT | DATS | 8 | DATUM | ||||
| CRTIM | Addresses: Creation time | CR_TIM | TIMS | 6 | UZEIT | ||||
| KLASSE | Addresses: class assigned to an address | SO_KLASSE | CHAR | 18 | KLASSE | ||||
| DBNAME | Addresses: System ID | SYM_DST | CHAR | 10 | CHAR10 | ||||
| CMPYADR | Addresses: Address Number | CADNR | CHAR | 10 | SADR | ALPHA | CADRNR | ||
| ANREK | Addresses: Form of address key | ANREK | CHAR | 2 | ANREK | ||||
| SORT1 | Sort field | SORTL_BAS | CHAR | 10 | CHAR10 | ||||
| SORT2 | Sort field | SORT20 | CHAR | 20 | CHAR20 | ||||
| FNAME | A person's first name (Addresses) | AD_FNAME | CHAR | 35 | TEXT35 | ||||
| UCFNAME | A person's first name in upper case (Addresses) | AD_UCFNAME | CHAR | 25 | CHAR25 | ||||
| LNAME | A person's last name (Addresses) | AD_LNAME | CHAR | 35 | TEXT35 | ||||
| UCLNAME | A person's last name (Addresses) | AD_UCLNAME | CHAR | 25 | CHAR25 | ||||
| UCABTEI | Department in upper case (Addresses) | AD_UCABTEI | CHAR | 25 | CHAR25 | ||||
| UCNAMECMPY | Company name in upper case (addresses) | AD_UCNAMCP | CHAR | 25 | CHAR25 | ||||
| USRTYPE | Flag: Person is internal SAP user | AD_USRTYPE | CHAR | 1 | XFELD | ||||
| REFNR | Address reference for alias names | ADRNR_REF | CHAR | 10 | SADRP | ALPHA | ADRNR |
| Key field | Non-key field |
How do I retrieve data from SAP structure SOADDRESS using ABAP code?
As SOADDRESS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SOADDRESS as there is no data to select.How to access SAP table SOADDRESS
Within an ECC or HANA version of SAP you can also view further information about SOADDRESS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects