1. Home
  2. Resources
  3. SAP Tables
  4. SADR - Address Management: Company Data

SAP Table SADR

Address Management: Company Data

SADR (Address Management: Company 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 SADR to other SAP tables.

SADR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
ADRNR Addresses: Address Number CADNR CHAR 10 0
NATIO International address version ID INTER CHAR 1 0
ANRED Title ANRED CHAR 15 0
NAME1 Name 1 NAME1_BAS CHAR 35 0
NAME2 Name 2 NAME2_BAS CHAR 35 0
NAME3 Name 3 NAME3_BAS CHAR 35 0
NAME4 Name 4 NAME4_BAS CHAR 35 0
PSTLZ Postal code PSTLZ_BAS CHAR 10 0
ORT01 City ORT01_GP CHAR 35 0
ORT02 District ORT02_BAS CHAR 35 0
PSTL2 PO Box postal code PSTL2_BAS CHAR 10 0
PFACH PO box PFACH_BAS CHAR 10 0
STRAS House number and street STRAS_GP CHAR 35 0
STRS2 House number and street STRAS_GP CHAR 35 0
HAUSN House number HAUSN_BAS CHAR 6 0
STOCK Floor STOCK CHAR 6 0
LAND1 Country Key LAND1 T005 CHAR 3 0
SORTL Sort field SORTL_BAS CHAR 10 0
SORT2 Sort field SORT20 CHAR 20 0
SPRAS Language Key SPRAS T002 LANG 1 0
LZONE Transportation zone to or from which the goods are delivered LZONE TZONE CHAR 10 0
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
PSTBZ Post delivery district PSTBZ CHAR 15 0
TELF1 Addresses: telephone no. TLFNR CHAR 30 0
FLAG Checkbox XFELD CHAR 1 0
X Yes
NULL No
TELFX Fax number TELFX_BAS CHAR 31 0
FLAG2 Checkbox XFELD CHAR 1 0
X Yes
NULL No
TELTX Teletex number TELTX CHAR 30 0
FLAG3 Checkbox XFELD CHAR 1 0
X Yes
NULL No
TELX1 Telex number TELX1 CHAR 30 0
FLAG4 Checkbox XFELD CHAR 1 0
X Yes
NULL No
MAIAD Checkbox XFELD CHAR 1 0
X Yes
NULL No
MAILN Addresses: Document name OBJ_NAM CHAR 12 0
STDKO Default communications service STDKO_D CHAR 1 0
STDCOM Addresses: Communication type COM_ART CHAR 3 0
DBNAME Addresses: System ID SYM_DST CHAR 10 0
KLASSE Addresses: class assigned to an address SO_KLASSE CHAR 18 0
ANREK Addresses: Form of address key ANREK CHAR 2 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
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
DUEFL Status of data transfer into subsequent release DUEFL_BAS CHAR 1 0
NULL Not transferred yet
A Transferred, data subsequently changed
X Transferred, data unchanged
TXJCD Tax Jurisdiction AD_TXJCD CHAR 15 0
PFORT PO Box city PFORT_ADRS CHAR 40 0
TZONE Time Zone TZNZONE TTZZ CHAR 6 0
COUNTY_CODE County code for county AD_CNTYNUM CHAR 8 0
COUNTY County AD_COUNTY CHAR 40 0
TOWNSHIP_CODE Township code for Township AD_TWSHPNUM CHAR 8 0
TOWNSHIP Township AD_TOWNSHIP CHAR 40 0

SADR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SADR LAND1 SADR MANDT T005 Countries MANDT
SADR LAND1 SADR LAND1 T005 Countries LAND1
SADR LZONE SADR LZONE TZONE Customers: Regional zones ZONE1
SADR LZONE SADR MANDT TZONE Customers: Regional zones MANDT
SADR LZONE SADR LAND1 TZONE Customers: Regional zones LAND1
SADR MANDT SADR MANDT T000 Clients MANDT
SADR REGIO SADR REGIO T005S Taxes: Region (Province) Key BLAND
SADR REGIO SADR MANDT T005S Taxes: Region (Province) Key MANDT
SADR REGIO SADR LAND1 T005S Taxes: Region (Province) Key LAND1
SADR SPRAS SADR SPRAS T002 Language Keys (Component BC-I18) SPRAS
SADR TZONE SADR MANDT TTZZ Time zones CLIENT
SADR TZONE SADR TZONE TTZZ Time zones TZONE