ADDR_D is a standard SAP table in SAP ECC (or) S/4HANA which stores I_ADDRESSTP I_ADDRESSTP data. There are total 69 fields in ADDR_D table.This blog post provides key technical details of SAP table ADDR_D, including its availability across SAP S/4HANA versions and the list of CDS views for ADDR_D table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | To be moved: Package for Address Reuse (APPL_CA_ADDR) |
| Technical Component | Basic Functions (MM-PUR-GF) |
SAP ADDR_D Table Fields
The following is the list of fields that are available in SAP ADDR_D table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | CLNT (3) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | SYSUUID | RAW (16) | |
| ADDRESSID | Address Number | AD_ADDRNUM | AD_ADDRNUM | CHAR (10) | |
| CAREOFNAME | c/o name | AD_NAME_CO | TEXT40 | CHAR (40) | |
| ADDITIONALSTREETSUFFIXNAME | Street 5 | AD_LCTN | TEXT40 | CHAR (40) | |
| CORRESPONDENCELANGUAGE | Language Key | SPRAS | SPRAS | LANG (1) | |
| PRFRDCOMMMEDIUMTYPE | Communication Method (Key) (Business Address Services) | AD_COMM | AD_COMM | CHAR (3) | |
| POBOX | PO Box | AD_POBX | CHAR10 | CHAR (10) | |
| POBOXISWITHOUTNUMBER | Flag: PO Box Without Number | AD_POBXNUM | XFELD | CHAR (1) | |
| POBOXPOSTALCODE | PO Box Postal Code | AD_PSTCD2 | CHAR10 | CHAR (10) | |
| POBOXLOBBYNAME | PO Box Lobby | AD_PO_BOX_LBY | TEXT40 | CHAR (40) | |
| POBOXDEVIATINGCITYNAME | PO Box city | AD_POBXLOC | TEXT40 | CHAR (40) | |
| POBOXDEVIATINGREGION | Region for PO Box (Country/Region, State, Province, …) | AD_POBXREG | REGIO | CHAR (3) | |
| POBOXDEVIATINGCOUNTRY | PO box country | AD_POBXCTY | LAND1 | CHAR (3) | |
| DELIVERYSERVICETYPECODE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | AD_DELIVERY_SERVICE_TYPE | CHAR (4) | |
| DELIVERYSERVICENUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR10 | CHAR (10) | |
| ADDRESSTIMEZONE | Address time zone | AD_TZONE | TZNZONE | CHAR (6) | |
| FULLNAME | Address Full Name | CAADDR_FULLNAME | TEXT80 | CHAR (80) | |
| CITYNAME | City | AD_CITY1 | TEXT40 | CHAR (40) | |
| DISTRICT | District | AD_CITY2 | TEXT40 | CHAR (40) | |
| CITYCODE | City code for city/street file | AD_CITYNUM | CITY_CODE | CHAR (12) | |
| HOMECITYNAME | City (different from postal city) | AD_CITY3 | TEXT40 | CHAR (40) | |
| POSTALCODE | City postal code | AD_PSTCD1 | CHAR10 | CHAR (10) | |
| COMPANYPOSTALCODE | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR10 | CHAR (10) | |
| STREETNAME | Street | AD_STREET | TEXT60 | CHAR (60) | |
| STREETPREFIXNAME | Street 2 | AD_STRSPP1 | TEXT40 | CHAR (40) | |
| ADDITIONALSTREETPREFIXNAME | Street 3 | AD_STRSPP2 | TEXT40 | CHAR (40) | |
| STREETSUFFIXNAME | Street 4 | AD_STRSPP3 | TEXT40 | CHAR (40) | |
| HOUSENUMBER | House Number | AD_HSNM1 | TEXT10 | CHAR (10) | |
| HOUSENUMBERSUPPLEMENTTEXT | House number supplement | AD_HSNM2 | TEXT10 | CHAR (10) | |
| BUILDING | Building (Number or Code) | AD_BLDNG | TEXT20 | CHAR (20) | |
| FLOOR | Floor in building | AD_FLOOR | TEXT10 | CHAR (10) | |
| ROOMNUMBER | Room or Apartment Number | AD_ROOMNUM | TEXT10 | CHAR (10) | |
| COUNTRY | Country | CAADDR_COUNTRY | LAND1 | CHAR (3) | |
| REGION | Region (State, Province, County) | REGIO | REGIO | CHAR (3) | |
| COUNTY | County | AD_COUNTY | TEXT40 | CHAR (40) | |
| COUNTYCODE | County code for county | AD_CNTYNUM | CNTY_CODE | CHAR (8) | |
| FORMOFADDRESS | Form-of-Address Key | AD_TITLE | AD_TITLE | CHAR (4) | |
| BUSINESSPARTNERNAME1 | Name 1 | AD_NAME1 | TEXT40 | CHAR (40) | |
| BUSINESSPARTNERNAME2 | Name 2 | AD_NAME2 | TEXT40 | CHAR (40) | |
| NATION | Version ID for International Addresses | AD_NATION | AD_NATION | CHAR (1) | |
| PHONENUMBER | Phone Number: Area Code+Number | CAADDR_PHONENR | CHAR30 | CHAR (30) | |
| FAXNUMBER | First Fax No.: Area Code + Number | AD_FXNMBR1 | CHAR30 | CHAR (30) | |
| SEARCHTERM1 | Search Term 1 | AD_SORT1 | CHAR20 | CHAR (20) | |
| STREETSEARCH | Street Name in Uppercase for Search Help | AD_MC_STRT | CHAR25 | CHAR (25) | |
| CITYSEARCH | City name in Uppercase for Search Help | AD_MC_CITY | CHAR25 | CHAR (25) | |
| BUSINESSPARTNERNAME3 | Name 3 | AD_NAME3 | TEXT40 | CHAR (40) | |
| BUSINESSPARTNERNAME4 | Name 4 | AD_NAME4 | TEXT40 | CHAR (40) | |
| TAXJURISDICTION | Tax Jurisdiction | AD_TXJCD | AD_TXJCD | CHAR (15) | |
| TRANSPORTZONE | Transportation zone to or from which the goods are delivered | LZONE | ZONE | CHAR (10) | |
| PERSON | Person Number | AD_PERSNUM | AD_PERSNUM | CHAR (10) | |
| ADDRESSTYPE | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | AD_ADRTYPE | CHAR (1) | |
| ADDRESSOWNEROBJECTID | Address owner object ID | AD_OBJKEY | SWO_TYPEID | CHAR (70) | |
| ADDRESSISCHANGEDMANUALLY | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | BOOLEAN | CHAR (1) | |
| ACTIVEADDRESSID | Address Number | AD_ADDRNUM | AD_ADDRNUM | CHAR (10) | |
| ACTIVEADDRESSISMANUAL | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | BOOLEAN | CHAR (1) | |
| ADDRESSOWNERTABLENAME | Application table logical name (address management) | AD_APPLTAB | CHAR10 | CHAR (10) | |
| ADDRESSOWNERREFERENCEFIELDNAME | Application table address where-used list logical field name | AD_APPLFLD | CHAR10 | CHAR (10) | |
| ADDRESSOWNERMANUALFIELDNAME | Application table address where-used list logical field name | AD_APPLFLD | CHAR10 | CHAR (10) | |
| REFERENCEADDRESSID | Address Number | AD_ADDRNUM | AD_ADDRNUM | CHAR (10) | |
| REFERENCEOBJECTID | Address owner object ID | AD_OBJKEY | SWO_TYPEID | CHAR (70) | |
| REFERENCEADDRESSTYPE | Address Type | CAADDR_E_TYPE | CAADDR_D_TYPE | CHAR (2) | |
| EMAILADDRESS | SMTP Address | CAADDR_SMTPADR | AD_SMTPADR | CHAR (241) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | BOOLE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | TZNTSTMPL | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | TZNTSTMPL | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | SYSUUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | SDRAFT_OPERATION_CODE | CHAR (1) |
Availability
The SAP table ADDR_D is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ADDR_D table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
