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".

Fields for table ADDR_D

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DRAFTUUIDUUID serving as key (parent key, root key)X/BOBF/UUIDRAW16
ADDRESSIDAddress NumberAD_ADDRNUMCHAR20
CAREOFNAMEc/o nameAD_NAME_COCHAR80
ADDITIONALSTREETSUFFIXNAMEStreet 5AD_LCTNCHAR80
CORRESPONDENCELANGUAGELanguage KeySPRASLANG2
PRFRDCOMMMEDIUMTYPECommunication Method (Key) (Business Address Services)AD_COMMCHAR6
POBOXPO BoxAD_POBXCHAR20
POBOXISWITHOUTNUMBERFlag: PO Box Without NumberAD_POBXNUMCHAR2
POBOXPOSTALCODEPO Box Postal CodeAD_PSTCD2CHAR20
POBOXLOBBYNAMEPO Box LobbyAD_PO_BOX_LBYCHAR80
POBOXDEVIATINGCITYNAMEPO Box cityAD_POBXLOCCHAR80
POBOXDEVIATINGREGIONRegion for PO Box (Country/Region, State, Province, ...)AD_POBXREGCHAR6
POBOXDEVIATINGCOUNTRYPO Box of Country/RegionAD_POBXCTYCHAR6
DELIVERYSERVICETYPECODEType of Delivery ServiceAD_DELIVERY_SERVICE_TYPECHAR8
DELIVERYSERVICENUMBERNumber of Delivery ServiceAD_DELIVERY_SERVICE_NUMBERCHAR20
ADDRESSTIMEZONEAddress time zoneAD_TZONECHAR12
FULLNAMEAddress Full NameCAADDR_FULLNAMECHAR160
CITYNAMECityAD_CITY1CHAR80
DISTRICTDistrictAD_CITY2CHAR80
CITYCODECity code for city/street fileAD_CITYNUMCHAR24
HOMECITYNAMECity (different from postal city)AD_CITY3CHAR80
POSTALCODECity postal codeAD_PSTCD1CHAR20
COMPANYPOSTALCODECompany Postal Code (for Large Customers)AD_PSTCD3CHAR20
STREETNAMEStreetAD_STREETCHAR120
STREETPREFIXNAMEStreet 2AD_STRSPP1CHAR80
ADDITIONALSTREETPREFIXNAMEStreet 3AD_STRSPP2CHAR80
STREETSUFFIXNAMEStreet 4AD_STRSPP3CHAR80
HOUSENUMBERHouse NumberAD_HSNM1CHAR20
HOUSENUMBERSUPPLEMENTTEXTHouse number supplementAD_HSNM2CHAR20
BUILDINGBuilding (Number or Code)AD_BLDNGCHAR40
FLOORFloor in buildingAD_FLOORCHAR20
ROOMNUMBERRoom or Apartment NumberAD_ROOMNUMCHAR20
COUNTRYCountry/RegionCAADDR_COUNTRYCHAR6
REGIONRegion (State, Province, County)REGIOCHAR6
COUNTYCountyAD_COUNTYCHAR80
COUNTYCODECounty code for countyAD_CNTYNUMCHAR16
FORMOFADDRESSForm-of-Address KeyAD_TITLECHAR8
BUSINESSPARTNERNAME1Name 1AD_NAME1CHAR80
BUSINESSPARTNERNAME2Name 2AD_NAME2CHAR80
NATIONVersion ID for International AddressesAD_NATIONCHAR2
PHONENUMBERPhone Number: Area Code+NumberCAADDR_PHONENRCHAR60
FAXNUMBERFirst Fax No.: Area Code + NumberAD_FXNMBR1CHAR60
SEARCHTERM1Search Term 1AD_SORT1CHAR40
STREETSEARCHStreet Name in Uppercase for Search HelpAD_MC_STRTCHAR50
CITYSEARCHCity name in Uppercase for Search HelpAD_MC_CITYCHAR50
BUSINESSPARTNERNAME3Name 3AD_NAME3CHAR80
BUSINESSPARTNERNAME4Name 4AD_NAME4CHAR80
TAXJURISDICTIONTax JurisdictionAD_TXJCDCHAR30
TRANSPORTZONETransportation zone to or from which the goods are deliveredLZONECHAR20
PERSONPerson NumberAD_PERSNUMCHAR20
ADDRESSTYPEAddress type (1=Organization, 2=Person, 3=Contact person)AD_ADRTYPECHAR2
ADDRESSOWNEROBJECTIDAddress owner object IDAD_OBJKEYCHAR140
ADDRESSISCHANGEDMANUALLYBoolean Variable (X = True, - = False, Space = Unknown)BOOLEANCHAR2
ACTIVEADDRESSIDAddress NumberAD_ADDRNUMCHAR20
ACTIVEADDRESSISMANUALBoolean Variable (X = True, - = False, Space = Unknown)BOOLEANCHAR2
ADDRESSOWNERTABLENAMEApplication table logical name (address management)AD_APPLTABCHAR20
ADDRESSOWNERREFERENCEFIELDNAMEApplication table address where-used list logical field nameAD_APPLFLDCHAR20
ADDRESSOWNERMANUALFIELDNAMEApplication table address where-used list logical field nameAD_APPLFLDCHAR20
REFERENCEADDRESSIDAddress NumberAD_ADDRNUMCHAR20
REFERENCEOBJECTIDAddress owner object IDAD_OBJKEYCHAR140
REFERENCEADDRESSTYPEAddress TypeCAADDR_E_TYPECHAR4
EMAILADDRESSSMTP AddressCAADDR_SMTPADRCHAR482
LASTCHANGEDATETIMELast Changed OnVDM_LASTCHANGEDONDEC11
HASACTIVEENTITYDraft - Indicator - Has active documentSDRAFT_HAS_ACTIVECHAR2
.INCLUDESDRAFT_WRITE_DRAFT_ADMIN0
DRAFTENTITYCREATIONDATETIMEDraft Created OnSDRAFT_CREATED_ATDEC11
DRAFTENTITYLASTCHANGEDATETIMEDraft Last Changed OnSDRAFT_LAST_CHANGED_ATDEC11
DRAFTADMINISTRATIVEDATAUUIDTechnical ID for the Administrative Data of a Draft DocumentSDRAFT_ADMIN_UUIDRAW16
DRAFTENTITYCONSISTENCYSTATUSDraft - Consistency StatusSDRAFT_CONSISTENCY_STATUSCHAR2
DRAFTENTITYOPERATIONCODEDraft - Operation CodeSDRAFT_OPERATION_CODECHAR2
Privacy Policy