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.
Source: SADRP (Address Management: Personal Data)
SADRP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||
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 |
