SAP Address Management/Business Address Tables
Are you looking for the right table related to SAP Address Management/Business Address Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Address Management/Business Address (BC-SRV-ADR) module.
Top 10 tables in Address Management/Business Address
| Table | Description |
|---|---|
| ADRCS | Shadow Table: Addresses (Business Address Services) |
| TSADOBJ | Assignments of BOR object types to address reference types |
| ADRUS | Shadow Table: Communication Usages (BAS) |
| SADR | Address Management: Company Data |
| TSADVC_CLIDEP | International Address Version Customizing (Client-Specific) |
| TSAD13 | Field Name for Regional Structure |
| TSADOBJT | Semantic description of BOR object type addresses |
| TSAD14 | Filter Values (Context) for BAdI ADDR_BUPA_TD_READ |
| ADRUS2 | Shadow Table_2: Communication Usages (BAS) |
| ADRC_UUID_INDEX | Index Table for ADRC-UUID |
List of tables in Address Management/Business Address
| Table | Description |
|---|---|
| ADRCS | Shadow Table: Addresses (Business Address Services) |
| TSADOBJ | Assignments of BOR object types to address reference types |
| ADRUS | Shadow Table: Communication Usages (BAS) |
| SADR | Address Management: Company Data |
| TSADVC_CLIDEP | International Address Version Customizing (Client-Specific) |
| TSAD13 | Field Name for Regional Structure |
| TSADOBJT | Semantic description of BOR object type addresses |
| TSAD14 | Filter Values (Context) for BAdI ADDR_BUPA_TD_READ |
| ADRUS2 | Shadow Table_2: Communication Usages (BAS) |
| ADRC_UUID_INDEX | Index Table for ADRC-UUID |
| T005B | Name of address routines |
| ADRSTREET | Streets |
| ADRPCDCITY | Postal code/city: Assignment table |
| ADRVS | Shadow Table: Where-Used List for Addresses (BAS) |
| TSAD6T | Descriptions: Source Address/Personal Data (BAS) |
| TSAPDT | Pager Service Description (Business Address Services) |
| TSAD4 | Name Prefixes (Business Address Services) |
| ADRCTS | Shadow Table: Texts for Addresses (Business Addr. Services) |
| ADRDIF_PO | PO Box Difference Table for Quarterly Adjustment |
| ADRTS | Shadow Table: Texts for Communications Data (BAS) |
| ADRPOBOX | PO Boxes |
| TSADRVGRP | Object type groups for external search indexes |
| T005N | Name formats |
| TSADV | International versions of addresses |
| ADRSTATUS | SADR -> ADRC address conversion status per address group |
| TSADRV | Where-used list addresses: Object types, DDIC information |
| ADRSTRTYPE | Street type |
| TSAD2T | Academic Title Text (Business Address Services) |
| DPP_MASK_RSTRCT | Personal Data Destruction: Restriction Table for Masking |
| TSADVC | Customizing international address versions |
| T005T | Country Names |
| TSADRVGRPT | Object type group texts |
| ADRC | Addresses (Business Address Services) |
| ADRDIFINFO | Control Table for Quarterly Adjustment Difference Tables |
| TSAD8T | Name of Group of Persons (Business Address Services) |
| ADRPS | Shadow Table: Persons (Business Address Services) |
| SADR2 | Address Management: Telephone Numbers |
| TSAD11 | Key for CAM container |
| TSAD12 | Reasons for Non-Delivery (Business Address Services) |
| TSADRVGRPE | Object type group elements for external search indexes |
| TSADRVGREC | Threshold for Duplicate List in SAP Dialog Box |
| ADRCTS2 | Shadow Table 2: Address Texts (Business Address Services) |
| T005E | County |
| ADRCOUNTY | County codes |
| SADR3 | Address Management: Fax Numbers |
| ADR16 | Reserve Communication Method (Business Address Services) |
| ADR12 | FTP and URL (Business Address Services) |
| SADR8 | Address management: X.400 addresses |
| TSAD5T | Name Suffixes Text (Business Address Services) |
| ADRVP | Person Where-Used List (Business Address Services) |
| TSAC | Communication Methods (Business Address Services) |
| ADR11S2 | Shadow Table 2: SSF (Business Address Services) |
| TSADVT | Name of internationalen versions of addresses |
| TSADVC_REG2 | Version-Specific Control of Regional Structure |
| SADR5 | Address Management: Telex Numbers |
| T005A | Address routines |
| ADDR_PCDFORMAT | Customizing table for postal code |
| T005S | Taxes: Region (Province) Key |
| ADR3S | Shadow table: Fax numbers (Business Address Services) |
| TSAPPLSUB | Registration Table for App.-Defined Subscreen Area (BAS) |
| ADRREGGRP | Regional structure grouping |
| TSAD8 | Groups of Persons (Business Address Services) |
| ADRVPS | Shadow Table: Where-Used List for Persons (BAS) |
| ADR9S | Shadow Table: RFC Destinations (Business Address Services) |
| TSAD11T | Key text (Container) |
| ADRV | Address Where-Used List (Business Address Services) |
| TSAD15_COPY | BP Gender (Business Address Services) |
| ADRCITYT | Postal districts (long texts) |
| ADR4S | Shadow Table: Teletex Numbers (Business Address Services) |
| SADR13 | Address Management: Reserve table for communications numbers |
| ADRCITYPRT | Postal districts |
| ADR5 | Telex Numbers (Business Address Services) |
| ADRU | Table for Communication Usages |
| ADR13S2 | Shadow Table 2: Pager (Business Address Services) |
| ADRCOUNTYT | County (long texts) |
| ADRCITY | Postal cities |
| APPL_CODE_MASK | Application Code |
| SADR6 | Address Management: EDI Table |
| TSAVT | Address Versions Text (obsolete) |
| ADR2S2 | Shadow Table 2: Telephone Nos (Business Address Services) |
| ADR12S2 | Shadow Table 2: FTP and URL (Business Address Services) |
| ADRGS | Shadow table: Assignment of addresses to other address grps |
| ADRTS2 | Shadow Table 2: Communication Data Texts (BAS) |
| ADCNTRYQU | Countries with active quarterly adjustment |
| ADR10S2 | Shadow Table 2: Printer (Business Address Services) |
| TZONE | Customers: Regional zones |
| ADRCOMCS2 | Shdow Table 2: Comm. data serial number counter |
| TSADRVFLTV | Object ref. types - Filter value assignment (dupl. index) |
| SADRP | Address Management: Personal Data |
| EXADR | Table for Example Application (Business Address Services) |
| ADRT | Communication Data Text (Business Address Services) |
| ADRDIF_CT | City Difference Table for Quarterly Adjustment |
| ADR12S | Shadow Table: FTP and URL (Business Address Services) |
| ADR10 | Printer (Business Address Services) |
| T005 | Countries |
| TSAV | Address Versions (Business Address Services) (Obsolete) |
| TSADC | Address administration: Communications types administration |
| ADR7S | Shadow Table: RML Addresses (Business Address Services) |
| TSAD9V | Screen Variants for Version-Specific Address Masks |
| ADR15 | Reserve Communication Method (Business Address Services) |
| SADR14 | Address Management: Reserve table for communications numbers |
| TSAD5 | Name Suffixes/Title (Key) (Business Address Services) |
| ADQUINDX | INDX-Like Table for Quarterly Adjustment of Addresses |
| T005U | Taxes: Region Key: Texts |
| ADR2 | Telephone Numbers (Business Address Services) |
| ADR5S | Shadow Table: Fax Numbers (Business Address Services) |
| T005O | Name format fields |
| ADR6 | E-Mail Addresses (Business Address Services) |
| TSADVC_REG | Obsolete; Use Table TSADVC_REG2 |
| TSAD7T | Description of Address Groups (Business Address Services) |
| TSAD10 | Indexable address fields for duplicate check |
| SADR4 | Address Management: Teletext Numbers |
| TSADRUT | Description of the Communication Usages |
| ADR8S2 | Shadow Table 2: X.400 Numbers (Business Address Services) |
| TSAD3T | Titles (Texts) (Business Address Services) |
| ADR14 | Reserve Communication Method (Business Address Services) |
| TZONT | Customers: Regional Zone Texts |
| ADR13 | Pager (Business Address Services) |
| TSAD15 | Gender key (Business Address Services) |
| DPP_MASK | Personal Data Destruction: Customizing table for masking |
| ADR3S2 | Shadow Table 2: Fax Numbers (Business Address Services) |
| ADCPS | Shadow Table: Assignment Person/Addr. (Bus. Addr. Services) |
| SADR11 | Address Management: Reserve table with communications number |
| TSAD13T | Description for Field Name of Regional Structure |
| ADR7S2 | Shadow Table 2: RML Addresses (Business Address Services) |
| ADRDIF_ST | Street Difference Table for Quarterly Adjustment |
| ADR2S | Shadow Table: Telephone Numbers (Business Address Services) |
| ADRSTRTYPT | Street type (long texts) |
| ADR4 | Teletex Numbers (Business Address Services) |
| ADR7 | Remote Mail Addresses (SAP - SAP - Communication; BAS) |
| ADCP_UUID_INDEX | Index Table for ADCP-ADCP_UUID |
| ADRTOWNSHIP | Township codes |
| ADR8S | Shadow Table: X.400 Numbers (Business Address Services) |
| ADR5S2 | Shadow Table 2: Telex Numbers (Business Address Services) |
| ADRSTREETT | Streets (long texts) |
| ADOWNERREF | Temporary reference address storage - Master object (ALE) |
| ADR9 | RFC Destinations (Business Address Services) |
| ADRGP | Assignment of Persons to Further Person Groups (BAS) |
| ADRDIF_PC | Postal Code Difference Table for Quarterly Adjustment |
| ADRCOMCS | Shadow table: Counter for current numbers for comm. data |
| T005F | County: Texts |
| TSAD3 | Forms of Address (Key) (Business Address Services) |
| TSACT | Communication Method Description (Business Address Services) |
| TSAD15T | Gender Text (Business Address Services) |
| ADR13S | Shadow Table: Pager (Business Address Services) |
| TSADRVGRPC | Customizing settings for logical search pools |
| SADR10 | Address Management: Reserve table for communication numbers |
| ADRG | Assignment of Addresses to Other Address Groups (BAS) |
| ADRPSTCODE | Postal codes |
| ADCP | Person/Address Assignment (Business Address Services) |
| ADRSTRCONV | Conversion of Street Sections |
| ADRCOMC | Comm. Data Serial Number Counter (Business Address Services) |
| ADRCT | Address Texts (Business Address Services) |
| TSAD_FORM_TEXT | Text Elements for Formatted Addresses |
| TSADCORR | BC-SRV-ADR: Activate/Deactivate Specific Corrections |
| ADRDYCONTR | System table for screen construction for regional structure |
| ADR11 | SSF (Business Address Services) |
| ADRGS2 | Shadow Table 2: Assign Addresses to Other Address groups |
| SAIN | Central Address File: Address where-used list |
| TSAD15T_COPY | Copy of TSAD15T |
| SADR7 | Address Management: Mail Fields |
| ADR10S | Shadow Table: Printer (Business Address Services) |
| TSAD14T | Description of Contexts for BAdI ADDR_BUPA_TD_READ |
| TSAD12T | Reasons for Non-Delivery (Texts) (Business Address Services) |
| ADDRC_DELI_SERVT | Text Table for Address Delivery Service Types |
| ADR8 | X.400 Numbers (Business Address Services) |
| SADR12 | Address Management: Reserve table for communications numbers |
| ADR9S2 | Shadow Table 2: RFC Destination (Business Address Services) |
| ADDRC_DELI_SERV | Address Service Types |
| TSAPD | Pager Services (Business Address Services) |
| ADR11S | Shadow Table: SSF (Business Address Services) |
| TSAOB | Address objects |
| ADRCS2 | Shadow Table 2: Addresses (Business Address Services) |
| TSAD7 | Address Groups (Business Address Services) |
| ADRP | Persons (Business Address Services) |
| ADRGPS | Shadow table: Assignment of persons to other person groups |
| TSAD2 | Academic Title (Business Address Services) |
| TSAD9 | Screen variants for country-dependent address screens |
| ADR6S2 | Shadow Table 2: SMTP Numbers (Business Address Services) |
| ADR6S | Shadow Table: SMTP Numbers (Business Address Services) |
| ADRP_UUID_INDEX | Index Table for ADRP-ADRP_UUID |
| TSAD6 | Source Address or Personal Data (Business Address Services) |
| ADRTOWNSHIPT | Township (long texts) |
| TSAD_FORM_TEXT_T | Texts for the Text Elements in Formatted Addresses |
| ADR4S2 | Shadow Table 2: Teletex Numbers (Business Address Services) |
| ADRDIF_CP | District Difference Table for Quarterly Adjustment |
| ADRREGGRPT | Grouping of the regional structure (long texts) |
| ADR3 | Fax Numbers (Business Address Services) |
| TSADRU | Communication Usages: DDIC Information |
| ADRSTRPCD | Street (section)/postal code: Assignment |
| TSAPPLSUBT | Texts for TSAPPLSUB (BAS) |
| SADR9 | Address management: Soft*Switch numbers |