SAP ADDR_D I_ADDRESSTP I_ADDRESSTP Table

Overview

ADDR_D is a standard SAP S/4HANA table that stores I_ADDRESSTP I_ADDRESSTP data. There are total 69 fields in the ADDR_D table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ADDR_D belongs to Basic Functions (MM-PUR-GF) module and is located in the package To be moved: Package for Address Reuse (APPL_CA_ADDR).

In addition, following links provide an overview of foreign key relationships, if any, that link ADDR_D to other SAP tables and standard CDS views available based on ADDR_D table in S/4HANA 2020.

Techincal Settings of ADDR_D

Below are technical details of the table ADDR_D

Buffering not allowed
No buffering
Storage type is Column Store

List of ADDR_D Fields

The following table gives you an overview of the fields available in ADDR_D

Field	Description	Data Element	Data Type	Length
MANDT	Client	MANDT	CLNT	3
DRAFTUUID	UUID serving as key (parent key, root key)	/BOBF/UUID	RAW	16
ADDRESSID	Address Number	AD_ADDRNUM	CHAR	10
CAREOFNAME	c/o name	AD_NAME_CO	CHAR	40
ADDITIONALSTREETSUFFIXNAME	Street 5	AD_LCTN	CHAR	40
CORRESPONDENCELANGUAGE	Language Key	SPRAS	LANG	1
PRFRDCOMMMEDIUMTYPE	Communication Method (Key) (Business Address Services)	AD_COMM	CHAR	3
POBOX	PO Box	AD_POBX	CHAR	10
POBOXISWITHOUTNUMBER	Flag: PO Box Without Number	AD_POBXNUM	CHAR	1
POBOXPOSTALCODE	PO Box Postal Code	AD_PSTCD2	CHAR	10
POBOXLOBBYNAME	PO Box Lobby	AD_PO_BOX_LBY	CHAR	40
POBOXDEVIATINGCITYNAME	PO Box city	AD_POBXLOC	CHAR	40
POBOXDEVIATINGREGION	Region for PO Box (Country/Region, State, Province, ...)	AD_POBXREG	CHAR	3
POBOXDEVIATINGCOUNTRY	PO box country	AD_POBXCTY	CHAR	3
DELIVERYSERVICETYPECODE	Type of Delivery Service	AD_DELIVERY_SERVICE_TYPE	CHAR	4
DELIVERYSERVICENUMBER	Number of Delivery Service	AD_DELIVERY_SERVICE_NUMBER	CHAR	10
ADDRESSTIMEZONE	Address time zone	AD_TZONE	CHAR	6
FULLNAME	Address Full Name	CAADDR_FULLNAME	CHAR	80
CITYNAME	City	AD_CITY1	CHAR	40
DISTRICT	District	AD_CITY2	CHAR	40
CITYCODE	City code for city/street file	AD_CITYNUM	CHAR	12
HOMECITYNAME	City (different from postal city)	AD_CITY3	CHAR	40
POSTALCODE	City postal code	AD_PSTCD1	CHAR	10
COMPANYPOSTALCODE	Company Postal Code (for Large Customers)	AD_PSTCD3	CHAR	10
STREETNAME	Street	AD_STREET	CHAR	60
STREETPREFIXNAME	Street 2	AD_STRSPP1	CHAR	40
ADDITIONALSTREETPREFIXNAME	Street 3	AD_STRSPP2	CHAR	40
STREETSUFFIXNAME	Street 4	AD_STRSPP3	CHAR	40
HOUSENUMBER	House Number	AD_HSNM1	CHAR	10
HOUSENUMBERSUPPLEMENTTEXT	House number supplement	AD_HSNM2	CHAR	10
BUILDING	Building (Number or Code)	AD_BLDNG	CHAR	20
FLOOR	Floor in building	AD_FLOOR	CHAR	10
ROOMNUMBER	Room or Apartment Number	AD_ROOMNUM	CHAR	10
COUNTRY	Country	CAADDR_COUNTRY	CHAR	3
REGION	Region (State, Province, County)	REGIO	CHAR	3
COUNTY	County	AD_COUNTY	CHAR	40
COUNTYCODE	County code for county	AD_CNTYNUM	CHAR	8
FORMOFADDRESS	Form-of-Address Key	AD_TITLE	CHAR	4
BUSINESSPARTNERNAME1	Name 1	AD_NAME1	CHAR	40
BUSINESSPARTNERNAME2	Name 2	AD_NAME2	CHAR	40
NATION	Version ID for International Addresses	AD_NATION	CHAR	1
PHONENUMBER	Phone Number: Area Code+Number	CAADDR_PHONENR	CHAR	30
FAXNUMBER	First Fax No.: Area Code + Number	AD_FXNMBR1	CHAR	30
SEARCHTERM1	Search Term 1	AD_SORT1	CHAR	20
STREETSEARCH	Street Name in Uppercase for Search Help	AD_MC_STRT	CHAR	25
CITYSEARCH	City name in Uppercase for Search Help	AD_MC_CITY	CHAR	25
BUSINESSPARTNERNAME3	Name 3	AD_NAME3	CHAR	40
BUSINESSPARTNERNAME4	Name 4	AD_NAME4	CHAR	40
TAXJURISDICTION	Tax Jurisdiction	AD_TXJCD	CHAR	15
TRANSPORTZONE	Transportation zone to or from which the goods are delivered	LZONE	CHAR	10
PERSON	Person Number	AD_PERSNUM	CHAR	10
ADDRESSTYPE	Address type (1=Organization, 2=Person, 3=Contact person)	AD_ADRTYPE	CHAR	1
ADDRESSOWNEROBJECTID	Address owner object ID	AD_OBJKEY	CHAR	70
ADDRESSISCHANGEDMANUALLY	Boolean Variable (X = True, - = False, Space = Unknown)	BOOLEAN	CHAR	1
ACTIVEADDRESSID	Address Number	AD_ADDRNUM	CHAR	10
ACTIVEADDRESSISMANUAL	Boolean Variable (X = True, - = False, Space = Unknown)	BOOLEAN	CHAR	1
ADDRESSOWNERTABLENAME	Application table logical name (address management)	AD_APPLTAB	CHAR	10
ADDRESSOWNERREFERENCEFIELDNAME	Application table address where-used list logical field name	AD_APPLFLD	CHAR	10
ADDRESSOWNERMANUALFIELDNAME	Application table address where-used list logical field name	AD_APPLFLD	CHAR	10
REFERENCEADDRESSID	Address Number	AD_ADDRNUM	CHAR	10
REFERENCEOBJECTID	Address owner object ID	AD_OBJKEY	CHAR	70
REFERENCEADDRESSTYPE	Address Type	CAADDR_E_TYPE	CHAR	2
EMAILADDRESS	SMTP Address	CAADDR_SMTPADR	CHAR	241
HASACTIVEENTITY	Draft - Indicator - Has active document	SDRAFT_HAS_ACTIVE	CHAR	1
DRAFTENTITYCREATIONDATETIME	Draft Created On	SDRAFT_CREATED_AT	DEC	21
DRAFTENTITYLASTCHANGEDATETIME	Draft Last Changed On	SDRAFT_LAST_CHANGED_AT	DEC	21
DRAFTADMINISTRATIVEDATAUUID	Technical ID for the Administrative Data of a Draft Document	SDRAFT_ADMIN_UUID	RAW	16
DRAFTENTITYCONSISTENCYSTATUS	Draft Consistency Status	SDRAFT_CONSISTENCY_STATUS	CHAR	1
DRAFTENTITYOPERATIONCODE	Draft - Operation Code	SDRAFT_OPERATION_CODE	CHAR	1

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ADDR_D

SAP ADDR_D I_ADDRESSTP I_ADDRESSTP Table

Overview

Techincal Settings of ADDR_D

List of ADDR_D Fields

Foreign Key Relationships

Other References