SAP Table

ADRC Addresses (Business Address Services)

SAP table ADRC has 4 primary key fields being CLIENT,ADDRNUMBER,DATE_FROM,NATION.

/ Fields

ADRC columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyCLIENT Client CLNT 3 0 T000 MANDT
KeyADDRNUMBER Address Number CHAR 10 0 AD_ADDRNUM
KeyDATE_FROM Valid-from date - in current Release only 00010101 possible DATS 8 0 AD_DATE_FR
KeyNATION Version ID for International Addresses CHAR 1 0 TSADV AD_NATION
DATE_TO Valid-to date in current Release only 99991231 possible DATS 8 0 AD_DATE_TO
TITLE Form-of-Address Key CHAR 4 0 TSAD3 AD_TITLE
NAME1 Name 1 CHAR 40 0 AD_NAME1
NAME2 Name 2 CHAR 40 0 AD_NAME2
NAME3 Name 3 CHAR 40 0 AD_NAME3
NAME4 Name 4 CHAR 40 0 AD_NAME4
NAME_TEXT Converted name field (with form of address) CHAR 50 0 AD_NAMETXT
NAME_CO c/o name CHAR 40 0 AD_NAME_CO
CITY1 City CHAR 40 0 AD_CITY1
CITY2 District CHAR 40 0 AD_CITY2
CITY_CODE City code for city/street file CHAR 12 0 ADRCITY AD_CITYNUM
CITYP_CODE District code for City and Street file CHAR 8 0 ADRCITYPRT AD_CITYPNM
HOME_CITY City (different from postal city) CHAR 40 0 AD_CITY3
CITYH_CODE Different city for city/street file CHAR 12 0 ADRCITY AD_CITYHNM
CHCKSTATUS City file test status CHAR 1 0 AD_CHECKST
REGIOGROUP Regional structure grouping CHAR 8 0 ADRREGGRP REGIOGROUP
POST_CODE1 City postal code CHAR 10 0 AD_PSTCD1
POST_CODE2 PO Box Postal Code CHAR 10 0 AD_PSTCD2
POST_CODE3 Company Postal Code (for Large Customers) CHAR 10 0 AD_PSTCD3
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code CHAR 10 0 AD_PST1XT
PCODE2_EXT (Not Supported) PO Box Postal Code Extension CHAR 10 0 AD_PST2XT
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension CHAR 10 0 AD_PST3XT
PO_BOX PO Box CHAR 10 0 AD_POBX
DONT_USE_P PO Box Address Undeliverable Flag CHAR 4 0 TSAD12 AD_NO_USEP
PO_BOX_NUM Flag: PO Box Without Number CHAR 1 0 AD_POBXNUM
PO_BOX_LOC PO Box city CHAR 40 0 AD_POBXLOC
CITY_CODE2 City PO box code (City file) CHAR 12 0 ADRCITY AD_CIT2NUM
PO_BOX_REG Region for PO Box (Country/Region, State, Province, ...) CHAR 3 0 T005S AD_POBXREG
PO_BOX_CTY PO Box of Country/Region CHAR 3 0 T005 AD_POBXCTY
POSTALAREA (Not Supported) Post Delivery District CHAR 15 0 AD_PSTLAR
TRANSPZONE Transportation zone to or from which the goods are delivered CHAR 10 0 TZONE LZONE
STREET Street CHAR 60 0 AD_STREET
DONT_USE_S Street Address Undeliverable Flag CHAR 4 0 TSAD12 AD_NO_USES
STREETCODE Street Number for City/Street File CHAR 12 0 ADRSTREET AD_STRNUM
STREETABBR (Not Supported) Abbreviation of Street Name CHAR 2 0 ADRSTRTYPE AD_STRABBR
HOUSE_NUM1 House Number CHAR 10 0 AD_HSNM1
HOUSE_NUM2 House number supplement CHAR 10 0 AD_HSNM2
HOUSE_NUM3 (Not supported) House Number Range CHAR 10 0 AD_HSNM3
STR_SUPPL1 Street 2 CHAR 40 0 AD_STRSPP1
STR_SUPPL2 Street 3 CHAR 40 0 AD_STRSPP2
STR_SUPPL3 Street 4 CHAR 40 0 AD_STRSPP3
LOCATION Street 5 CHAR 40 0 AD_LCTN
BUILDING Building (Number or Code) CHAR 20 0 AD_BLDNG
FLOOR Floor in building CHAR 10 0 AD_FLOOR
ROOMNUMBER Room or Apartment Number CHAR 10 0 AD_ROOMNUM
COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
LANGU Language Key LANG 1 0 T002 SPRAS
REGION Region (State, Province, County) CHAR 3 0 T005S REGIO
ADDR_GROUP Address Group (Key) (Business Address Services) CHAR 4 0 TSAD7 AD_GROUP
FLAGGROUPS Flag: There are more address group assignments CHAR 1 0 AD_FLGGP
PERS_ADDR Flag: This is a personal address CHAR 1 0 AD_PRSADDR
SORT1 Search Term 1 CHAR 20 0 AD_SORT1
SORT2 Search Term 2 CHAR 20 0 AD_SORT2
SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR 20 0 AD_SRTPHN
DEFLT_COMM Communication Method (Key) (Business Address Services) CHAR 3 0 TSAC AD_COMM
TEL_NUMBER First telephone no.: dialling code+number CHAR 30 0 AD_TLNMBR1
TEL_EXTENS First Telephone No.: Extension CHAR 10 0 AD_TLXTNS1
FAX_NUMBER First Fax No.: Area Code + Number CHAR 30 0 AD_FXNMBR1
FAX_EXTENS First fax no.: extension CHAR 10 0 AD_FXXTNS1
FLAGCOMM2 Flag: Telephone number(s) defined CHAR 1 0 AD_FLGCM02
FLAGCOMM3 Flag: Fax number(s) defined CHAR 1 0 AD_FLGCM03
FLAGCOMM4 Flag: Teletex number(s) defined CHAR 1 0 AD_FLGCM04
FLAGCOMM5 Flag: Telex number(s) defined CHAR 1 0 AD_FLGCM05
FLAGCOMM6 Flag: E-mail address(es) defined CHAR 1 0 AD_FLGCM06
FLAGCOMM7 Flag: RML (remote mail) addresse(s) defined CHAR 1 0 AD_FLGCM07
FLAGCOMM8 Flag: X.400 addresse(s) defined CHAR 1 0 AD_FLGCM08
FLAGCOMM9 Flag: RFC destination(s) defined CHAR 1 0 AD_FLGCM09
FLAGCOMM10 Flag: Printer defined CHAR 1 0 AD_FLGCM10
FLAGCOMM11 Flag: SSF defined CHAR 1 0 AD_FLGCM11
FLAGCOMM12 Flag: URI/FTP address defined CHAR 1 0 AD_FLGCM12
FLAGCOMM13 Flag: Pager address defined CHAR 1 0 AD_FLGCM13
ADDRORIGIN (Not Supported) Address Data Source (Key) CHAR 4 0 TSAD6 AD_ORIGINA
MC_NAME1 Name (Field NAME1) in Uppercase for Search Help CHAR 25 0 AD_MC_NAME
MC_CITY1 City name in Uppercase for Search Help CHAR 25 0 AD_MC_CITY
MC_STREET Street Name in Uppercase for Search Help CHAR 25 0 AD_MC_STRT
EXTENSION1 Extension (only for data conversion) (e.g. data line) CHAR 40 0 AD_EXTENS1
EXTENSION2 Extension (only for data conversion) (e.g. telebox) CHAR 40 0 AD_EXTENS2
TIME_ZONE Address time zone CHAR 6 0 TTZZ AD_TZONE
TAXJURCODE Tax Jurisdiction CHAR 15 0 AD_TXJCD
ADDRESS_ID (Not supported) Physical address ID CHAR 10 0 AD_ADDR_ID
LANGU_CREA Address record creation original language LANG 1 0 AD_LANGUCR
ADRC_UUID UUID Used in the Address RAW 16 0 AD_UUID
UUID_BELATED Indicator: UUID created later CHAR 1 0 AD_UUID_BELATED
ID_CATEGORY Category of an Address ID CHAR 1 0 AD_ID_CATEGORY
ADRC_ERR_STATUS Error Status of Address CHAR 1 0 AD_ERR_STATUS
PO_BOX_LOBBY PO Box Lobby CHAR 40 0 AD_PO_BOX_LBY
DELI_SERV_TYPE Type of Delivery Service CHAR 4 0 ADDRC_DELI_SERV AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBER Number of Delivery Service CHAR 10 0 AD_DELIVERY_SERVICE_NUMBER
COUNTY_CODE County code for county CHAR 8 0 AD_CNTYNUM
COUNTY County CHAR 40 0 AD_COUNTY
TOWNSHIP_CODE Township code for Township CHAR 8 0 AD_TWSHPNUM
TOWNSHIP Township CHAR 40 0 AD_TOWNSHIP
MC_COUNTY County name in upper case for search help CHAR 25 0 AD_MC_COUNTY
MC_TOWNSHIP Township name in upper case for search help CHAR 25 0 AD_MC_TWSHP
XPCPT Business Purpose Completed Flag CHAR 1 0 AD_XPCPT
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
DUNS Dun & Bradstreet number (DUNS) CHAR 9 0 /SAPHT/RN_DUNS
DUNSP4 DUNS+4 number (the last four digit) CHAR 4 0 /SAPHT/RN_DUNSP4
/ Relationships

