Menu

SAP Table ADRC

Addresses (Business Address Services)

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table ADRC (Addresses (Business Address Services)) is a standard table in SAP ERP. It belongs to the package SZAD.

Technical Information

Table ADRC
Short Text Addresses (Business Address Services)
Package SZAD
Table Type Transparent Table

Fields for Table ADRC

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