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