SAP TABLES | Basis Components | Basis Services / Communication Interfaces | Address Management/Business Address(BC-SRV-ADR) SAP BC

ADDR1_VAL SAP Address return structure Structure and data







ADDR1_VAL is an SAP Structure so does not store data like a database table does but can be used to process "Address return structure" Information within sap ABAP programs. This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_ADDR1_VAL TYPE ADDR1_VAL .

Below is the documentation avaialable and full details of the fields which make up this Structure.

You can view further information about this via relevant transactions such as SE11 or SE80. Also check out the Comments section below to view or add related contributions and example screen shots.



Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP ADDR1_VAL Structure fields within data Dictionary




Field
Component Type
Data Typelength (Decimals)Check tableDescriptionConversion Routine
.INCLUDEADDR1_SELAddress selection parameter
ADDRNUMBERAD_ADDRNUMCHAR10
*
Address numberALPHA
ADDRHANDLEAD_HANDLECHAR140Handle for Creating Addresses/Persons (Bus. Addr. Services)
NATIONAD_NATIONCHAR1
*
Version ID for International Addresses
DATEAD_DATEDATS8Date referred to
.INCLUDEADDR1_DATAAddress transfer structure
DATE_FROMAD_DATE_FRDATS8Valid-from date - in current Release only 00010101 possible
DATE_TOAD_DATE_TODATS8Valid-to date in current Release only 99991231 possible
.INCLUDEADNM_STRUCInclude structure with name attributes of the ADRC address
TITLEAD_TITLECHAR4TSAD3Form-of-Address Key
NAME1AD_NAME1CHAR40Name 1
NAME2AD_NAME2CHAR40Name 2
NAME3AD_NAME3CHAR40Name 3
NAME4AD_NAME4CHAR40Name 4
NAME_TXTAD_NAMETXTCHAR50Converted name field (with form of address)
.INCLUDEADRC_STRUCInclude structure with ADRC attributes without name fields
NAME_COAD_NAME_COCHAR40c/o name
CITY1AD_CITY1CHAR40City
CITY2AD_CITY2CHAR40District
CITY_CODEAD_CITYNUMCHAR12ADRCITYCity code for city/street fileALPHA
CITYP_CODEAD_CITYPNMCHAR8ADRCITYPRTDistrict code for City and Street fileALPHA
HOME_CITYAD_CITY3CHAR40City (different from postal city)
CITYH_CODEAD_CITYHNMCHAR12ADRCITYDifferent city for city/street fileALPHA
CHCKSTATUSAD_CHECKSTCHAR1City file test status
REGIOGROUPREGIOGROUPCHAR8ADRREGGRPRegional structure grouping
POST_CODE1AD_PSTCD1CHAR10City postal code
POST_CODE2AD_PSTCD2CHAR10PO Box Postal Code
POST_CODE3AD_PSTCD3CHAR10Company Postal Code (for Large Customers)
PCODE1_EXTAD_PST1XTCHAR10(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
PCODE2_EXTAD_PST2XTCHAR10(Not Supported) PO Box Postal Code Extension
PCODE3_EXTAD_PST3XTCHAR10(Not Supported) Major Customer Postal Code Extension
PO_BOXAD_POBXCHAR10PO Box
DONT_USE_PAD_NO_USEPCHAR4TSAD12PO Box Address Undeliverable Flag
PO_BOX_NUMAD_POBXNUMCHAR1Flag: PO Box Without Number
PO_BOX_LOCAD_POBXLOCCHAR40PO Box city
CITY_CODE2AD_CIT2NUMCHAR12ADRCITYCity PO box code (City file)ALPHA
PO_BOX_REGAD_POBXREGCHAR3T005SRegion for PO Box (Country, State, Province, ...)
PO_BOX_CTYAD_POBXCTYCHAR3T005PO box country
POSTALAREAAD_PSTLARCHAR15(Not Supported) Post Delivery District
TRANSPZONELZONECHAR10TZONETransportation zone to or from which the goods are delivered

STREETAD_STREETCHAR60Street
DONT_USE_SAD_NO_USESCHAR4TSAD12Street Address Undeliverable Flag
STREETCODEAD_STRNUMCHAR12ADRSTREETStreet Number for City/Street FileALPHA
STREETABBRAD_STRABBRCHAR2ADRSTRTYPE(Not Supported) Abbreviation of Street Name
HOUSE_NUM1AD_HSNM1CHAR10House Number
HOUSE_NUM2AD_HSNM2CHAR10House number supplement
HOUSE_NUM3AD_HSNM3CHAR10(Not supported) House Number Range
STR_SUPPL1AD_STRSPP1CHAR40Street 2
STR_SUPPL2AD_STRSPP2CHAR40Street 3
STR_SUPPL3AD_STRSPP3CHAR40Street 4
LOCATIONAD_LCTNCHAR40Street 5
BUILDINGAD_BLDNGCHAR20Building (Number or Code)
FLOORAD_FLOORCHAR10Floor in building
ROOMNUMBERAD_ROOMNUMCHAR10Room or Appartment Number
COUNTRYLAND1CHAR3T005Country Key
LANGUSPRASLANG1T002Language KeyISOLA
REGIONREGIOCHAR3T005SRegion (State, Province, County)
SORT1AD_SORT1ULCHAR20Search Term 1
SORT2AD_SORT2ULCHAR20Search Term 2
SORT_PHNAD_SRTPHNCHAR20(Not Supported) Phonetic Search Sort Field
ADDRORIGINAD_ORIGINACHAR4TSAD6(Not Supported) Address Data Source (Key)
EXTENSION1AD_EXTENS1CHAR40Extension (only for data conversion) (e.g. data line)
EXTENSION2AD_EXTENS2CHAR40Extension (only for data conversion) (e.g. telebox)
TIME_ZONEAD_TZONECHAR6TTZZAddress time zone
TAXJURCODEAD_TXJCDCHAR15Tax Jurisdiction
ADDRESS_IDAD_ADDR_IDCHAR10(Not supported) Physical address IDALPHA
REMARKAD_REMARK1CHAR50Address notes
LANGU_CREAAD_LANGUCRLANG1T002Address record creation original languageISOLA
PO_BOX_LOBBYAD_PO_BOX_LBYCHAR40PO Box Lobby
DELI_SERV_TYPEAD_DELIVERY_SERVICE_TYPECHAR4ADDRC_DELI_SERVType of Delivery Service
DELI_SERV_NUMBERAD_DELIVERY_SERVICE_NUMBERCHAR10Number of Delivery Service
COUNTY_CODEAD_CNTYNUMCHAR8ADRCOUNTYCounty code for countyALPHA
COUNTYAD_COUNTYCHAR40County
TOWNSHIP_CODEAD_TWSHPNUMCHAR8ADRTOWNSHIPTownship code for TownshipALPHA
TOWNSHIPAD_TOWNSHIPCHAR40Township
DEFLT_COMMAD_COMMCHAR3TSACCommunication Method (Key) (Business Address Services)
TEL_EXTENSAD_TLXTNS1CHAR10First Telephone No.: Extension
FAX_NUMBERAD_FXNMBR1CHAR30First fax no.: dialling code+number
FAX_EXTENSAD_FXXTNS1CHAR10First fax no.: extension
ADDR_GROUPAD_GROUPCHAR4
*
Address Group (Key) (Business Address Services)



Key field
Non-key field

ADDR1_VAL relationships with other tables


KNA1-General Data in Customer Master
     ADDR1_VAL-Address Data
     KNAS-Customer Master (VAT Registration Nos Gen. Sel.)
     KNKA-Customer Master Credit Management: Central Data
     KNKK-Credit Management Cust. Mstr: Control Area Data
     KNBK-Customer Master (Bank Details)
     KNB1-Customer Master (Company Code)
          KNB4-Customer Payment History
          KNB5-Customer Master (Dunning Data)
          KNC1-Customer Master (Transaction Figures)
          KNC3-Customer Master (Special G/L Transaction Figures)
          BSID-Accounting: Secondary Index for Customers
               ADMI_FILES-Archive Files
               BSIDEXT-Secondary Index & Additions Section (bsega)
               BKPF-Accounting Document Header
                    BSEG-Accounting Document Segment
                         WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
                         GSEG-Offsetting Items for B-Segment in Reporting


LFA1-Vendor Master (General Section)
     ADDR1_VAL-Address Data
     LFAS-Vendor Master (General Part EU Tax Number)
     LFBK-Vendor Master (Bank Details)
     LFB1-Vendor Master (Company Code)
          LFB5-Vendor Master (Dunning Data)
          LFC1-Vendor Master (Transaction Figures)
          LFC3-Vendor Master (Transaction Figures) Special Ledger
          BSIK-Accounting: Secondary Index for Vendors
               ADMI_FILES-Archive Files
               BSIKEXT-Secondary Index & Additions Section (BSEGA)
               BKPF-Accounting Document Header
                    BSEG-Accounting Document Segment
                         WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
                         GSEG-Offsetting Items for B-Segment in Reporting