SAP Table ADRC - Addresses (Business Address Services)

Field Key Data Element Type Offset Leng Decimals Check Table Text
CLIENT X MANDT CLNT 0 3 0 T000 Client
ADDRNUMBER X AD_ADDRNUM CHAR 3 10 0 Address number
DATE_FROM X AD_DATE_FR DATS 13 8 0 Valid-from date - in current Release only 00010101 possible
NATION X AD_NATION CHAR 21 1 0 TSADV International address version ID
DATE_TO AD_DATE_TO DATS 22 8 0 Valid-to date in current Release only 99991231 possible
TITLE AD_TITLE CHAR 30 4 0 TSAD3 Form-of-Address Key
NAME1 AD_NAME1 CHAR 34 40 0 Name 1
NAME2 AD_NAME2 CHAR 74 40 0 Name 2
NAME3 AD_NAME3 CHAR 114 40 0 Name 3
NAME4 AD_NAME4 CHAR 154 40 0 Name 4
NAME_TEXT AD_NAMETXT CHAR 194 50 0 Converted name field (with form of address)
NAME_CO AD_NAME_CO CHAR 244 40 0 c/o name
CITY1 AD_CITY1 CHAR 284 40 0 City
CITY2 AD_CITY2 CHAR 324 40 0 District
CITY_CODE AD_CITYNUM CHAR 364 12 0 City code for city/street file
CITYP_CODE AD_CITYPNM CHAR 376 8 0 ADRCITYPRT District code for City and Street file
HOME_CITY AD_CITY3 CHAR 384 40 0 City (different from postal city)
CITYH_CODE AD_CITYHNM CHAR 424 12 0 Different city for city/street file
CHCKSTATUS AD_CHECKST CHAR 436 1 0 City file test status
REGIOGROUP REGIOGROUP CHAR 437 8 0 Regional structure grouping
POST_CODE1 AD_PSTCD1 CHAR 445 10 0 City postal code
POST_CODE2 AD_PSTCD2 CHAR 455 10 0 PO Box postal code
POST_CODE3 AD_PSTCD3 CHAR 465 10 0 Company postal code (for large customers)
PCODE1_EXT AD_PST1XT CHAR 475 10 0 (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
PCODE2_EXT AD_PST2XT CHAR 485 10 0 (Not Supported) PO Box Postal Code Extension
PCODE3_EXT AD_PST3XT CHAR 495 10 0 (Not Supported) Major Customer Postal Code Extension
PO_BOX AD_POBX CHAR 505 10 0 PO Box
DONT_USE_P AD_NO_USEP CHAR 515 4 0 PO Box Address Undeliverable Flag
PO_BOX_NUM AD_POBXNUM CHAR 519 1 0 Flag: PO Box without number
PO_BOX_LOC AD_POBXLOC CHAR 520 40 0 PO Box city
CITY_CODE2 AD_CIT2NUM CHAR 560 12 0 City PO box code (City file)
PO_BOX_REG AD_POBXREG CHAR 572 3 0 T005S Region for PO Box (Country, State, Province, ...)
PO_BOX_CTY AD_POBXCTY CHAR 575 3 0 T005 PO box country
POSTALAREA AD_PSTLAR CHAR 578 15 0 (Not Supported) Post Delivery District
TRANSPZONE LZONE CHAR 593 10 0 Transportation zone to or from which the goods are delivered
STREET AD_STREET CHAR 603 60 0 Street
DONT_USE_S AD_NO_USES CHAR 663 4 0 Street Address Undeliverable Flag
STREETCODE AD_STRNUM CHAR 667 12 0 Street Number for City/Street File
STREETABBR AD_STRABBR CHAR 679 2 0 ADRSTRTYPE (Not Supported) Abbreviation of Street Name
HOUSE_NUM1 AD_HSNM1 CHAR 681 10 0 House Number
HOUSE_NUM2 AD_HSNM2 CHAR 691 10 0 House number supplement
HOUSE_NUM3 AD_HSNM3 CHAR 701 10 0 (Not supported) House Number Range
STR_SUPPL1 AD_STRSPP1 CHAR 711 40 0 Street 2
STR_SUPPL2 AD_STRSPP2 CHAR 751 40 0 Street 3
STR_SUPPL3 AD_STRSPP3 CHAR 791 40 0 Street 4
LOCATION AD_LCTN CHAR 831 40 0 Street 5
BUILDING AD_BLDNG CHAR 871 20 0 Building (Number or Code)
FLOOR AD_FLOOR CHAR 891 10 0 Floor in building
ROOMNUMBER AD_ROOMNUM CHAR 901 10 0 Room or Appartment Number
COUNTRY LAND1 CHAR 911 3 0 T005 Country Key
LANGU SPRAS LANG 914 1 0 T002 Language Key
REGION REGIO CHAR 915 3 0 T005S Region (State, Province, County)
ADDR_GROUP AD_GROUP CHAR 918 4 0 Address Group (Key) (Business Address Services)
FLAGGROUPS AD_FLGGP CHAR 922 1 0 Flag: There are more address group assignments
PERS_ADDR AD_PRSADDR CHAR 923 1 0 Flag: This is a personal address
SORT1 AD_SORT1 CHAR 924 20 0 Search Term 1
SORT2 AD_SORT2 CHAR 944 20 0 Search Term 2
SORT_PHN AD_SRTPHN CHAR 964 20 0 (Not Supported) Phonetic Search Sort Field
DEFLT_COMM AD_COMM CHAR 984 3 0 Communication Method (Key) (Business Address Services)
TEL_NUMBER AD_TLNMBR1 CHAR 987 30 0 First telephone no.: dialling code+number
TEL_EXTENS AD_TLXTNS1 CHAR 1017 10 0 First Telephone No.: Extension
FAX_NUMBER AD_FXNMBR1 CHAR 1027 30 0 First fax no.: dialling code+number
FAX_EXTENS AD_FXXTNS1 CHAR 1057 10 0 First fax no.: extension
FLAGCOMM2 AD_FLGCM02 CHAR 1067 1 0 Flag: Telephone number(s) maintained
FLAGCOMM3 AD_FLGCM03 CHAR 1068 1 0 Flag: Fax number(s) maintained
FLAGCOMM4 AD_FLGCM04 CHAR 1069 1 0 Flag: Teletex number(s) maintained
FLAGCOMM5 AD_FLGCM05 CHAR 1070 1 0 Flag: Telex number(s) maintained
FLAGCOMM6 AD_FLGCM06 CHAR 1071 1 0 Indicator: E-Mail Address(es) Maintained
FLAGCOMM7 AD_FLGCM07 CHAR 1072 1 0 Flag: RML (remote mail) addresse(s) maintained
FLAGCOMM8 AD_FLGCM08 CHAR 1073 1 0 Flag: X.400 addresse(s) maintained
FLAGCOMM9 AD_FLGCM09 CHAR 1074 1 0 Flag: RFC destination(s) maintained
FLAGCOMM10 AD_FLGCM10 CHAR 1075 1 0 Flag: Printer maintained
FLAGCOMM11 AD_FLGCM11 CHAR 1076 1 0 Flag: SSF maintained
FLAGCOMM12 AD_FLGCM12 CHAR 1077 1 0 Flag: URI/FTP address maintained
FLAGCOMM13 AD_FLGCM13 CHAR 1078 1 0 Flag: Pager address maintained
ADDRORIGIN AD_ORIGINA CHAR 1079 4 0 (Not Supported) Address Data Source (Key)
MC_NAME1 AD_MC_NAME CHAR 1083 25 0 Name (field NAME1) in upper case for matchcode
MC_CITY1 AD_MC_CITY CHAR 1108 25 0 City name in upper case for search help
MC_STREET AD_MC_STRT CHAR 1133 25 0 Street name in upper case for search help
EXTENSION1 AD_EXTENS1 CHAR 1158 40 0 Extension (only for data conversion) (e.g. data line)
EXTENSION2 AD_EXTENS2 CHAR 1198 40 0 Extension (only for data conversion) (e.g. telebox)
TIME_ZONE AD_TZONE CHAR 1238 6 0 TTZZ Address time zone
TAXJURCODE AD_TXJCD CHAR 1244 15 0 Tax Jurisdiction
ADDRESS_ID AD_ADDR_ID CHAR 1259 10 0 (Not supported) Physical address ID
LANGU_CREA AD_LANGUCR LANG 1269 1 0 T002 Address record creation original language
PO_BOX_LOBBY AD_PO_BOX_LBY CHAR 1270 40 0 PO Box Lobby
DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 1310 4 0 Type of Delivery Service
DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR 1314 10 0 Number of Delivery Service

169226Maintenance of titles before the upgrade
1557535RFUMSV00: Performance when reading adress data
856819AM-891 when you delete a contact person relationship
1456827IS-U Loc. for TR - Address Update: FM-s + bug corrections
1024253Matchcode regeneration in Unicode systems
1484457RFASLD20(Slovakia):Issue in Tag PSC of XML Output
765997Quarterly adjustment: Streets are deleted
547748FAQ: Archiving sales documents
785802PPOMA_BBP: 'Defective' users in EBP
1374766Address data is not archived for delivery documents
1383139 REACH: Error when reading the legal entity
634839Text language for address versions
1353497Tables for fields relevant to printouts of changes
13480860UC_CONNOBJ_ATTR_2: City number and street number not filled
1171039City/district info incorrect after transfer to route plannng
680695Unicode conversion in tables LFA1, KNA1 and KNVK
847705AM-885 Relationship address cannot be assigned -2-
937084Enhancing a search help without modification in RE-FX
183587Clean-up of one-time addresses if conversion errors occur
673941Unicode conversion for address tables (ADRC, ADRP)
595442Poor performance for 'Partner by Address' search help
517102BP_ADU: Composite SAP note time-dependent address usages
724492BP_DIA: Correspondence language for SAP business partner
731320Customers or vendors are missing in the duplicate index
536249SAP BP: PAR: House number not transferred to TR BP
656108BP_TR1: Language missing in organizations after conversion
645872BP_TR1: Conversion of form of addr:Corr report for tab. ADRC
643800BP_TR1: Field TITLE in ADRC not supplied with data
645813A short dump occurs when you create a filter
384462Master data and addresses
639624EXPORT_BUFFER_NO_MEMORY in TZON_CUSTOMIZING_ADDRESS_GET
636538Missing entries in input help of the (maintenance) plant
554173HR-GB: P11D timeframe and employer address/name
379824ME21N ME51N Problems with delivery address
608659Update Customer Master with new transition jurisdiction code
601832BaFin §24c: Addresses are not filled
602039BAFin(German Fed.Fin.Sup.Auth.)§24c:Date of birth not filled
97802Tablespace sizes for conversion addresses for 4.5/4.6/4.7
572659Search term for BAPI_VENDOR_FIND and BAPI_CUSTOMER_FIND
538040Time zone determination for customer and plant
525673 Indexes on address tables
433997H_T001W only searches via T001W
482121TAX: Gap in table T5KTC for Ontario employees.
450322Indexes in the tables of the Business Address Services
402965Error in conversion rpts f. address data RCVDEHS1 & RCVDEHS2
400781EDI ORDCHG: Error message ME760 with change to Address
202094Incorrect city number for P.O.box address
323700Transport of Customizing addresses between Releases,,,,
363213Address validation in batch input