SAP Table SADR stores Address Management: Company Datadata

  

In this post, I will try and describe everything you need to know about the SAP sadr table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for SADR what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from SADR....Right lets get started!


SAP SADR dictionary attributes

Object Name: SADR
Dictionary Type: Transparent table
Description: Address Management: Company Data


SADR field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
ADRNRCADNRCHAR10(0) Addresses: Address NumberCADRNR
NATIOINTERCHAR1(0) *International address version IDNATIONSAP
ANREDANREDCHAR15(0) TitleTEXT15VP
NAME1NAME1_BASCHAR35(0) Name 1NAMEVP
NAME2NAME2_BASCHAR35(0) Name 2NAMEVP
NAME3NAME3_BASCHAR35(0) Name 3NAMEVP
NAME4NAME4_BASCHAR35(0) Name 4NAMEVP
PSTLZPSTLZ_BASCHAR10(0) Postal codePSTLZFB
ORT01ORT01_GPCHAR35(0) CityTEXT35FB
ORT02ORT02_BASCHAR35(0) DistrictTEXT35SAP
PSTL2PSTL2_BASCHAR10(0) PO Box postal codePSTLZFB
PFACHPFACH_BASCHAR10(0) PO boxPFACHMG
STRASSTRAS_GPCHAR35(0) House number and streetTEXT35FB
STRS2STRAS_GPCHAR35(0) House number and streetTEXT35FB
HAUSNHAUSN_BASCHAR6(0) House numberCHAR6
STOCKSTOCKCHAR6(0) FloorSTOCKSAP
LAND1LAND1CHAR3(0) T005Country KeyLAND1LNDFB
SORTLSORTL_BASCHAR10(0) Sort fieldCHAR10FB
SORT2SORT20CHAR20(0) Sort fieldCHAR20
SPRASSPRASLANG1(0) T002Language KeySPRASSPRSAPH_T002SPRAS
LZONELZONECHAR10(0) TZONETransportation zone to or from which the goods are deliveredZONEVV
REGIOREGIOCHAR3(0) T005SSTATE (State, Province, County)REGIOFB
PSTBZPSTBZCHAR15(0) Post delivery districtPSTBZSAP
TELF1TLFNRCHAR30(0) Addresses: telephone no.TEXT30
FLAGXFELDCHAR1(0) CheckboxXFELDFB
TELFXTELFX_BASCHAR31(0) Fax numberTEXT31FB
FLAG2XFELDCHAR1(0) CheckboxXFELDFB
TELTXTELTXCHAR30(0) Teletex numberTEXT30FB
FLAG3XFELDCHAR1(0) CheckboxXFELDFB
TELX1TELX1CHAR30(0) Telex numberTEXT30FB
FLAG4XFELDCHAR1(0) CheckboxXFELDFB
MAIADXFELDCHAR1(0) CheckboxXFELDFB
MAILNOBJ_NAMCHAR12(0) Addresses: Document nameDOC_NAM
STDKOSTDKO_DCHAR1(0) Default communications serviceCHAR1SAP
STDCOMCOM_ARTCHAR3(0) Addresses: Communication typeCOM_ART
DBNAMESYM_DSTCHAR10(0) Addresses: System IDCHAR10
KLASSESO_KLASSECHAR18(0) Addresses: class assigned to an addressKLASSE
ANREKANREKCHAR2(0) Addresses: Form of address keyANREK
CRNAMCR_NAMCHAR12(0) Addresses: Created byUSERNAME
CRDATCR_DATDATS8(0) Addresses: Creation dateDATUM
CRTIMCR_TIMTIMS6(0) Addresses: Creation timeUZEIT
CHNAMCH_NAMCHAR12(0) Addresses: Changed byUSERNAME
CHDATCH_DATDATS8(0) Addresses: Change dateDATUM
CHTIMCH_TIMTIMS6(0) Addresses: Changed atUZEIT
DUEFLDUEFL_BASCHAR1(0) Status of data transfer into subsequent releaseDUEFL_BAS
TXJCDAD_TXJCDCHAR15(0) Tax JurisdictionAD_TXJCDTXJ
PFORTPFORT_ADRSCHAR40(0) PO Box cityTEXT40
TZONETZNZONECHAR6(0) TTZZTime ZoneTZNZONE
COUNTY_CODEAD_CNTYNUMCHAR8(0) *County code for countyCNTY_CODE
COUNTYAD_COUNTYCHAR40(0) CountyTEXT40CLTCNTYNAMECOUNTY
TOWNSHIP_CODEAD_TWSHPNUMCHAR8(0) *Township code for TownshipTWSHP_CODE
TOWNSHIPAD_TOWNSHIPCHAR40(0) TownshipTEXT40CLTWSHPNAMETOWNSHIP