SADR SAP (Address Management: Company Data) Table details

Dictionary Type: Table
Description: Address Management: Company Data




ABAP Code to SELECT data from SADR
Related tables to SADR
Access table SADR




Table field list including key, data, relationships and ABAP select examples

SADR is a standard SAP Table which is used to store Address Management: Company Data data and is available within R/3 SAP systems depending on the version and release level.

The SADR table consists of various fields, each holding specific information or linking keys about Address Management: Company Data data available in SAP. These include ADRNR (Addresses: Address Number), NATIO (International address version ID), ANRED (Title), NAME1 (Name 1).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP SADR table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
ADRNRAddresses: Address Number CADNRCHAR10ALPHACADRNR
NATIOInternational address version ID INTERCHAR1Assigned to domainNATION
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 NAME1_BASCHAR35NAME
NAME2Name 2 NAME2_BASCHAR35NAME
NAME3Name 3 NAME3_BASCHAR35NAME
NAME4Name 4 NAME4_BASCHAR35NAME
PSTLZPostal code PSTLZ_BASCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
ORT02District ORT02_BASCHAR35TEXT35
PSTL2PO Box postal code PSTL2_BASCHAR10PSTLZ
PFACHPO box PFACH_BASCHAR10PFACH
STRASHouse number and street STRAS_GPCHAR35TEXT35
STRS2House number and street STRAS_GPCHAR35TEXT35
HAUSNHouse number HAUSN_BASCHAR6CHAR6
STOCKFloor STOCKCHAR6STOCK
LAND1Country Key LAND1CHAR3T005LAND1LND
SORTLSort field SORTL_BASCHAR10CHAR10
SORT2Sort field SORT20CHAR20CHAR20
SPRASLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
LZONETransportation zone to or from which the goods are delivered LZONECHAR10TZONEZONE
REGIOSTATE (State, Province, County) REGIOCHAR3T005SREGIO
PSTBZPost delivery district PSTBZCHAR15PSTBZ
TELF1Addresses: telephone no. TLFNRCHAR30TEXT30
FLAGCheckbox XFELDCHAR1XFELD
TELFXFax number TELFX_BASCHAR31TEXT31
FLAG2Checkbox XFELDCHAR1XFELD
TELTXTeletex number TELTXCHAR30TEXT30
FLAG3Checkbox XFELDCHAR1XFELD
TELX1Telex number TELX1CHAR30TEXT30
FLAG4Checkbox XFELDCHAR1XFELD
MAIADCheckbox XFELDCHAR1XFELD
MAILNAddresses: Document name OBJ_NAMCHAR12DOC_NAM
STDKODefault communications service STDKO_DCHAR1CHAR1
STDCOMAddresses: Communication type COM_ARTCHAR3COM_ART
DBNAMEAddresses: System ID SYM_DSTCHAR10CHAR10
KLASSEAddresses: class assigned to an address SO_KLASSECHAR18KLASSE
ANREKAddresses: Form of address key ANREKCHAR2ANREK
CRNAMAddresses: Created by CR_NAMCHAR12USERNAME
CRDATAddresses: Creation date CR_DATDATS8DATUM
CRTIMAddresses: Creation time CR_TIMTIMS6UZEIT
CHNAMAddresses: Changed by CH_NAMCHAR12USERNAME
CHDATAddresses: Change date CH_DATDATS8DATUM
CHTIMAddresses: Changed at CH_TIMTIMS6UZEIT
DUEFLStatus of data transfer into subsequent release DUEFL_BASCHAR1DUEFL_BAS
TXJCDTax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
PFORTPO Box city PFORT_ADRSCHAR40TEXT40
TZONETime Zone TZNZONECHAR6TTZZTZNZONE
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8Assigned to domainALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8Assigned to domainALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME

Key field Non-key field



How do I retrieve data from SAP table SADR using ABAP code

The following ABAP code Example will allow you to do a basic selection on SADR to SELECT all data from the table
DATA: WA_SADR TYPE SADR.

SELECT SINGLE *
FROM SADR
INTO CORRESPONDING FIELDS OF WA_SADR
WHERE...

How to access SAP table SADR

Within an ECC or HANA version of SAP you can also view further information about SADR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!