SAP Table ANLAV_ADDR stores Address Data for Asset on the Report Datedata

  

In this post, I will try and describe everything you need to know about the SAP anlav_addr table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for ANLAV_ADDR what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from ANLAV_ADDR....Right lets get started!


SAP ANLAV_ADDR dictionary attributes

Object Name: ANLAV_ADDR
Dictionary Type: Structure
Description: Address Data for Asset on the Report Date


ANLAV_ADDR field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
DATE_FROMAD_DATE_FRDATS8(0) Valid-from date - in current Release only 00010101 possibleDATUM
DATE_TOAD_DATE_TODATS8(0) Valid-to date in current Release only 99991231 possibleDATUM
TITLEAD_TITLECHAR4(0) TSAD3Form-of-Address KeyAD_TITLE
NAME1AD_NAME1CHAR40(0) Name 1TEXT40
NAME2AD_NAME2CHAR40(0) Name 2TEXT40
NAME3AD_NAME3CHAR40(0) Name 3TEXT40
NAME4AD_NAME4CHAR40(0) Name 4TEXT40
NAME_TXTAD_NAMETXTCHAR50(0) Converted name field (with form of address)TEXT50
NAME_COAD_NAME_COCHAR40(0) c/o nameTEXT40
CITY1AD_CITY1CHAR40(0) CityTEXT40CLCITYNAMECITY_NAME
CITY2AD_CITY2CHAR40(0) DistrictTEXT40CITY_PARTCITY_PART
CITY_CODEAD_CITYNUMCHAR12(0) ADRCITYCity code for city/street fileCITY_CODE
CITYP_CODEAD_CITYPNMCHAR8(0) ADRCITYPRTDistrict code for City and Street fileCITYP_CODE
HOME_CITYAD_CITY3CHAR40(0) City (different from postal city)TEXT40
CITYH_CODEAD_CITYHNMCHAR12(0) ADRCITYDifferent city for city/street fileCITY_CODE
CHCKSTATUSAD_CHECKSTCHAR1(0) City file test statusAD_CHECKST
REGIOGROUPREGIOGROUPCHAR8(0) ADRREGGRPRegional structure groupingREGIOGROUP
POST_CODE1AD_PSTCD1CHAR10(0) City postal codeCHAR10
POST_CODE2AD_PSTCD2CHAR10(0) PO Box Postal CodeCHAR10
POST_CODE3AD_PSTCD3CHAR10(0) Company Postal Code (for Large Customers)CHAR10
PCODE1_EXTAD_PST1XTCHAR10(0) (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 CodeCHAR10
PCODE2_EXTAD_PST2XTCHAR10(0) (Not Supported) PO Box Postal Code ExtensionCHAR10
PCODE3_EXTAD_PST3XTCHAR10(0) (Not Supported) Major Customer Postal Code ExtensionCHAR10
PO_BOXAD_POBXCHAR10(0) PO BoxCHAR10
DONT_USE_PAD_NO_USEPCHAR4(0) TSAD12PO Box Address Undeliverable FlagAD_NO_USE
PO_BOX_NUMAD_POBXNUMCHAR1(0) Flag: PO Box Without NumberXFELD
PO_BOX_LOCAD_POBXLOCCHAR40(0) PO Box cityTEXT40CITY_NAMECITY_NAME
CITY_CODE2AD_CIT2NUMCHAR12(0) ADRCITYCity PO box code (City file)CITY_CODE
PO_BOX_REGAD_POBXREGCHAR3(0) T005SRegion for PO Box (Country, State, Province, ...)REGIO
PO_BOX_CTYAD_POBXCTYCHAR3(0) T005PO box countryLAND1
POSTALAREAAD_PSTLARCHAR15(0) (Not Supported) Post Delivery DistrictTEXT15
TRANSPZONELZONECHAR10(0) TZONETransportation zone to or from which the goods are deliveredZONEVV
STREETAD_STREETCHAR60(0) StreetTEXT60CLSTRTNAMESTREET
DONT_USE_SAD_NO_USESCHAR4(0) TSAD12Street Address Undeliverable FlagAD_NO_USE
STREETCODEAD_STRNUMCHAR12(0) ADRSTREETStreet Number for City/Street FileSTRT_CODE
STREETABBRAD_STRABBRCHAR2(0) ADRSTRTYPE(Not Supported) Abbreviation of Street NameSTRTYPEAB
HOUSE_NUM1AD_HSNM1CHAR10(0) House NumberTEXT10
HOUSE_NUM2AD_HSNM2CHAR10(0) House number supplementTEXT10
HOUSE_NUM3AD_HSNM3CHAR10(0) (Not supported) House Number RangeTEXT10
STR_SUPPL1AD_STRSPP1CHAR40(0) Street 2TEXT40
STR_SUPPL2AD_STRSPP2CHAR40(0) Street 3TEXT40
STR_SUPPL3AD_STRSPP3CHAR40(0) Street 4TEXT40
LOCATIONAD_LCTNCHAR40(0) Street 5TEXT40
BUILDINGAD_BLDNGCHAR20(0) Building (Number or Code)TEXT20
FLOORAD_FLOORCHAR10(0) Floor in buildingTEXT10
ROOMNUMBERAD_ROOMNUMCHAR10(0) Room or Appartment NumberTEXT10
COUNTRYLAND1CHAR3(0) T005Country KeyLAND1LNDFB
LANGUSPRASLANG1(0) T002Language KeySPRASSPRSAPH_T002SPRAS
REGIONREGIOCHAR3(0) T005SSTATE (State, Province, County)REGIOFB
SORT1AD_SORT1ULCHAR20(0) Search Term 1TEXT20
SORT2AD_SORT2ULCHAR20(0) Search Term 2TEXT20
SORT_PHNAD_SRTPHNCHAR20(0) (Not Supported) Phonetic Search Sort FieldCHAR20
ADDRORIGINAD_ORIGINACHAR4(0) TSAD6(Not Supported) Address Data Source (Key)AD_ORIGIN
EXTENSION1AD_EXTENS1CHAR40(0) Extension (only for data conversion) (e.g. data line)TEXT40
EXTENSION2AD_EXTENS2CHAR40(0) Extension (only for data conversion) (e.g. telebox)TEXT40
TIME_ZONEAD_TZONECHAR6(0) TTZZAddress time zoneTZNZONE
TAXJURCODEAD_TXJCDCHAR15(0) Tax JurisdictionAD_TXJCDTXJ
ADDRESS_IDAD_ADDR_IDCHAR10(0) (Not supported) Physical address IDAD_ADDR_ID
REMARKAD_REMARK1CHAR50(0) Address notesTEXT50
LANGU_CREAAD_LANGUCRLANG1(0) T002Address record creation original languageSPRAS
PO_BOX_LOBBYAD_PO_BOX_LBYCHAR40(0) PO Box LobbyTEXT40
DELI_SERV_TYPEAD_DELIVERY_SERVICE_TYPECHAR4(0) ADDRC_DELI_SERVType of Delivery ServiceAD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERAD_DELIVERY_SERVICE_NUMBERCHAR10(0) Number of Delivery ServiceCHAR10
COUNTY_CODEAD_CNTYNUMCHAR8(0) ADRCOUNTYCounty code for countyCNTY_CODE
COUNTYAD_COUNTYCHAR40(0) CountyTEXT40CLTCNTYNAMECOUNTY
TOWNSHIP_CODEAD_TWSHPNUMCHAR8(0) ADRTOWNSHIPTownship code for TownshipTWSHP_CODE
TOWNSHIPAD_TOWNSHIPCHAR40(0) TownshipTEXT40CLTWSHPNAMETOWNSHIP
DEFLT_COMMAD_COMMCHAR3(0) TSACCommunication Method (Key) (Business Address Services)AD_COMM