1. Home
  2. Resources
  3. SAP Tables
  4. SADRP - Address Management: Personal Data

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
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
X Yes
NULL No
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 REFNR SADRP Address Management: Personal Data ADRNR
SADRP REFNR * SADRP Address Management: Personal Data NATIO
SADRP REFNR SADRP MANDT SADRP Address Management: Personal Data MANDT
SADRP SPRAS SADRP SPRAS T002 Language Keys (Component BC-I18) SPRAS