SAP /ACCGO/CCAK_S_ADDR1_API Table in S/4 HANA - address
/ACCGO/CCAK_S_ADDR1_API is a standard SAP Table which is used to store address data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP /ACCGO/CCAK_S_ADDR1_API table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type)
Dictionary Type: Structure
Database Table: /ACCGO/CCAK_S_ADDR1_API
/ACCGO/CCAK_S_ADDR1_API table structure field list
Below is the full /ACCGO/CCAK_S_ADDR1_API 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 |
| ADDR_NO | Address Number | AD_ADDRNUM | CHAR | 10(0) | ADRC | ALPHA | AD_ADDRNUM | ADR | ||
| FORMOFADDR | Form of address text | AD_TITLE_T | CHAR | 20(0) | TEXT20 | |||||
| NAME | Name 1 | AD_NAME1 | CHAR | 40(0) | TEXT40 | |||||
| NAME_2 | Name 2 | AD_NAME2 | CHAR | 40(0) | TEXT40 | |||||
| NAME_3 | Name 3 | AD_NAME3 | CHAR | 40(0) | TEXT40 | |||||
| NAME_4 | Name 4 | AD_NAME4 | CHAR | 40(0) | TEXT40 | |||||
| C_O_NAME | c/o name | AD_NAME_CO | CHAR | 40(0) | TEXT40 | |||||
| CITY | City | AD_CITY1 | CHAR | 40(0) | TEXT40 | CLCITYNAME | CITY_NAME | |||
| DISTRICT | District | AD_CITY2 | CHAR | 40(0) | TEXT40 | CITY_PART | CITY_PART | |||
| CITY_NO | City code for city/street file | AD_CITYNUM | CHAR | 12(0) | ADRCITY | ALPHA | CITY_CODE | |||
| POSTL_COD1 | City postal code | AD_PSTCD1 | CHAR | 10(0) | CHAR10 | |||||
| POSTL_COD2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10(0) | CHAR10 | |||||
| POSTL_COD3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10(0) | CHAR10 | |||||
| PO_BOX | PO Box | AD_POBX | CHAR | 10(0) | CHAR10 | |||||
| PO_BOX_CIT | PO Box city | AD_POBXLOC | CHAR | 40(0) | TEXT40 | CITY_NAME | CITY_NAME | |||
| DELIV_DIS | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15(0) | TEXT15 | |||||
| STREET | Street | AD_STR_OLD | CHAR | 40(0) | TEXT40 | |||||
| STREET_NO | Street Number for City/Street File | AD_STRNUM | CHAR | 12(0) | ADRSTREET | ALPHA | STRT_CODE | |||
| STR_ABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2(0) | ADRSTRTYPE | STRTYPEAB | ||||
| HOUSE_NO | House Number | AD_HSNM1 | CHAR | 10(0) | TEXT10 | |||||
| STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40(0) | TEXT40 | |||||
| STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40(0) | TEXT40 | |||||
| LOCATION | Street 5 | AD_LCTN | CHAR | 40(0) | TEXT40 | |||||
| BUILDING | old: building (no. or abbreviation) | AD_BLD_OLD | CHAR | 10(0) | TEXT10 | |||||
| FLOOR | Floor in building | AD_FLOOR | CHAR | 10(0) | TEXT10 | |||||
| ROOM_NO | 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 | ||||
| SORT1 | Search Term 1 | AD_SORT1 | CHAR | 20(0) | CHAR20 | |||||
| SORT2 | Search Term 2 | AD_SORT2 | CHAR | 20(0) | CHAR20 | |||||
| TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6(0) | TTZZ | TZNZONE | ||||
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15(0) | AD_TXJCD | TXJ | ||||
| ADR_NOTES | Address notes | AD_REMARK1 | CHAR | 50(0) | TEXT50 | |||||
| COMM_TYPE | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR | 3(0) | TSAC | AD_COMM | ||||
| TEL1_NUMBR | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30(0) | CHAR30 | |||||
| TEL1_EXT | 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 | |||||
| STREET_LNG | Street | AD_STREET | CHAR | 60(0) | TEXT60 | CLSTRTNAME | STREET | |||
| DISTRCT_NO | District code for City and Street file | AD_CITYPNM | CHAR | 8(0) | ADRCITYPRT | ALPHA | CITYP_CODE | |||
| CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1(0) | AD_CHECKST | |||||
| PBOXCIT_NO | City PO box code (City file) | AD_CIT2NUM | CHAR | 12(0) | ADRCITY | ALPHA | CITY_CODE | |||
| TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10(0) | TZONE | ZONE | ||||
| HOUSE_NO2 | House number supplement | AD_HSNM2 | CHAR | 10(0) | TEXT10 | |||||
| E_MAIL | E-Mail Address | AD_SMTPADR | CHAR | 241(0) | SXIDN | AD_SMTPADR | ||||
| STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40(0) | TEXT40 | |||||
| TITLE | Title text | AD_TITLETX | CHAR | 30(0) | TEXT30 | |||||
| COUNTRYISO | Country ISO code | INTCA | CHAR | 2(0) | INTCA | F4_INTCA | INTCA | |||
| LANGU_ISO | 2-Character SAP Language Code | LAISO | CHAR | 2(0) | LAISO | |||||
| BUILD_LONG | Building (Number or Code) | AD_BLDNG | CHAR | 20(0) | TEXT20 | |||||
| REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8(0) | ADRREGGRP | REGIOGROUP | ||||
| HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40(0) | TEXT40 | |||||
| HOMECITYNO | Different city for city/street file | AD_CITYHNM | CHAR | 12(0) | Assigned to domain | ALPHA | CITY_CODE | |||
| 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_W_O_NO | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1(0) | XFELD | |||||
| PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3(0) | Assigned to domain | REGIO | ||||
| POBOX_CTRY | PO box country | AD_POBXCTY | CHAR | 3(0) | Assigned to domain | LAND1 | ||||
| PO_CTRYISO | Country ISO code | INTCA | CHAR | 2(0) | INTCA | F4_INTCA | INTCA | |||
| HOMEPAGE | URI, e.g. Homepage or ftp Address | AD_URISCR | CHAR | 132(0) | AD_URISCR | |||||
| DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4(0) | TSAD12 | AD_NO_USE | ||||
| DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4(0) | TSAD12 | AD_NO_USE | ||||
| HOUSE_NO3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10(0) | TEXT10 | |||||
| LANGU_CR | Address record creation original language | AD_LANGUCR | LANG | 1(0) | Assigned to domain | ISOLA | SPRAS | |||
| LANGUCRISO | 2-Character SAP Language Code | LAISO | CHAR | 2(0) | LAISO | |||||
| 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) | Assigned to domain | AD_DELIVERY_SERVICE_TYPE | ||||
| DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10(0) | CHAR10 | |||||
| URI_TYPE | URI type flag | AD_URITYPE | CHAR | 3(0) | AD_URITYPE | |||||
| 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 | |||
| XPCPT | Business Purpose Completed Flag | AD_XPCPT | CHAR | 1(0) | AD_XPCPT |
Search for further information about these or an SAP related objects