SAP ABAP Table SADRP (Address Management: Personal Data)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-ADR (Application Component) Address Management/Business Address
     ⤷ SZA1 (Package) Exceptions to Package SZA (Repository Switch)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SADRP	Table Relationship Diagram
Short Description	Address Management: Personal Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ADRNR	☑	ADRNR	ADRNR	CHAR	10	0	Address	*
3	NATIO	☑	INTER	NATION	CHAR	1	0	International address version ID	*
4	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
5	ABTEI	☐	DEPTM	TEXT30	CHAR	30	0	Addresses: Department
6	COSTC	☐	COST_CT	TEXT10	CHAR	10	0	Addresses: Cost center
7	ROOMN	☐	ROOM_NR	TEXT6	CHAR	6	0	Addresses: Room number
8	BUILD	☐	BUIL_NR	TEXT6	CHAR	6	0	Addresses: Building number
9	NAME1	☐	NAME1_BAS	NAME	CHAR	35	0	Name 1
10	NAME2	☐	NAME2_BAS	NAME	CHAR	35	0	Name 2
11	STDCOM	☐	COM_ART	COM_ART	CHAR	3	0	Addresses: Communication type
12	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
13	CHNAM	☐	CH_NAM	USERNAME	CHAR	12	0	Addresses: Changed by
14	CHDAT	☐	CH_DAT	DATUM	DATS	8	0	Addresses: Change date
15	CHTIM	☐	CH_TIM	UZEIT	TIMS	6	0	Addresses: Changed at
16	CRNAM	☐	CR_NAM	USERNAME	CHAR	12	0	Addresses: Created by
17	CRDAT	☐	CR_DAT	DATUM	DATS	8	0	Addresses: Creation date
18	CRTIM	☐	CR_TIM	UZEIT	TIMS	6	0	Addresses: Creation time
19	KLASSE	☐	SO_KLASSE	KLASSE	CHAR	18	0	Addresses: class assigned to an address
20	DBNAME	☐	SYM_DST	CHAR10	CHAR	10	0	Addresses: System ID
21	CMPYADR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	SADR
22	ANREK	☐	ANREK	ANREK	CHAR	2	0	Addresses: Form of address key
23	SORT1	☐	SORTL_BAS	CHAR10	CHAR	10	0	Sort field
24	SORT2	☐	SORT20	CHAR20	CHAR	20	0	Sort field
25	FNAME	☐	AD_FNAME	TEXT35	CHAR	35	0	A person's first name (Addresses)
26	UCFNAME	☐	AD_UCFNAME	CHAR25	CHAR	25	0	A person's first name in upper case (Addresses)
27	LNAME	☐	AD_LNAME	TEXT35	CHAR	35	0	A person's last name (Addresses)
28	UCLNAME	☐	AD_UCLNAME	CHAR25	CHAR	25	0	A person's last name (Addresses)
29	UCABTEI	☐	AD_UCABTEI	CHAR25	CHAR	25	0	Department in upper case (Addresses)
30	UCNAMECMPY	☐	AD_UCNAMCP	CHAR25	CHAR	25	0	Company name in upper case (addresses)
31	USRTYPE	☐	AD_USRTYPE	XFELD	CHAR	1	0	Flag: Person is internal SAP user
32	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	SADRP	CMPYADR	SADR	ADRNR	KEY	1	CN
2	SADRP	MANDT	T000	MANDT	KEY	1	CN
3	SADRP	REFNR	SADRP	ADRNR
4	SADRP	SPRAS	T002	SPRAS	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in