SAP Table SADRP
Address Management: Personal Data
SADRP (Address Management: Personal Data) 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 SADRP to other SAP tables.
SADRP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
REFNR
Address reference for alias names
|
ADRNR_REF | SADRP |
CHAR
|
10 | 0 | |||||||
SADRP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| SADRP | CMPYADR | SADRP | MANDT |
SADR
Address Management: Company Data
|
MANDT |
| SADRP | CMPYADR | SADRP | CMPYADR |
SADR
Address Management: Company Data
|
ADRNR |
| SADRP | CMPYADR | SADRP | NATIO |
SADR
Address Management: Company Data
|
NATIO |
| SADRP | MANDT | SADRP | MANDT |
T000
Clients
|
MANDT |
| SADRP | REFNR | SADRP | MANDT |
SADRP
Address Management: Personal Data
|
MANDT |
| SADRP | REFNR | SADRP | REFNR |
SADRP
Address Management: Personal Data
|
ADRNR |
| SADRP | REFNR | * |
SADRP
Address Management: Personal Data
|
NATIO | |
| SADRP | SPRAS | SADRP | SPRAS |
T002
Language Keys (Component BC-I18)
|
SPRAS |