Menu

SAP Table ADRCS

Shadow Table: Addresses (Business Address Services)

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

Technical Information

Table ADRCS
Short Text Shadow Table: Addresses (Business Address Services)
Package SZAD
Table Type Transparent Table

Fields for Table ADRCS

Field Name Key Description Data Element Type Length Check Table
CLIENT Client MANDT CLNT 3 T000
TRKORR Request/Task TRKORR CHAR 20 *
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
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