SAP TXI_ADRC Table in S/4 HANA - Addresses (central address admin.)
TXI_ADRC is a standard SAP Table which is used to store Addresses (central address admin.) data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TXI_ADRC table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Structure
Database Table: TXI_ADRC
TXI_ADRC table structure field list
Below is the full TXI_ADRC field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
CLIENT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
ADDRNUMBER | Address Number | AD_ADDRNUM | CHAR | 10(0) | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | ||
DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8(0) | DATUM | |||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1(0) | TSADV | AD_NATION | ADDRESS_NATION | |||
DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 8(0) | DATUM | |||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4(0) | TSAD3 | AD_TITLE | ||||
NAME1 | Name 1 | AD_NAME1 | CHAR | 40(0) | TEXT40 | |||||
NAME2 | Name 2 | AD_NAME2 | CHAR | 40(0) | TEXT40 | |||||
NAME3 | Name 3 | AD_NAME3 | CHAR | 40(0) | TEXT40 | |||||
NAME4 | Name 4 | AD_NAME4 | CHAR | 40(0) | TEXT40 | |||||
NAME_TEXT | Converted name field (with form of address) | AD_NAMETXT | CHAR | 50(0) | TEXT50 | |||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40(0) | TEXT40 | |||||
CITY1 | City | AD_CITY1 | CHAR | 40(0) | TEXT40 | CLCITYNAME | CITY_NAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40(0) | TEXT40 | CITY_PART | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12(0) | ADRCITY | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8(0) | ADRCITYPRT | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40(0) | TEXT40 | |||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12(0) | ADRCITY | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1(0) | AD_CHECKST | |||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8(0) | ADRREGGRP | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10(0) | CHAR10 | |||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10(0) | CHAR10 | |||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10(0) | CHAR10 | |||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10(0) | CHAR10 | |||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10(0) | CHAR10 | |||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10(0) | CHAR10 | |||||
PO_BOX | PO Box | AD_POBX | CHAR | 10(0) | CHAR10 | |||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4(0) | TSAD12 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1(0) | XFELD | |||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40(0) | TEXT40 | CITY_NAME | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12(0) | ADRCITY | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3(0) | T005S | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3(0) | T005 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15(0) | TEXT15 | |||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10(0) | TZONE | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60(0) | TEXT60 | CLSTRTNAME | STREET | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4(0) | TSAD12 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12(0) | ADRSTREET | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2(0) | ADRSTRTYPE | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10(0) | TEXT10 | |||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10(0) | TEXT10 | |||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10(0) | TEXT10 | |||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40(0) | TEXT40 | |||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40(0) | TEXT40 | |||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40(0) | TEXT40 | |||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40(0) | TEXT40 | |||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20(0) | TEXT20 | |||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10(0) | TEXT10 | |||||
ROOMNUMBER | Room or Apartment Number | AD_ROOMNUM | CHAR | 10(0) | TEXT10 | |||||
COUNTRY | Country Key | LAND1 | CHAR | 3(0) | T005 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1(0) | T002 | ISOLA | SPRAS | SPR | H_T002 | SPRAS |
REGION | Region (State, Province, County) | REGIO | CHAR | 3(0) | T005S | REGIO | ||||
ADDR_GROUP | Address Group (Key) (Business Address Services) | AD_GROUP | CHAR | 4(0) | TSAD7 | AD_GROUP | ||||
FLAGGROUPS | Flag: There are more address group assignments | AD_FLGGP | CHAR | 1(0) | XFELD | |||||
PERS_ADDR | Flag: This is a personal address | AD_PRSADDR | CHAR | 1(0) | XFELD | |||||
SORT1 | Search Term 1 | AD_SORT1 | CHAR | 20(0) | CHAR20 | |||||
SORT2 | Search Term 2 | AD_SORT2 | CHAR | 20(0) | CHAR20 | |||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20(0) | CHAR20 | |||||
DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR | 3(0) | TSAC | AD_COMM | ||||
TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30(0) | CHAR30 | |||||
TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10(0) | CHAR10 | |||||
FAX_NUMBER | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR | 30(0) | CHAR30 | |||||
FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10(0) | CHAR10 | |||||
FLAGCOMM2 | Flag: Telephone number(s) defined | AD_FLGCM02 | CHAR | 1(0) | XFELD | |||||
FLAGCOMM3 | Flag: Fax number(s) defined | AD_FLGCM03 | CHAR | 1(0) | XFELD | |||||
FLAGCOMM4 | Flag: Teletex number(s) defined | AD_FLGCM04 | CHAR | 1(0) | XFELD | |||||
FLAGCOMM5 | Flag: Telex number(s) defined | AD_FLGCM05 | CHAR | 1(0) | XFELD | |||||
FLAGCOMM6 | Flag: E-mail address(es) defined | AD_FLGCM06 | CHAR | 1(0) | XFELD | |||||
FLAGCOMM7 | Flag: RML (remote mail) addresse(s) defined | AD_FLGCM07 | CHAR | 1(0) | XFELD | |||||
FLAGCOMM8 | Flag: X.400 addresse(s) defined | AD_FLGCM08 | CHAR | 1(0) | XFELD | |||||
FLAGCOMM9 | Flag: RFC destination(s) defined | AD_FLGCM09 | CHAR | 1(0) | XFELD | |||||
FLAGCOMM10 | Flag: Printer defined | AD_FLGCM10 | CHAR | 1(0) | XFELD | |||||
FLAGCOMM11 | Flag: SSF defined | AD_FLGCM11 | CHAR | 1(0) | XFELD | |||||
FLAGCOMM12 | Flag: URI/FTP address defined | AD_FLGCM12 | CHAR | 1(0) | XFELD | |||||
FLAGCOMM13 | Flag: Pager address defined | AD_FLGCM13 | CHAR | 1(0) | XFELD | |||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4(0) | TSAD6 | AD_ORIGIN | ||||
MC_NAME1 | Name (Field NAME1) in Uppercase for Search Help | AD_MC_NAME | CHAR | 25(0) | CHAR25 | |||||
MC_CITY1 | City name in Uppercase for Search Help | AD_MC_CITY | CHAR | 25(0) | CHAR25 | |||||
MC_STREET | Street Name in Uppercase for Search Help | AD_MC_STRT | CHAR | 25(0) | CHAR25 | |||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40(0) | TEXT40 | |||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40(0) | TEXT40 | |||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6(0) | TTZZ | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15(0) | AD_TXJCD | TXJ | ||||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10(0) | ALPHA | AD_ADDR_ID | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1(0) | Assigned to domain | ISOLA | SPRAS | |||
ADRC_UUID | UUID Used in the Address | AD_UUID | RAW | 16(0) | SYSUUID | |||||
UUID_BELATED | Indicator: UUID created later | AD_UUID_BELATED | CHAR | 1(0) | AD_UUID_BELATED | |||||
ID_CATEGORY | Category of an Address ID | AD_ID_CATEGORY | CHAR | 1(0) | AD_ID_CATEGORY | |||||
ADRC_ERR_STATUS | Error Status of Address | AD_ERR_STATUS | CHAR | 1(0) | AD_ERR_STATUS | |||||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40(0) | TEXT40 | |||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4(0) | ADDRC_DELI_SERV | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10(0) | CHAR10 | |||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8(0) | Assigned to domain | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40(0) | TEXT40 | CLTCNTYNAME | COUNTY | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8(0) | Assigned to domain | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40(0) | TEXT40 | CLTWSHPNAME | TOWNSHIP | |||
MC_COUNTY | County name in upper case for search help | AD_MC_COUNTY | CHAR | 25(0) | CHAR25 | |||||
MC_TOWNSHIP | Township name in upper case for search help | AD_MC_TWSHP | CHAR | 25(0) | CHAR25 | |||||
XPCPT | Business Purpose Completed Flag | AD_XPCPT | CHAR | 1(0) | AD_XPCPT | |||||
_DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8(0) | DATA_TEMPERATURE | |||||
.INCLU--AP | 0(0) | |||||||||
DUNS | Dun & Bradstreet number (DUNS) | /SAPHT/RN_DUNS | CHAR | 9(0) | CHAR9 | |||||
DUNSP4 | DUNS+4 number (the last four digit) | /SAPHT/RN_DUNSP4 | CHAR | 4(0) | CHAR4 |
Search for further information about these or an SAP related objects