SAP Table CMS_STR_ADRC_STRUC_620
CMS Structure for BP:Address(Adrc)(BANK/CFM/462_10)
CMS_STR_ADRC_STRUC_620 (CMS Structure for BP:Address(Adrc)(BANK/CFM/462_10)) 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 CMS_STR_ADRC_STRUC_620 to other SAP tables.
Source: CMS_STR_ADRC_STRUC_620 (CMS Structure for BP:Address(Adrc)(BANK/CFM/462_10))
CMS_STR_ADRC_STRUC_620 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 | CHAR | 12 | 0 | |||||||||
| CITYP_CODE | District code for City and Street file | AD_CITYPNM | 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 | CHAR | 12 | 0 | |||||||||
| CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | 0 |
Possible values
|
||||||||
| REGIOGROUP | Regional structure grouping | REGIOGROUP | 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 | 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 | CHAR | 12 | 0 | |||||||||
| PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | 0 | |||||||||
| PO_BOX_CTY | PO box country | AD_POBXCTY | 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 | CHAR | 10 | 0 | |||||||||
| STREET | Street | AD_STREET | CHAR | 60 | 0 | |||||||||
| DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | 0 | |||||||||
| STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | 0 | |||||||||
| STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | 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 | CHAR | 3 | 0 | |||||||||
| LANGU | Language Key | SPRAS | LANG | 1 | 0 | |||||||||
| REGION | Region (State, Province, County) | REGIO | CHAR | 3 | 0 | |||||||||
| SORT1 | Search Term 1 | AD_SORT1 | CHAR | 20 | 0 | |||||||||
| SORT2 | Search Term 2 | AD_SORT2 | 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 | 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 | 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 | LANG | 1 | 0 | |||||||||
