SAP table reference
SADRP
Address Management: Personal DataExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table SADRP.
SAP table SADRP has 3 primary key fields: MANDT,ADRNR,NATIO.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
SADRP fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key ADRNR | Address | CHAR | 10 | 0 | * | ADRNR | |
| Key NATIO | International address version ID | CHAR | 1 | 0 | * | INTER | |
| ANRED | Title | CHAR | 15 | 0 | ANRED | ||
| ABTEI | Addresses: Department | CHAR | 30 | 0 | DEPTM | ||
| COSTC | Addresses: Cost center | CHAR | 10 | 0 | COST_CT | ||
| ROOMN | Addresses: Room number | CHAR | 6 | 0 | ROOM_NR | ||
| BUILD | Addresses: Building number | CHAR | 6 | 0 | BUIL_NR | ||
| NAME1 | Name 1 | CHAR | 35 | 0 | NAME1_BAS | ||
| NAME2 | Name 2 | CHAR | 35 | 0 | NAME2_BAS | ||
| STDCOM | Addresses: Communication type | CHAR | 3 | 0 | COM_ART | ||
| SPRAS | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| CHNAM | Addresses: Changed by | CHAR | 12 | 0 | CH_NAM | ||
| CHDAT | Addresses: Change date | DATS | 8 | 0 | CH_DAT | ||
| CHTIM | Addresses: Changed at | TIMS | 6 | 0 | CH_TIM | ||
| CRNAM | Addresses: Created by | CHAR | 12 | 0 | CR_NAM | ||
| CRDAT | Addresses: Creation date | DATS | 8 | 0 | CR_DAT | ||
| CRTIM | Addresses: Creation time | TIMS | 6 | 0 | CR_TIM | ||
| KLASSE | Addresses: class assigned to an address | CHAR | 18 | 0 | SO_KLASSE | ||
| DBNAME | Addresses: System ID | CHAR | 10 | 0 | SYM_DST | ||
| CMPYADR | Addresses: Address Number | CHAR | 10 | 0 | SADR | CADNR | |
| ANREK | Addresses: Form of address key | CHAR | 2 | 0 | ANREK | ||
| SORT1 | Sort field | CHAR | 10 | 0 | SORTL_BAS | ||
| SORT2 | Sort field | CHAR | 20 | 0 | SORT20 | ||
| FNAME | A person's first name (Addresses) | CHAR | 35 | 0 | AD_FNAME | ||
| UCFNAME | A person's first name in uppercase (Addresses) | CHAR | 25 | 0 | AD_UCFNAME | ||
| LNAME | A person's last name (Addresses) | CHAR | 35 | 0 | AD_LNAME | ||
| UCLNAME | A person's last name (Addresses) | CHAR | 25 | 0 | AD_UCLNAME | ||
| UCABTEI | Department in Uppercase (Addresses) | CHAR | 25 | 0 | AD_UCABTEI | ||
| UCNAMECMPY | Company Name in Uppercase (Addresses) | CHAR | 25 | 0 | AD_UCNAMCP | ||
| USRTYPE | Flag: Person is internal SAP user | CHAR | 1 | 0 | AD_USRTYPE | ||
| REFNR | Address reference for alias names | CHAR | 10 | 0 | SADRP | ADRNR_REF |
/ Relationships
SADRP relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| SADRP | CMPYADR | SADR | Address Management: Company Data | MANDT |
| SADRP | CMPYADR | SADR | Address Management: Company Data | NATIO |
| SADRP | REFNR | SADRP | Address Management: Personal Data | MANDT |
| SADRP | REFNR | SADRP | Address Management: Personal Data | ADRNR |
| SADRP | REFNR | SADRP | Address Management: Personal Data | NATIO |
| SADRP | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |