BWE_ADDR1 SAP (Extractor Structure for BW (BWE_ADDRK1 + BWE_ADRC)) Structure details

Dictionary Type: Structure
Description: Extractor Structure for BW (BWE_ADDRK1 + BWE_ADRC)




ABAP Code to SELECT data from BWE_ADDR1
Related tables to BWE_ADDR1
Access table BWE_ADDR1




Structure field list including key, data, relationships and ABAP select examples

BWE_ADDR1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Extractor Structure for BW (BWE_ADDRK1 + BWE_ADRC)" 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_BWE_ADDR1 TYPE BWE_ADDR1.

The BWE_ADDR1 table consists of various fields, each holding specific information or linking keys about Extractor Structure for BW (BWE_ADDRK1 + BWE_ADRC) data available in SAP. These include OBJKEY (Address owner object ID), EXTENSION (Object key), CONTEXT (Semantic description of an object address), ADDRNUMBER (Address number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP BWE_ADDR1 structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
OBJKEYAddress owner object ID AD_OBJKEYCHAR70SWO_TYPEID
EXTENSIONObject key SWO_TYPEIDCHAR70SWO_TYPEID
CONTEXTSemantic description of an object address AD_CONTEXTNUMC4AD_CONTEXT
ADDRNUMBERAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
DATE_FROMValid-from date - in current Release only 00010101 possible AD_DATE_FRDATS8DATUM
NATIONVersion ID for International Addresses AD_NATIONCHAR1Assigned to domainAD_NATIONADDRESS_NATION
DATE_TOValid-to date in current Release only 99991231 possible AD_DATE_TODATS8DATUM
TITLEForm-of-Address Key AD_TITLECHAR4Assigned to domainAD_TITLE
NAME1Name 1 AD_NAME1CHAR40TEXT40
NAME2Name 2 AD_NAME2CHAR40TEXT40
NAME3Name 3 AD_NAME3CHAR40TEXT40
NAME4Name 4 AD_NAME4CHAR40TEXT40
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12Assigned to domainALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8Assigned to domainALPHACITYP_CODE
HOME_CITYCity (Different from Postal City) PI_AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent City Coding for City/Street File PI_AD_CITYHNMCHAR12Assigned to domainALPHACITY_CODE
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8Assigned to domainREGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12Assigned to domainALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3Assigned to domainREGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3Assigned to domainLAND1
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10Assigned to domainZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12Assigned to domainALPHASTRT_CODE
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
PERS_ADDRFlag: This is a personal address AD_PRSADDRCHAR1XFELD
SORT1Search Term 1 AD_SORT1CHAR20CHAR20
SORT2Search Term 2 AD_SORT2CHAR20CHAR20
TEL_NUMBERFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL_EXTENSFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
FAX_NUMBERFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
FAX_EXTENSFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6Assigned to domainTZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
SMTP_ADDRE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
URI_ADDRURI Field for Transfer to BW PI_AD_URICHAR60PI_AD_URI
TELDISPLAYDisplay Format for Telephone Number PI_AD_TELDCHAR30PI_AD_DISP
FAXDISPLAYDisplay Format for Fax Number PI_AD_FAXDCHAR30PI_AD_DISP

Key field Non-key field



How do I retrieve data from SAP structure BWE_ADDR1 using ABAP code?

As BWE_ADDR1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BWE_ADDR1 as there is no data to select.

How to access SAP table BWE_ADDR1

Within an ECC or HANA version of SAP you can also view further information about BWE_ADDR1 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!