ADRC is a standard Address Management/Business Address Transparent Table in SAP Basis application, which stores Addresses (Business Address Services) data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for ADRC. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

ADRC — Meta Data

Description: Addresses (Business Address Services)
Main Category: Basis
Sub Category: Address Management/Business Address
Table type: Transparent Table (TRANSP)

ADRC — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 CLIENT Client X CLNT 3 T000
    2 ADDRNUMBER Address number X CHAR 10
    3 DATE_FROM From Date X DATS 8
    4 NATION International address version ID X CHAR 1 TSADV
    5 DATE_TO To Date DATS 8
    6 TITLE Title Text CHAR 4 TSAD3
    7 NAME1 Name 1 CHAR 40
    8 NAME2 Name 2 CHAR 40
    9 NAME3 Name 3 CHAR 40
    10 NAME4 Name 4 CHAR 40
    11 NAME_TEXT Full Name of Person CHAR 50
    12 NAME_CO c/o Name CHAR 40
    13 CITY1 City name in upper case for search help CHAR 40
    14 CITY2 District CHAR 40
    15 CITY_CODE City Code CHAR 12 ADRCITY
    16 CITYP_CODE District code for City and Street file CHAR 8 ADRCITYPRT
    17 HOME_CITY City (different from postal city) CHAR 40
    18 CITYH_CODE Different City Coding for City/Street File CHAR 12 ADRCITY
    19 CHCKSTATUS City file test status CHAR 1
    20 REGIOGROUP Regional structure grouping CHAR 8 ADRREGGRP
    21 POST_CODE1 City postal code CHAR 10
    22 POST_CODE2 PO Box Postal Code CHAR 10
    23 POST_CODE3 Company Postal Code (Large Customers) CHAR 10
    24 PCODE1_EXT City postal code extension CHAR 10
    25 PCODE2_EXT PO Box postal code extension CHAR 10
    26 PCODE3_EXT Major customer postal code extension CHAR 10
    27 PO_BOX PO Box CHAR 10
    28 DONT_USE_P PO Box Address Undeliverable Flag CHAR 4 TSAD12
    29 PO_BOX_NUM Flag: PO Box without number CHAR 1
    30 PO_BOX_LOC PO Box City CHAR 40
    31 CITY_CODE2 City PO box code (City file) CHAR 12 ADRCITY
    32 PO_BOX_REG Region for PO Box (Country CHAR 3 T005S
    33 PO_BOX_CTY PO Box Country CHAR 3 T005
    34 POSTALAREA (Not Supported) Post Delivery District CHAR 15
    35 TRANSPZONE Transportation zone to or from which the goods are delivered CHAR 10 TZONE
    36 STREET Street CHAR 60
    37 DONT_USE_S Street Address Undeliverable Flag CHAR 4 TSAD12
    38 STREETCODE Street Code for City/Street File CHAR 12 ADRSTREET
    39 STREETABBR (Not Supported) Abbreviation of Street Name CHAR 2 ADRSTRTYPE
    40 HOUSE_NUM1 House Number CHAR 10
    41 HOUSE_NUM2 House number supplement CHAR 10
    42 HOUSE_NUM3 (Not supported) House Number Range CHAR 10
    43 STR_SUPPL1 Street 2 CHAR 40
    44 STR_SUPPL2 Street 3 CHAR 40
    45 STR_SUPPL3 Street 4 CHAR 40
    46 LOCATION Error Location CHAR 40
    47 BUILDING Building Number CHAR 20
    48 FLOOR Floor in Building CHAR 10
    49 ROOMNUMBER Apartment or Room Number CHAR 10
    50 COUNTRY Country CHAR 3 T005
    51 LANGU Language LANG 1 T002
    52 REGION Region CHAR 3 T005S
    53 ADDR_GROUP Address Group (Key) (Business Address Services) CHAR 4 TSAD7
    54 FLAGGROUPS Flag: There are more address group assignments CHAR 1
    55 PERS_ADDR Flag: This is a personal address CHAR 1
    56 SORT1 Sort field CHAR 20
    57 SORT2 Search term 2 CHAR 20
    58 SORT_PHN Phonetic search sort field CHAR 20
    59 DEFLT_COMM Communication Method (Key) (Business Address Services) CHAR 3 TSAC
    60 TEL_NUMBER Telephone no.: dialling code+number CHAR 30
    61 TEL_EXTENS First Telephone No.: Extension CHAR 10
    62 FAX_NUMBER First fax no.: dialling code+number CHAR 30
    63 FAX_EXTENS First fax no.: extension CHAR 10
    64 FLAGCOMM2 Flag: Telephone number(s) defined CHAR 1
    65 FLAGCOMM3 Flag: Fax number(s) defined CHAR 1
    66 FLAGCOMM4 Flag: Teletex number(s) defined CHAR 1
    67 FLAGCOMM5 Flag: Telex number(s) defined CHAR 1
    68 FLAGCOMM6 Flag: E-mail address(es) defined CHAR 1
    69 FLAGCOMM7 Flag: RML (remote mail) addresse(s) defined CHAR 1
    70 FLAGCOMM8 Flag: X.400 addresse(s) defined CHAR 1
    71 FLAGCOMM9 Flag: RFC destination(s) defined CHAR 1
    72 FLAGCOMM10 Flag: Printer defined CHAR 1
    73 FLAGCOMM11 Flag: SSF defined CHAR 1
    74 FLAGCOMM12 Flag: URI/FTP address defined CHAR 1
    75 FLAGCOMM13 Flag: Pager address defined CHAR 1
    76 ADDRORIGIN Address data source (key) CHAR 4 TSAD6
    77 MC_NAME1 Matchcode field 1 (name 1/last name) CHAR 25
    78 MC_CITY1 City name in Uppercase for Search Help CHAR 25
    79 MC_STREET Street Name in Uppercase for Search Help CHAR 25
    80 EXTENSION1 Extension (only for data conversion) (e.g. data line) CHAR 40
    81 EXTENSION2 Extension (only for data conversion) (e.g. telebox) CHAR 40
    82 TIME_ZONE Address time zone CHAR 6 TTZZ
    83 TAXJURCODE Tax jurisdiction code CHAR 15
    84 ADDRESS_ID Physical address ID CHAR 10
    85 LANGU_CREA Address record creation original language LANG 1
    86 ADRC_UUID UUID Used in the Address RAW 16
    87 UUID_BELATED Indicator: UUID created later CHAR 1
    88 ID_CATEGORY Category of an Address ID CHAR 1
    89 ADRC_ERR_STATUS Error Status of Address CHAR 1
    90 PO_BOX_LOBBY PO Box Lobby CHAR 40
    91 DELI_SERV_TYPE Type of Delivery Service CHAR 4 ADDRC_DELI_SERV
    92 DELI_SERV_NUMBER Number of Delivery Service CHAR 10
    93 COUNTY_CODE County code for county CHAR 8
    94 COUNTY County CHAR 40
    95 TOWNSHIP_CODE Township code for Township CHAR 8
    96 TOWNSHIP Township CHAR 40
    97 MC_COUNTY County name in upper case for search help CHAR 25
    98 MC_TOWNSHIP Township name in upper case for search help CHAR 25
    99 XPCPT Business Purpose Completed Flag CHAR 1
    100 _DATAAGING Data Filter Value for Data Aging DATS 8
    101 .INCLU--AP 0
    102 DUNS Data Universal Numbering System CHAR 9
    103 DUNSP4 DUNS+4 number (the last four digit) CHAR 4

SAP Help, Wiki Resources, and Forum Discussions on ADRC

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
VBPA Sales Document: Partner SD - Basic Functions
ADR6 E-Mail Addresses (Business Address Services) Basis - Address Management/Business Address
VBAK Sales Document: Header Data SD - Sales
BUT000 BP: General data I Basis - Use AP-MD-BP* Components
ADRP Persons (Business Address Services) Basis - Address Management/Business Address
EKPO Purchasing Document Item MM - Purchasing
T001 Company Codes FI - Financial Accounting

Transaction Codes for SAP Table ADRC

TCODE Description Functional Area
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SE16 Data Browser Basis - Workbench Utilities
SE38 ABAP Editor Basis - ABAP Editor
VA01 Create Sales Order SD - Sales
SADR Address maint. - Group required! Basis - Address Management/Business Address
VA02 Change Sales Order SD - Sales
SE37 ABAP Function Modules Basis - Function Builder

FMs for SAP Table ADRC

FM Description Functional Area
ADDRESS_INTO_PRINTFORM Address Format According to Post Office Guidelines Basis - Address Management/Business Address
ADDR_GET Read an address without dialog Basis - Address Management/Business Address
CLOSE_FORM SAPscript: End layout set printing Basis - SAPscript
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal Basis - Syntax, Compiler, Runtime
F4_FILENAME F4 for filename / Filemanager support to locate file in a directory PM - Plant Maintenance
WRITE_FORM SAPscript: Output text element in form window Basis - SAPscript
FP_JOB_OPEN Basis - Forms Processing

ABAP Reports for SAP Table ADRC

ABAP REPORT Description Functional Area
SAPMF02D Customer Master Data Logistics - Customer Master
SAPMV45A Sales Order Processing SD - Sales
RVADTABL INCLUDE for General Table Descriptions for Print Programs SD - Output Determination
SAPMF02K Vendor Master Data FI - Basic Functions
SAPFM06P Print Program for Purchasing Documents MM - Purchasing
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony
RFBIKR00 Batch Input Interface for Vendors FI - Financial Accounting
BBP_PD Document Display (Procurement Framework) SRM - Enterprise Buyer

BW Datasources for SAP Table ADRC

BW DATASOURCE Description Functional Area
0FI_AP_4 Vendors: Line Items with Delta Extrcation FI - Accounts Payable
2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution
0CUSTOMER_ATTR Customer Number Logistics - Logistics - General
2LIS_02_HDR Purchasing Data (Header Level) MM - Materials Management
0VENDOR_ATTR Vendor Number MM - Materials Management
0BP_DEF_ADDRESS_ATTR SAP BP: BP Standard Address Extraction -
2LIS_11_VASCL Sales Document Schedule Line SD - Sales and Distribution
2LIS_11_VAHDR Sales Document Header Data SD - Sales and Distribution

Authorization Objects for SAP Table ADRC

AUTHORIZATION OBJECT Description Functional Area
F_BKPF_BUK Accounting Document: Authorization for Company Codes
M_BEST_BSA Document Type in Purchase Order
M_MATE_BUK Material Master: Company Codes
M_BEST_EKG Purchasing Group in Purchase Order
CMS_CAG Authorization object for CAG
M_MATE_WRK Material Master: Plants
M_BEST_EKO Purchasing Organization in Purchase Order
CMS_RBL Authorization object for receivable in CMS