SAP Table ADRC_STRUC
Include structure with ADRC attributes without name fields
ADRC_STRUC (Include structure with ADRC attributes without name fields) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ADRC_STRUC to other SAP tables.
Source: ADRC_STRUC (Include structure with ADRC attributes without name fields)
ADRC_STRUC table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | 0 | |||||||||
| CITY1 | City | AD_CITY1 | CHAR | 40 | 0 | |||||||||
| CITY2 | District | AD_CITY2 | CHAR | 40 | 0 | |||||||||
| CITY_CODE | City code for city/street file | AD_CITYNUM | ADRCITY | CHAR | 12 | 0 | ||||||||
| CITYP_CODE | District code for City and Street file | AD_CITYPNM | ADRCITYPRT | CHAR | 8 | 0 | ||||||||
| HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | 0 | |||||||||
| CITYH_CODE | Different city for city/street file | AD_CITYHNM | ADRCITY | CHAR | 12 | 0 | ||||||||
| CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | 0 |
Possible values
|
||||||||
| REGIOGROUP | Regional structure grouping | REGIOGROUP | ADRREGGRP | CHAR | 8 | 0 | ||||||||
| POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | 0 | |||||||||
| POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | 0 | |||||||||
| POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | 0 | |||||||||
| PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | 0 | |||||||||
| PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | 0 | |||||||||
| PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | 0 | |||||||||
| PO_BOX | PO Box | AD_POBX | CHAR | 10 | 0 | |||||||||
| DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | TSAD12 | CHAR | 4 | 0 | ||||||||
| PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | 0 |
Possible values
|
||||||||
| PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | 0 | |||||||||
| CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | ADRCITY | CHAR | 12 | 0 | ||||||||
| PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | T005S | CHAR | 3 | 0 | ||||||||
| PO_BOX_CTY | PO box country | AD_POBXCTY | T005 | CHAR | 3 | 0 | ||||||||
| POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | 0 | |||||||||
| TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | TZONE | CHAR | 10 | 0 | ||||||||
| STREET | Street | AD_STREET | CHAR | 60 | 0 | |||||||||
| DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | TSAD12 | CHAR | 4 | 0 | ||||||||
| STREETCODE | Street Number for City/Street File | AD_STRNUM | ADRSTREET | CHAR | 12 | 0 | ||||||||
| STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | ADRSTRTYPE | CHAR | 2 | 0 | ||||||||
| HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | 0 | |||||||||
| HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | 0 | |||||||||
| HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | 0 | |||||||||
| STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | 0 | |||||||||
| STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | 0 | |||||||||
| STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | 0 | |||||||||
| LOCATION | Street 5 | AD_LCTN | CHAR | 40 | 0 | |||||||||
| BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | 0 | |||||||||
| FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | 0 | |||||||||
| ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | 0 | |||||||||
| COUNTRY | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||||
| LANGU | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||
| REGION | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||||
| SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | 0 | |||||||||
| SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | 0 | |||||||||
| SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | 0 | |||||||||
| ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | TSAD6 | CHAR | 4 | 0 | ||||||||
| EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | 0 | |||||||||
| EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | 0 | |||||||||
| TIME_ZONE | Address time zone | AD_TZONE | TTZZ | CHAR | 6 | 0 | ||||||||
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | 0 | |||||||||
| ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | 0 | |||||||||
| REMARK | Address notes | AD_REMARK1 | CHAR | 50 | 0 | |||||||||
| LANGU_CREA | Address record creation original language | AD_LANGUCR | T002 | LANG | 1 | 0 | ||||||||
| PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | 0 | |||||||||
| DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | ADDRC_DELI_SERV | CHAR | 4 | 0 | ||||||||
| DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | 0 | |||||||||
| COUNTY_CODE | County code for county | AD_CNTYNUM | ADRCOUNTY | CHAR | 8 | 0 | ||||||||
| COUNTY | County | AD_COUNTY | CHAR | 40 | 0 | |||||||||
| TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | ADRTOWNSHIP | CHAR | 8 | 0 | ||||||||
| TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | 0 | |||||||||
ADRC_STRUC foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADRC_STRUC | ADDRORIGIN | ADRC_STRUC | ADDRORIGIN | TSAD6 | Source Address or Personal Data (Business Address Services) | ORIGIN |
| ADRC_STRUC | ADDRORIGIN | * | TSAD6 | Source Address or Personal Data (Business Address Services) | CLIENT | |
| ADRC_STRUC | CITYH_CODE | ADRC_STRUC | CITYH_CODE | ADRCITY | Postal cities | CITY_CODE |
| ADRC_STRUC | CITYH_CODE | ADRC_STRUC | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADRC_STRUC | CITYH_CODE | * | ADRCITY | Postal cities | CLIENT | |
| ADRC_STRUC | CITYP_CODE | ADRC_STRUC | CITYP_CODE | ADRCITYPRT | Postal districts | CITYP_CODE |
| ADRC_STRUC | CITYP_CODE | ADRC_STRUC | CITY_CODE | ADRCITYPRT | Postal districts | CITY_CODE |
| ADRC_STRUC | CITYP_CODE | ADRC_STRUC | COUNTRY | ADRCITYPRT | Postal districts | COUNTRY |
| ADRC_STRUC | CITYP_CODE | * | ADRCITYPRT | Postal districts | CLIENT | |
| ADRC_STRUC | CITY_CODE | ADRC_STRUC | CITY_CODE | ADRCITY | Postal cities | CITY_CODE |
| ADRC_STRUC | CITY_CODE | ADRC_STRUC | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADRC_STRUC | CITY_CODE | * | ADRCITY | Postal cities | CLIENT | |
| ADRC_STRUC | CITY_CODE2 | ADRC_STRUC | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADRC_STRUC | CITY_CODE2 | ADRC_STRUC | CITY_CODE2 | ADRCITY | Postal cities | CITY_CODE |
| ADRC_STRUC | CITY_CODE2 | * | ADRCITY | Postal cities | CLIENT | |
| ADRC_STRUC | COUNTRY | ADRC_STRUC | COUNTRY | T005 | Countries | LAND1 |
| ADRC_STRUC | COUNTRY | * | T005 | Countries | MANDT | |
| ADRC_STRUC | COUNTY_CODE | ADRC_STRUC | COUNTY_CODE | ADRCOUNTY | County codes | COUNTY_CODE |
| ADRC_STRUC | COUNTY_CODE | ADRC_STRUC | PO_BOX_REG | ADRCOUNTY | County codes | REGION |
| ADRC_STRUC | COUNTY_CODE | ADRC_STRUC | PO_BOX_CTY | ADRCOUNTY | County codes | COUNTRY |
| ADRC_STRUC | COUNTY_CODE | SYST | MANDT | ADRCOUNTY | County codes | CLIENT |
| ADRC_STRUC | DELI_SERV_TYPE | SYST | MANDT | ADDRC_DELI_SERV | Address Service Types | CLIENT |
| ADRC_STRUC | DELI_SERV_TYPE | ADRC_STRUC | DELI_SERV_TYPE | ADDRC_DELI_SERV | Address Service Types | DELI_SERV_TYPE |
| ADRC_STRUC | DONT_USE_P | ADRC_STRUC | DONT_USE_P | TSAD12 | Reasons for Non-Delivery (Business Address Services) | UNDELIVER |
| ADRC_STRUC | DONT_USE_P | SYST | MANDT | TSAD12 | Reasons for Non-Delivery (Business Address Services) | CLIENT |
| ADRC_STRUC | DONT_USE_S | ADRC_STRUC | DONT_USE_S | TSAD12 | Reasons for Non-Delivery (Business Address Services) | UNDELIVER |
| ADRC_STRUC | DONT_USE_S | SYST | MANDT | TSAD12 | Reasons for Non-Delivery (Business Address Services) | CLIENT |
| ADRC_STRUC | LANGU | ADRC_STRUC | LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
| ADRC_STRUC | LANGU_CREA | ADRC_STRUC | LANGU_CREA | T002 | Language Keys (Component BC-I18) | SPRAS |
| ADRC_STRUC | PO_BOX_CTY | ADRC_STRUC | PO_BOX_CTY | T005 | Countries | LAND1 |
| ADRC_STRUC | PO_BOX_CTY | * | T005 | Countries | MANDT | |
| ADRC_STRUC | PO_BOX_REG | * | T005S | Taxes: Region (Province) Key | MANDT | |
| ADRC_STRUC | PO_BOX_REG | ADRC_STRUC | PO_BOX_CTY | T005S | Taxes: Region (Province) Key | LAND1 |
| ADRC_STRUC | PO_BOX_REG | ADRC_STRUC | PO_BOX_REG | T005S | Taxes: Region (Province) Key | BLAND |
| ADRC_STRUC | REGIOGROUP | * | ADRREGGRP | Regional structure grouping | CLIENT | |
| ADRC_STRUC | REGIOGROUP | ADRC_STRUC | REGIOGROUP | ADRREGGRP | Regional structure grouping | REGIOGROUP |
| ADRC_STRUC | REGION | ADRC_STRUC | REGION | T005S | Taxes: Region (Province) Key | BLAND |
| ADRC_STRUC | REGION | ADRC_STRUC | COUNTRY | T005S | Taxes: Region (Province) Key | LAND1 |
| ADRC_STRUC | REGION | * | T005S | Taxes: Region (Province) Key | MANDT | |
| ADRC_STRUC | STREETABBR | ADRC_STRUC | STREETABBR | ADRSTRTYPE | Street type | STRTYPEAB |
| ADRC_STRUC | STREETABBR | * | ADRSTRTYPE | Street type | CLIENT | |
| ADRC_STRUC | STREETABBR | ADRC_STRUC | COUNTRY | ADRSTRTYPE | Street type | COUNTRY |
| ADRC_STRUC | STREETCODE | * | ADRSTREET | Streets | CLIENT | |
| ADRC_STRUC | STREETCODE | ADRC_STRUC | STREETCODE | ADRSTREET | Streets | STRT_CODE |
| ADRC_STRUC | STREETCODE | ADRC_STRUC | COUNTRY | ADRSTREET | Streets | COUNTRY |
| ADRC_STRUC | TIME_ZONE | ADRC_STRUC | TIME_ZONE | TTZZ | Time zones | TZONE |
| ADRC_STRUC | TIME_ZONE | * | TTZZ | Time zones | CLIENT | |
| ADRC_STRUC | TOWNSHIP_CODE | ADRC_STRUC | TOWNSHIP_CODE | ADRTOWNSHIP | Township codes | TOWNSHIP_CODE |
| ADRC_STRUC | TOWNSHIP_CODE | ADRC_STRUC | COUNTY_CODE | ADRTOWNSHIP | Township codes | COUNTY_CODE |
| ADRC_STRUC | TOWNSHIP_CODE | ADRC_STRUC | PO_BOX_REG | ADRTOWNSHIP | Township codes | REGION |
| ADRC_STRUC | TOWNSHIP_CODE | ADRC_STRUC | PO_BOX_CTY | ADRTOWNSHIP | Township codes | COUNTRY |
| ADRC_STRUC | TOWNSHIP_CODE | SYST | MANDT | ADRTOWNSHIP | Township codes | CLIENT |
| ADRC_STRUC | TRANSPZONE | * | TZONE | Customers: Regional zones | MANDT | |
| ADRC_STRUC | TRANSPZONE | ADRC_STRUC | COUNTRY | TZONE | Customers: Regional zones | LAND1 |
| ADRC_STRUC | TRANSPZONE | ADRC_STRUC | TRANSPZONE | TZONE | Customers: Regional zones | ZONE1 |
