SAP Table ADRCS - Shadow Table: Addresses (Business Address Services)

Field Key Data Element Type Offset Leng Decimals Check Table Text
CLIENT X MANDT CLNT 0 3 0 T000 Client
TRKORR X TRKORR CHAR 3 20 0 Request/Task
ADDRNUMBER X AD_ADDRNUM CHAR 23 10 0 Address number
DATE_FROM X AD_DATE_FR DATS 33 8 0 Valid-from date - in current Release only 00010101 possible
NATION X AD_NATION CHAR 41 1 0 TSADV International address version ID
DATE_TO AD_DATE_TO DATS 42 8 0 Valid-to date in current Release only 99991231 possible
TITLE AD_TITLE CHAR 50 4 0 TSAD3 Form-of-Address Key
NAME1 AD_NAME1 CHAR 54 40 0 Name 1
NAME2 AD_NAME2 CHAR 94 40 0 Name 2
NAME3 AD_NAME3 CHAR 134 40 0 Name 3
NAME4 AD_NAME4 CHAR 174 40 0 Name 4
NAME_TEXT AD_NAMETXT CHAR 214 50 0 Converted name field (with form of address)
NAME_CO AD_NAME_CO CHAR 264 40 0 c/o name
CITY1 AD_CITY1 CHAR 304 40 0 City
CITY2 AD_CITY2 CHAR 344 40 0 District
CITY_CODE AD_CITYNUM CHAR 384 12 0 City code for city/street file
CITYP_CODE AD_CITYPNM CHAR 396 8 0 ADRCITYPRT District code for City and Street file
HOME_CITY AD_CITY3 CHAR 404 40 0 City (different from postal city)
CITYH_CODE AD_CITYHNM CHAR 444 12 0 Different city for city/street file
CHCKSTATUS AD_CHECKST CHAR 456 1 0 City file test status
REGIOGROUP REGIOGROUP CHAR 457 8 0 Regional structure grouping
POST_CODE1 AD_PSTCD1 CHAR 465 10 0 City postal code
POST_CODE2 AD_PSTCD2 CHAR 475 10 0 PO Box postal code
POST_CODE3 AD_PSTCD3 CHAR 485 10 0 Company postal code (for large customers)
PCODE1_EXT AD_PST1XT CHAR 495 10 0 (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
PCODE2_EXT AD_PST2XT CHAR 505 10 0 (Not Supported) PO Box Postal Code Extension
PCODE3_EXT AD_PST3XT CHAR 515 10 0 (Not Supported) Major Customer Postal Code Extension
PO_BOX AD_POBX CHAR 525 10 0 PO Box
DONT_USE_P AD_NO_USEP CHAR 535 4 0 PO Box Address Undeliverable Flag
PO_BOX_NUM AD_POBXNUM CHAR 539 1 0 Flag: PO Box without number
PO_BOX_LOC AD_POBXLOC CHAR 540 40 0 PO Box city
CITY_CODE2 AD_CIT2NUM CHAR 580 12 0 City PO box code (City file)
PO_BOX_REG AD_POBXREG CHAR 592 3 0 T005S Region for PO Box (Country, State, Province, ...)
PO_BOX_CTY AD_POBXCTY CHAR 595 3 0 T005 PO box country
POSTALAREA AD_PSTLAR CHAR 598 15 0 (Not Supported) Post Delivery District
TRANSPZONE LZONE CHAR 613 10 0 Transportation zone to or from which the goods are delivered
STREET AD_STREET CHAR 623 60 0 Street
DONT_USE_S AD_NO_USES CHAR 683 4 0 Street Address Undeliverable Flag
STREETCODE AD_STRNUM CHAR 687 12 0 Street Number for City/Street File
STREETABBR AD_STRABBR CHAR 699 2 0 ADRSTRTYPE (Not Supported) Abbreviation of Street Name
HOUSE_NUM1 AD_HSNM1 CHAR 701 10 0 House Number
HOUSE_NUM2 AD_HSNM2 CHAR 711 10 0 House number supplement
HOUSE_NUM3 AD_HSNM3 CHAR 721 10 0 (Not supported) House Number Range
STR_SUPPL1 AD_STRSPP1 CHAR 731 40 0 Street 2
STR_SUPPL2 AD_STRSPP2 CHAR 771 40 0 Street 3
STR_SUPPL3 AD_STRSPP3 CHAR 811 40 0 Street 4
LOCATION AD_LCTN CHAR 851 40 0 Street 5
BUILDING AD_BLDNG CHAR 891 20 0 Building (Number or Code)
FLOOR AD_FLOOR CHAR 911 10 0 Floor in building
ROOMNUMBER AD_ROOMNUM CHAR 921 10 0 Room or Appartment Number
COUNTRY LAND1 CHAR 931 3 0 T005 Country Key
LANGU SPRAS LANG 934 1 0 T002 Language Key
REGION REGIO CHAR 935 3 0 T005S Region (State, Province, County)
ADDR_GROUP AD_GROUP CHAR 938 4 0 Address Group (Key) (Business Address Services)
FLAGGROUPS AD_FLGGP CHAR 942 1 0 Flag: There are more address group assignments
PERS_ADDR AD_PRSADDR CHAR 943 1 0 Flag: This is a personal address
SORT1 AD_SORT1 CHAR 944 20 0 Search Term 1
SORT2 AD_SORT2 CHAR 964 20 0 Search Term 2
SORT_PHN AD_SRTPHN CHAR 984 20 0 (Not Supported) Phonetic Search Sort Field
DEFLT_COMM AD_COMM CHAR 1004 3 0 Communication Method (Key) (Business Address Services)
TEL_NUMBER AD_TLNMBR1 CHAR 1007 30 0 First telephone no.: dialling code+number
TEL_EXTENS AD_TLXTNS1 CHAR 1037 10 0 First Telephone No.: Extension
FAX_NUMBER AD_FXNMBR1 CHAR 1047 30 0 First fax no.: dialling code+number
FAX_EXTENS AD_FXXTNS1 CHAR 1077 10 0 First fax no.: extension
FLAGCOMM2 AD_FLGCM02 CHAR 1087 1 0 Flag: Telephone number(s) maintained
FLAGCOMM3 AD_FLGCM03 CHAR 1088 1 0 Flag: Fax number(s) maintained
FLAGCOMM4 AD_FLGCM04 CHAR 1089 1 0 Flag: Teletex number(s) maintained
FLAGCOMM5 AD_FLGCM05 CHAR 1090 1 0 Flag: Telex number(s) maintained
FLAGCOMM6 AD_FLGCM06 CHAR 1091 1 0 Indicator: E-Mail Address(es) Maintained
FLAGCOMM7 AD_FLGCM07 CHAR 1092 1 0 Flag: RML (remote mail) addresse(s) maintained
FLAGCOMM8 AD_FLGCM08 CHAR 1093 1 0 Flag: X.400 addresse(s) maintained
FLAGCOMM9 AD_FLGCM09 CHAR 1094 1 0 Flag: RFC destination(s) maintained
FLAGCOMM10 AD_FLGCM10 CHAR 1095 1 0 Flag: Printer maintained
FLAGCOMM11 AD_FLGCM11 CHAR 1096 1 0 Flag: SSF maintained
FLAGCOMM12 AD_FLGCM12 CHAR 1097 1 0 Flag: URI/FTP address maintained
FLAGCOMM13 AD_FLGCM13 CHAR 1098 1 0 Flag: Pager address maintained
ADDRORIGIN AD_ORIGINA CHAR 1099 4 0 (Not Supported) Address Data Source (Key)
MC_NAME1 AD_MC_NAME CHAR 1103 25 0 Name (field NAME1) in upper case for matchcode
MC_CITY1 AD_MC_CITY CHAR 1128 25 0 City name in upper case for search help
MC_STREET AD_MC_STRT CHAR 1153 25 0 Street name in upper case for search help
EXTENSION1 AD_EXTENS1 CHAR 1178 40 0 Extension (only for data conversion) (e.g. data line)
EXTENSION2 AD_EXTENS2 CHAR 1218 40 0 Extension (only for data conversion) (e.g. telebox)
TIME_ZONE AD_TZONE CHAR 1258 6 0 TTZZ Address time zone
TAXJURCODE AD_TXJCD CHAR 1264 15 0 Tax Jurisdiction
ADDRESS_ID AD_ADDR_ID CHAR 1279 10 0 (Not supported) Physical address ID
LANGU_CREA AD_LANGUCR LANG 1289 1 0 T002 Address record creation original language
PO_BOX_LOBBY AD_PO_BOX_LBY CHAR 1290 40 0 PO Box Lobby
DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 1330 4 0 Type of Delivery Service
DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR 1334 10 0 Number of Delivery Service

1024253Matchcode regeneration in Unicode systems
673941Unicode conversion for address tables (ADRC, ADRP)