SAP ABAP Table SOADDRESS (SAPoffice: Address of a SAPoffice user)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-COM (Application Component) Communication Services: Mail, Fax, SMS, Telephony
     ⤷ SO (Package) SAPoffice

Basic Data

Table Category	INTTAB	Structure
Structure	SOADDRESS	Table Relationship Diagram
Short Description	SAPoffice: Address of a SAPoffice user

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	SAPoffice: SAP Name and SAPoffice Name of a User
2	.INCLUDE	☐				0	0	SAPoffice: SAP Name and SAPoffice Name of a User
3	USERID	☐	SO_USR_ID	SO_OBJ_ID	CHAR	17	0	SAPoffice: User ID of an Office user
4	SAPNAME	☐	SO_SAP_NAM	USERNAME	CHAR	12	0	SAP name of a SAPoffice user
5	OFFICENAME	☐	SO_USR_NAM	USERNAME	CHAR	12	0	SAPoffice user name
6	FULLNAME	☐	SO_ADRNAM	SO_STRI035	CHAR	35	0	Name in address management
7	DELETED	☐	SO_USR_DEL	SO_FLAG	CHAR	1	0	SAPoffice: Office user was deleted
8	.INCLUDE	☐				0	0	Address Management: Personal Data
9	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
10	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
11	NATIO	☐	INTER	NATION	CHAR	1	0	International address version ID	*
12	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
13	ABTEI	☐	DEPTM	TEXT30	CHAR	30	0	Addresses: Department
14	COSTC	☐	COST_CT	TEXT10	CHAR	10	0	Addresses: Cost center
15	ROOMN	☐	ROOM_NR	TEXT6	CHAR	6	0	Addresses: Room number
16	BUILD	☐	BUIL_NR	TEXT6	CHAR	6	0	Addresses: Building number
17	NAME1	☐	NAME1_BAS	NAME	CHAR	35	0	Name 1
18	NAME2	☐	NAME2_BAS	NAME	CHAR	35	0	Name 2
19	STDCOM	☐	COM_ART	COM_ART	CHAR	3	0	Addresses: Communication type
20	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
21	CHNAM	☐	CH_NAM	USERNAME	CHAR	12	0	Addresses: Changed by
22	CHDAT	☐	CH_DAT	DATUM	DATS	8	0	Addresses: Change date
23	CHTIM	☐	CH_TIM	UZEIT	TIMS	6	0	Addresses: Changed at
24	CRNAM	☐	CR_NAM	USERNAME	CHAR	12	0	Addresses: Created by
25	CRDAT	☐	CR_DAT	DATUM	DATS	8	0	Addresses: Creation date
26	CRTIM	☐	CR_TIM	UZEIT	TIMS	6	0	Addresses: Creation time
27	KLASSE	☐	SO_KLASSE	KLASSE	CHAR	18	0	Addresses: class assigned to an address
28	DBNAME	☐	SYM_DST	CHAR10	CHAR	10	0	Addresses: System ID
29	CMPYADR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	SADR
30	ANREK	☐	ANREK	ANREK	CHAR	2	0	Addresses: Form of address key
31	SORT1	☐	SORTL_BAS	CHAR10	CHAR	10	0	Sort field
32	SORT2	☐	SORT20	CHAR20	CHAR	20	0	Sort field
33	FNAME	☐	AD_FNAME	TEXT35	CHAR	35	0	A person's first name (Addresses)
34	UCFNAME	☐	AD_UCFNAME	CHAR25	CHAR	25	0	A person's first name in upper case (Addresses)
35	LNAME	☐	AD_LNAME	TEXT35	CHAR	35	0	A person's last name (Addresses)
36	UCLNAME	☐	AD_UCLNAME	CHAR25	CHAR	25	0	A person's last name (Addresses)
37	UCABTEI	☐	AD_UCABTEI	CHAR25	CHAR	25	0	Department in upper case (Addresses)
38	UCNAMECMPY	☐	AD_UCNAMCP	CHAR25	CHAR	25	0	Company name in upper case (addresses)
39	USRTYPE	☐	AD_USRTYPE	XFELD	CHAR	1	0	Flag: Person is internal SAP user
40	REFNR	☐	ADRNR_REF	ADRNR	CHAR	10	0	Address reference for alias names	SADRP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SOADDRESS	CMPYADR	SADR	ADRNR	KEY	1	CN
2	SOADDRESS	MANDT	T000	MANDT	KEY	1	CN
3	SOADDRESS	REFNR	SADRP	ADRNR
4	SOADDRESS	SPRAS	T002	SPRAS	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in