ADRC foreign keys.

Table Field Check Table Description Check Field
ADRC ADDRORIGIN TSAD6 Source Address or Personal Data (Business Address Services) CLIENT
ADRC ADDRORIGIN TSAD6 Source Address or Personal Data (Business Address Services) ORIGIN
ADRC ADDR_GROUP TSAD7 Address Groups (Business Address Services) ADDR_GROUP
ADRC CITYH_CODE ADRCITY Postal cities COUNTRY
ADRC CITYH_CODE ADRCITY Postal cities CITY_CODE
ADRC CITYP_CODE ADRCITYPRT Postal districts CLIENT
ADRC CITYP_CODE ADRCITYPRT Postal districts COUNTRY
ADRC CITYP_CODE ADRCITYPRT Postal districts CITY_CODE
ADRC CITY_CODE ADRCITY Postal cities COUNTRY
ADRC CITY_CODE ADRCITY Postal cities CITY_CODE
ADRC CITY_CODE2 ADRCITY Postal cities COUNTRY
ADRC CITY_CODE2 ADRCITY Postal cities CITY_CODE
ADRC CLIENT T000 Clients MANDT
ADRC COUNTRY T005 Countries MANDT
ADRC COUNTRY T005 Countries LAND1
ADRC DEFLT_COMM TSAC Communication Methods (Business Address Services) COMM_TYPE
ADRC DELI_SERV_TYPE ADDRC_DELI_SERV Address Service Types CLIENT
ADRC DELI_SERV_TYPE ADDRC_DELI_SERV Address Service Types DELI_SERV_TYPE
ADRC DONT_USE_P TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
ADRC DONT_USE_P TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
ADRC DONT_USE_S TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
ADRC DONT_USE_S TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
ADRC PO_BOX_CTY T005 Countries MANDT
ADRC PO_BOX_CTY T005 Countries LAND1
ADRC PO_BOX_REG T005S Taxes: Region (Province) Key LAND1
ADRC REGIOGROUP ADRREGGRP Regional structure grouping CLIENT
ADRC REGION T005S Taxes: Region (Province) Key LAND1
ADRC STREETABBR ADRSTRTYPE Street type CLIENT
ADRC STREETABBR ADRSTRTYPE Street type COUNTRY
ADRC STREETCODE ADRSTREET Streets CLIENT
ADRC STREETCODE ADRSTREET Streets COUNTRY
ADRC STREETCODE ADRSTREET Streets STRT_CODE
ADRC TIME_ZONE TTZZ Time zones TZONE
ADRC TITLE TSAD3 Forms of Address (Key) (Business Address Services) TITLE
ADRC TRANSPZONE TZONE Customers: Regional zones MANDT
ADRC TRANSPZONE TZONE Customers: Regional zones LAND1
ADRC TRANSPZONE TZONE Customers: Regional zones ZONE1
Back to SAP tables