SAP TABLES | Basis Components | Basis Services / Communication Interfaces | Address Management/Business Address(BC-SRV-ADR) SAP BC
SADR SAP Address Management: Company Data Table and data
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.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP SADR Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: A - Application table containing master and transaction data
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type)
See here for more information about this and other SAP enhancement categories
==>View Table relationships
SAP SADR Table fields within data Dictionary
| Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
| MANDT | MANDT | CLNT | 3 | T000 | Client | |
| ADRNR | CADNR | CHAR | 10 | Addresses: Address Number | ALPHA | |
| NATIO | INTER | CHAR | 1 |
* | International address version ID | |
| ANRED | ANRED | CHAR | 15 | Title | ||
| NAME1 | NAME1_BAS | CHAR | 35 | Name 1 | ||
| NAME2 | NAME2_BAS | CHAR | 35 | Name 2 | ||
| NAME3 | NAME3_BAS | CHAR | 35 | Name 3 | ||
| NAME4 | NAME4_BAS | CHAR | 35 | Name 4 | ||
| PSTLZ | PSTLZ_BAS | CHAR | 10 | Postal code | ||
| ORT01 | ORT01_GP | CHAR | 35 | City | ||
| ORT02 | ORT02_BAS | CHAR | 35 | District | ||
| PSTL2 | PSTL2_BAS | CHAR | 10 | PO Box postal code | ||
| PFACH | PFACH_BAS | CHAR | 10 | PO box | ||
| STRAS | STRAS_GP | CHAR | 35 | House number and street | ||
| STRS2 | STRAS_GP | CHAR | 35 | House number and street | ||
| HAUSN | HAUSN_BAS | CHAR | 6 | House number | ||
| STOCK | STOCK | CHAR | 6 | Floor | ||
| LAND1 | LAND1 | CHAR | 3 | T005 | Country Key | |
| SORTL | SORTL_BAS | CHAR | 10 | Sort field | ||
| SORT2 | SORT20 | CHAR | 20 | Sort field | ||
| SPRAS | SPRAS | LANG | 1 | T002 | Language Key | ISOLA |
| LZONE | LZONE | CHAR | 10 | TZONE | Transportation zone to or from which the goods are delivered | |
| PSTBZ | PSTBZ | CHAR | 15 | Post delivery district | ||
| TELF1 | TLFNR | CHAR | 30 | Addresses: telephone no. | ||
| FLAG | XFELD | CHAR | 1 | Checkbox | ||
| TELFX | TELFX_BAS | CHAR | 31 | Fax number | ||
| FLAG2 | XFELD | CHAR | 1 | Checkbox | ||
| TELTX | TELTX | CHAR | 30 | Teletex number | ||
| FLAG3 | XFELD | CHAR | 1 | Checkbox | ||
| TELX1 | TELX1 | CHAR | 30 | Telex number | ||
| FLAG4 | XFELD | CHAR | 1 | Checkbox | ||
| MAIAD | XFELD | CHAR | 1 | Checkbox | ||
| MAILN | OBJ_NAM | CHAR | 12 | Addresses: Document name | ||
| STDKO | STDKO_D | CHAR | 1 | Default communications service | ||
| STDCOM | COM_ART | CHAR | 3 | Addresses: Communication type | ||
| DBNAME | SYM_DST | CHAR | 10 | Addresses: System ID | ||
| KLASSE | SO_KLASSE | CHAR | 18 | Addresses: class assigned to an address | ||
| ANREK | ANREK | CHAR | 2 | Addresses: Form of address key | ||
| CRNAM | CR_NAM | CHAR | 12 | Addresses: Created by | ||
| CRDAT | CR_DAT | DATS | 8 | Addresses: Creation date | ||
| CRTIM | CR_TIM | TIMS | 6 | Addresses: Creation time | ||
| CHNAM | CH_NAM | CHAR | 12 | Addresses: Changed by | ||
| CHDAT | CH_DAT | DATS | 8 | Addresses: Change date | ||
| CHTIM | CH_TIM | TIMS | 6 | Addresses: Changed at | ||
| DUEFL | DUEFL_BAS | CHAR | 1 | Status of data transfer into subsequent release | ||
| TXJCD | AD_TXJCD | CHAR | 15 | Tax Jurisdiction | ||
| PFORT | PFORT_ADRS | CHAR | 40 | PO Box city | ||
| TZONE | TZNZONE | CHAR | 6 | TTZZ | Time Zone | |
| COUNTY_CODE | AD_CNTYNUM | CHAR | 8 |
* | County code for county | ALPHA |
| COUNTY | AD_COUNTY | CHAR | 40 | County | ||
| TOWNSHIP_CODE | AD_TWSHPNUM | CHAR | 8 |
* | Township code for Township | ALPHA |
| TOWNSHIP | AD_TOWNSHIP | CHAR | 40 | Township | ||
| Key field | |
| Non-key field |
SADR relationships with other tables
ADMIX-Help structure for reading via ADK in LDB(SD)
VBUK-Sales Doc.: Header Status and Administrative Data
VBAK-Sales Document: Header Data
VBFA-Sales Document Flow
NAST-Message status
VBKD-Sales Document: Business Data
VBUP-Sales Document: Item Status
VBAP-Sales Document: Item Data
VBEP-Sales Document: Schedule Line Data
KONV-Conditions (Transaction Data)
VBPA-Sales Document: Partner
SADR-Address Management: Company data
VBUV-Sales Document: Incompletion Log
STXH-STXD SAPscript text file header
STXL-STXD SAPscript text file lines
CDHDR-Change document header
CDPOS-Change document items
VBUK-Sales Document: Header Status and Admin. Data
VBKA-Sales activities
NAST-Message status
VBFA-Sales Document Flow
VBPA-Sales Document: Partner
SADR-Address Management: Company data
STXH-STXD SAPscript text file header
STXL-STXD SAPscript text file lines
VBUV-Sales Document: Incompletion Log
ADMIX-Help structure for reading via ADK in LDB(SD)
VBUK-Sales Document: Header Status and Admin. Data
LIKP-SD Document: Delivery Header Data
VBFA-Sales Document Flow
NAST-Message status
VBUP-Sales Document: Item Status
LIPS-SD document: Delivery: Item data
VBPA-Sales Document: Partner
SADR-Address Management: Company data
VBSSSK-Table Generated for View VBSSSK
EIKP-Foreign Trade: Export/Import Header Data
EIPO-Foreign Trade: Export/Import: Item Data
VEKP-SD Document: Shipping Unit Header
VEPO-SD Document: Shipping Unit Item (Content)
STXH-STXD SAPscript text file header
STXL-STXD SAPscript text file lines
ADMIX-Help structure for reading via ADK in LDB(SD)
VBUK-Sales Document: Header Status and Admin. Data
VBRK-Billing Document: Header Data
NAST-Message status
VBFA-Sales Document Flow
VBRP-Billing Document: Item Data
KONV-Conditions (Transaction Data)
VBPA-Sales Document: Partner
SADR-Address Management: Company data
VBSSSK-Table Generated for View VBSSSK
EIKP-Foreign Trade: Export/Import Header Data
EIPO-Foreign Trade: Export/Import: Item Data
STXH-STXD SAPscript text file header
STXL-STXD SAPscript text file lines
VBRL-Sales Document: Invoice List
SADR - Address Management: Company Data SADO_MOD_FLAGSTRING - Indicator Bar: Modifications to Sales Document Processing SADO_BUF_FLAGSTRING - Indicator Bar: Buffered Reading Sales Document SADOC_KW_TAB_S - Tab in Document Attribute Dialog SADOC_DGSIGNCHG - Display Structure for Digital Signature Change Attribute SADOCVAL - Attribute Values with Text