SAP ABAP Table FSBP_PXE_ADDRESS_DATA (Address with Change Information (After/Before))
Hierarchy
☛ SAP_BS_FND (Software Component) SAP Business Suite Foundation
   ⤷ FS-BP (Application Component) Business Partner
     ⤷ FS_BP_FND_PROXY_EVENTS (Package) Business Partner Events Using Proxy
Basic Data
Table Category INTTAB    Structure 
Structure FSBP_PXE_ADDRESS_DATA   Table Relationship Diagram
Short Description Address with Change Information (After/Before)    
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 ADDRESS_NUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
2 ADDRESS_GUID BU_ADDRESS_GUID SYSUUID RAW 16   0   GUID of a Business Partner Address  
3 MODIFICATION FSBP_PXE_MODIFICATION_CODE FSBP_PXE_MODIFICATION_CODE CHAR 1   0   Data Change ID for Events  
4 ADDR_MOVE_DATE BU_ADDR_MOVE_DATE TZNTSTMPS DEC 15   0   Date of Move for Address Moves  
5 MOVE_ADDR BU_MOVE_ADDR AD_ADDRNUM CHAR 10   0   Number of Move Target Address for Address Moves *
6 ADDR_VALID_FROM BU_ADDR_VALID_FROM TZNTSTMPS DEC 15   0   Validity Start of a Business Partner Address  
7 ADDR_VALID_TO BU_ADDR_VALID_TO TZNTSTMPS DEC 15   0   Validity End of a Business Partner Address  
8 PREVIOUS FSBP_PREVIOUS_ADDRESS_DATA   STRU 0   0    
9 ADDR_MOVE_DATE BU_ADDR_MOVE_DATE TZNTSTMPS DEC 15   0   Date of Move for Address Moves  
10 MOVE_ADDR BU_MOVE_ADDR AD_ADDRNUM CHAR 10   0   Number of Move Target Address for Address Moves  
11 ADDR_VALID_FROM BU_ADDR_VALID_FROM TZNTSTMPS DEC 15   0   Validity Start of a Business Partner Address  
12 ADDR_VALID_TO BU_ADDR_VALID_TO TZNTSTMPS DEC 15   0   Validity End of a Business Partner Address  
13 POSTAL_ADDRESS FSBP_PXE_POSTAL_ADDRESS   STRU 0   0    
14 .INCLUDE       0   0   Structure for Postal Address (After)  
15 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key  
16 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County)  
17 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
18 CITY_NO AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file  
19 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
20 LANGU SPRAS SPRAS LANG 1   0   Language Key  
21 HOMECITYNO AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file  
22 DISTRICT AD_CITY2 TEXT40 CHAR 40   0   District  
23 DISTRCT_NO AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file  
24 POSTL_COD1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
25 POSTL_COD2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
26 POSTL_COD3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
27 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
28 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
29 STREET AD_STREET TEXT60 CHAR 60   0   Street  
30 STR_ABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name  
31 STREET_NO AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File  
32 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
33 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
34 HOUSE_NO AD_HSNM1 TEXT10 CHAR 10   0   House Number  
35 HOUSE_NO2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
36 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
37 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
38 ROOM_NO AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
39 C_O_NAME AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
40 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag  
41 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping  
42 POBOX_CTRY AD_POBXCTY LAND1 CHAR 3   0   PO box country  
43 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...)  
44 PO_BOX_CIT AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
45 PBOXCIT_NO AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file)  
46 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
47 PO_W_O_NO AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
48 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag  
49 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
50 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone  
51 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
52 PREVIOUS FSBP_PXE_PREVIOUS_POSTAL_ADDR   STRU 0   0    
53 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key  
54 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County)  
55 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
56 CITY_NO AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file  
57 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
58 LANGU SPRAS SPRAS LANG 1   0   Language Key  
59 HOMECITYNO AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file  
60 DISTRICT AD_CITY2 TEXT40 CHAR 40   0   District  
61 DISTRCT_NO AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file  
62 POSTL_COD1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
63 POSTL_COD2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
64 POSTL_COD3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
65 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
66 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
67 STREET AD_STREET TEXT60 CHAR 60   0   Street  
68 STR_ABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name  
69 STREET_NO AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File  
70 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
71 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
72 HOUSE_NO AD_HSNM1 TEXT10 CHAR 10   0   House Number  
73 HOUSE_NO2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
74 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
75 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
76 ROOM_NO AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
77 C_O_NAME AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
78 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag  
79 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping  
80 POBOX_CTRY AD_POBXCTY LAND1 CHAR 3   0   PO box country  
81 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...)  
82 PO_BOX_CIT AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
83 PBOXCIT_NO AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file)  
84 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
85 PO_W_O_NO AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
86 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag  
87 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
88 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone  
89 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
90 TELEPHONE FSBP_PXE_TELEPHONE_TTY   TTYP 0   0    
91 FACSIMILE FSBP_PXE_FACSIMILE_TTY   TTYP 0   0    
92 EMAIL FSBP_PXE_EMAIL_TTY   TTYP 0   0    
93 WEB FSBP_PXE_WEB_TTY   TTYP 0   0    
94 ADDRESS_USAGE FSBP_PXE_ADDR_USAGE_TTY   TTYP 0   0    
History
Last changed by/on SAP  20130604 
SAP Release Created in 400