SAP ABAP Table BUS_PARTNER_ADDRESS_BW (SAP BP: Extract Structure Standard Address Business Partner)
Hierarchy
☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ AP-MD-BP (Application Component) SAP Business Partner
     ⤷ BUPA_ADDRESS_BW (Package) SAP BP: Extraction BW Partner Address
Basic Data
Table Category INTTAB    Structure 
Structure BUS_PARTNER_ADDRESS_BW   Table Relationship Diagram
Short Description SAP BP: Extract Structure Standard Address Business Partner    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   SAP BP: Extraction SAP BW Key Fields  
2 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
3 PARTNER_GUID BU_PARTNER_GUID SYSUUID RAW 16   0   Business Partner GUID  
4 .INCLUDE       0   0   SAP BP: Extraction SAP BW Validity Interval  
5 VALID_FROM BU_BP_VALID_FROM TZNTSTMPS DEC 15   0   Validity Start BUT000 BP Data  
6 VALID_TO BU_BP_VALID_TO TZNTSTMPS DEC 15   0   Validity End BUT000 BP Data  
7 TD_SWITCH BU_TD_SWITCH CHAR1 CHAR 1   0   Planned Change Documents for Partner Were Converted  
8 .INCLUDE       0   0   SAP BP: Name Fields for Address Format  
9 TYPE BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
10 PERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
11 NAME_ORG1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
12 NAME_ORG2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
13 NAME_ORG3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
14 NAME_ORG4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
15 NAME_LAST BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
16 NAME_FIRST BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
17 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key *
18 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) *
19 TITLE_ROYL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) *
20 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) *
21 NAME_GRP1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
22 NAME_GRP2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
23 .INCLUDE       0   0   Extractor Structure for BW  
24 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
25 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
26 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses *
27 DATE_TO AD_DATE_TO DATUM DATS 8   0   Valid-to date in current Release only 99991231 possible  
28 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key *
29 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
30 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
31 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
32 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
33 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
34 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
35 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
36 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file *
37 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file *
38 HOME_CITY PI_AD_CITY3 TEXT40 CHAR 40   0   City (Different from Postal City)  
39 CITYH_CODE PI_AD_CITYHNM CITY_CODE CHAR 12   0   Different City Coding for City/Street File *
40 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping *
41 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
42 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
43 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
44 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
45 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
46 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
47 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) *
48 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) *
49 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country *
50 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered *
51 STREET AD_STREET TEXT60 CHAR 60   0   Street  
52 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File *
53 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
54 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
55 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
56 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
57 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
58 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
59 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
60 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
61 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
62 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
63 LANGU SPRAS SPRAS LANG 1   0   Language Key *
64 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
65 PERS_ADDR AD_PRSADDR XFELD CHAR 1   0   Flag: This is a personal address  
66 SORT1 AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
67 SORT2 AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
68 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
69 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
70 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
71 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
72 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
73 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
74 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone *
75 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
76 SMTP_ADDR AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
77 URI_ADDR PI_AD_URI PI_AD_URI CHAR 60   0   URI Field for Transfer to BW  
78 TELDISPLAY PI_AD_TELD PI_AD_DISP CHAR 30   0   Display Format for Telephone Number  
79 FAXDISPLAY PI_AD_FAXD PI_AD_DISP CHAR 30   0   Display Format for Fax Number  
80 .INCLUDE       0   0   BW Extraction: Geodata for Standard Address  
81 LONGITUDE GEOLON GEOLONLAT DEC 15   12   Geo location longitude  
82 LATITUDE GEOLAT GEOLONLAT DEC 15   12   Geo location latitude  
83 ALTITUDE GEOALT GEOALT DEC 9   3   Geo location height  
84 SRCID GEOSRCID CHAR4 CHAR 4   0   Geo location data source ID/Geocoder ID  
85 PRECISID GEOPRECIS D_GEOPREC NUMC 4   0   Precision (street, postal code, ...) of a Geo location  
86 ADDRCOMM BU_ADDRCOMM AD_ADDRNUM CHAR 10   0   Address Number *
87 .INCLUDE       0   0   SAP BP: Fields for Formatted Addresses  
88 ADDR_SHORT AD_LINE_S CHAR80 CHAR 80   0   One-line short form of formatted address  
89 ADDR_SHORT_S AD_LINE_S CHAR80 CHAR 80   0   One-line short form of formatted address  
90 LINE0 ADDR_LINE0_BW LINES CHAR 80   0   BP Address: Line 0  
91 LINE1 ADDR_LINE1_BW LINES CHAR 80   0   BP Address: Line 1  
92 LINE2 ADDR_LINE2_BW LINES CHAR 80   0   BP Address: Line 2  
93 LINE3 ADDR_LINE3_BW LINES CHAR 80   0   BP Address: Line 3  
94 LINE4 ADDR_LINE4_BW LINES CHAR 80   0   BP Address: Line 4  
95 LINE5 ADDR_LINE5_BW LINES CHAR 80   0   BP Address: Line 5  
96 LINE6 ADDR_LINE6_BW LINES CHAR 80   0   BP Address: Line 6  
97 LINE7 ADDR_LINE7_BW LINES CHAR 80   0   BP Address: Line 7  
98 LINE8 ADDR_LINE8_BW LINES CHAR 80   0   BP Address: Line 8  
99 LINE9 ADDR_LINE9_BW LINES CHAR 80   0   BP Address: Line 9  
100 .INCLUDE       0   0   SAP BP: SAP BW Administration Data  
101 DQ_ONLINE_UPDATE BU_DQ_ONLINE_UPD XFELD CHAR 1   0   SAP BP: Delta Queue Update Online  
102 DQ_OFFLINE_UPDATE BU_DQ_OFFLINE_UPD XFELD CHAR 1   0   SAP BP: Delta Queue Update Offline  
103 DQ_TIMESTAMP BU_DQ_TIMESTAMP TZNTSTMPS DEC 15   0   Delta Queue Update Time Stamp  
History
Last changed by/on SAP  20140117 
SAP Release Created in 2004_1_640