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

ADDR1_VAL SAP Address return structure Structure








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


Dictionary fields for SAP Structure ADDR1_VAL




Field
Component Type
Data Typelength (Decimals)Check tableDescriptionConversion Routine
.INCLUDEADDR1_SEL Address selection parameter
ADDRNUMBERAD_ADDRNUMCHAR10
*
Address numberALPHA
ADDRHANDLEAD_HANDLECHAR140 Handle for Creating Addresses/Persons (Bus. Addr. Services)
NATIONAD_NATIONCHAR1
*
Version ID for International Addresses
DATEAD_DATEDATS8 Date referred to
.INCLUDEADDR1_DATA Address transfer structure
DATE_FROMAD_DATE_FRDATS8 Valid-from date - in current Release only 00010101 possible
DATE_TOAD_DATE_TODATS8 Valid-to date in current Release only 99991231 possible
.INCLUDEADNM_STRUC Include structure with name attributes of the ADRC address
TITLEAD_TITLECHAR4 TSAD3Form-of-Address Key
NAME1AD_NAME1CHAR40 Name 1
NAME2AD_NAME2CHAR40 Name 2
NAME3AD_NAME3CHAR40 Name 3
NAME4AD_NAME4CHAR40 Name 4
NAME_TXTAD_NAMETXTCHAR50 Converted name field (with form of address)
.INCLUDEADRC_STRUC Include structure with ADRC attributes without name fields
NAME_COAD_NAME_COCHAR40 c/o name
CITY1AD_CITY1CHAR40 City
CITY2AD_CITY2CHAR40 District
CITY_CODEAD_CITYNUMCHAR12 ADRCITYCity code for city/street fileALPHA
CITYP_CODEAD_CITYPNMCHAR8 ADRCITYPRTDistrict code for City and Street fileALPHA
HOME_CITYAD_CITY3CHAR40 City (different from postal city)
CITYH_CODEAD_CITYHNMCHAR12 ADRCITYDifferent city for city/street fileALPHA
CHCKSTATUSAD_CHECKSTCHAR1 City file test status
REGIOGROUPREGIOGROUPCHAR8 ADRREGGRPRegional structure grouping
POST_CODE1AD_PSTCD1CHAR10 City postal code
POST_CODE2AD_PSTCD2CHAR10 PO Box Postal Code
POST_CODE3AD_PSTCD3CHAR10 Company 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_POBXCHAR10 PO Box
DONT_USE_PAD_NO_USEPCHAR4 TSAD12PO Box Address Undeliverable Flag
PO_BOX_NUMAD_POBXNUMCHAR1 Flag: PO Box Without Number
PO_BOX_LOCAD_POBXLOCCHAR40 PO Box city
CITY_CODE2AD_CIT2NUMCHAR12 ADRCITYCity PO box code (City file)ALPHA
PO_BOX_REGAD_POBXREGCHAR3 T005SRegion for PO Box (Country, State, Province, ...)
PO_BOX_CTYAD_POBXCTYCHAR3 T005PO box country
POSTALAREAAD_PSTLARCHAR15 (Not Supported) Post Delivery District
TRANSPZONELZONECHAR10 TZONETransportation zone to or from which the goods are delivered

STREETAD_STREETCHAR60 Street
DONT_USE_SAD_NO_USESCHAR4 TSAD12Street Address Undeliverable Flag
STREETCODEAD_STRNUMCHAR12 ADRSTREETStreet Number for City/Street FileALPHA
STREETABBRAD_STRABBRCHAR2 ADRSTRTYPE(Not Supported) Abbreviation of Street Name
HOUSE_NUM1AD_HSNM1CHAR10 House Number
HOUSE_NUM2AD_HSNM2CHAR10 House number supplement
HOUSE_NUM3AD_HSNM3CHAR10 (Not supported) House Number Range
STR_SUPPL1AD_STRSPP1CHAR40 Street 2
STR_SUPPL2AD_STRSPP2CHAR40 Street 3
STR_SUPPL3AD_STRSPP3CHAR40 Street 4
LOCATIONAD_LCTNCHAR40 Street 5
BUILDINGAD_BLDNGCHAR20 Building (Number or Code)
FLOORAD_FLOORCHAR10 Floor in building
ROOMNUMBERAD_ROOMNUMCHAR10 Room or Appartment Number
COUNTRYLAND1CHAR3 T005Country Key
LANGUSPRASLANG1 T002Language KeyISOLA
REGIONREGIOCHAR3 T005SRegion (State, Province, County)
SORT1AD_SORT1ULCHAR20 Search Term 1
SORT2AD_SORT2ULCHAR20 Search Term 2
SORT_PHNAD_SRTPHNCHAR20 (Not Supported) Phonetic Search Sort Field
ADDRORIGINAD_ORIGINACHAR4 TSAD6(Not Supported) Address Data Source (Key)
EXTENSION1AD_EXTENS1CHAR40 Extension (only for data conversion) (e.g. data line)
EXTENSION2AD_EXTENS2CHAR40 Extension (only for data conversion) (e.g. telebox)
TIME_ZONEAD_TZONECHAR6 TTZZAddress time zone
TAXJURCODEAD_TXJCDCHAR15 Tax Jurisdiction
ADDRESS_IDAD_ADDR_IDCHAR10 (Not supported) Physical address IDALPHA
REMARKAD_REMARK1CHAR50 Address notes
LANGU_CREAAD_LANGUCRLANG1 T002Address record creation original languageISOLA
PO_BOX_LOBBYAD_PO_BOX_LBYCHAR40 PO Box Lobby
DELI_SERV_TYPEAD_DELIVERY_SERVICE_TYPECHAR4 ADDRC_DELI_SERVType of Delivery Service
DELI_SERV_NUMBERAD_DELIVERY_SERVICE_NUMBERCHAR10 Number of Delivery Service
COUNTY_CODEAD_CNTYNUMCHAR8 ADRCOUNTYCounty code for countyALPHA
COUNTYAD_COUNTYCHAR40 County
TOWNSHIP_CODEAD_TWSHPNUMCHAR8 ADRTOWNSHIPTownship code for TownshipALPHA
TOWNSHIPAD_TOWNSHIPCHAR40 Township
DEFLT_COMMAD_COMMCHAR3 TSACCommunication Method (Key) (Business Address Services)
TEL_EXTENSAD_TLXTNS1CHAR10 First Telephone No.: Extension
FAX_NUMBERAD_FXNMBR1CHAR30 First fax no.: dialling code+number
FAX_EXTENSAD_FXXTNS1CHAR10 First fax no.: extension
ADDR_GROUPAD_GROUPCHAR4
*
Address Group (Key) (Business Address Services)



Key field
Non-key field


RELATIONS BETWEEN ADDR1_VAL AND 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