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 |