SAP ABAP Table FSBP_BUT020_IPI (Addresses in IPI Format)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ FS-BP (Application Component) Business Partner
     ⤷ FS_BP_AL_CENTRAL_DATA (Package) Application Logic: General Data

Basic Data

Table Category	INTTAB	Structure
Structure	FSBP_BUT020_IPI	Table Relationship Diagram
Short Description	Addresses in IPI Format

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	PARTNER_UUID	☑	BU_PARTNER_GUID_BAPI	SYSUUID_C	CHAR	32	0	GUID of a Business Partner in CHAR 32 Format for BAPIs
2	PARTNER	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	ADDRESS_ID	☑	ADDR_NODE_ID	ADDR_NODE_ID	CHAR	70	0	Node Id as in the ESA-model
4	VALID_FROM	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
5	VALID_TO	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
6	ADDRESS_GUID	☐	BU_ADDRESS_GUID	SYSUUID	RAW	16	0	GUID of a Business Partner Address
7	ADDRNUMBER	☐	AD_NUMBER	CHAR10	CHAR	10	0	Address or Person Number (10 Character BAS Key)
8	MOVE_ADDR_ID	☐	ADDR_NODE_ID	ADDR_NODE_ID	CHAR	70	0	Node Id as in the ESA-model
9	MOVE_DATE	☐	BU_MOVEDAT	DATUM	DATS	8	0	Date of Move
10	ADEXT	☐	BU_ADEXT	BU_ADEXT	CHAR	20	0	Address number in external system
11	ADDRHANDLE	☐	AD_HANDLE	TEXT140	CHAR	140	0	Handle for Creating Addresses/Persons (Bus. Addr. Services)
12	LOCATION	☐	ADDRS_LOCATION		STRU	0	0
13	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
14	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
15	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
16	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file
17	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file
18	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
19	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file
20	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
21	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping
22	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
23	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
24	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
25	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
26	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag
27	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
28	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
29	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)
30	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)
31	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country
32	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
33	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
34	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag
35	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File
36	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
37	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
38	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
39	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
40	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
41	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
42	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
43	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
44	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
45	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
46	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
47	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone
48	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
49	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
50	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
51	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
52	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
53	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
54	NOTES	☐	ADDRT_NOTE		TTYP	0	0
55	WORKPLACE	☐	ADDRS_WORKPLACE		STRU	0	0
56	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
57	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
58	BUILDING	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
59	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
60	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
61	ID_CODE	☐	AD_ID_CODE	TEXT10	CHAR	10	0	Short name for correspondence
62	IH_MAIL	☐	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
63	COMMDATA	☐	ADDRS_COMMUNICATION_DATA		STRU	0	0
64	TELEPHONE	☐	ADDRT_TELEPHONE_NUMBER		TTYP	0	0
65	FACSIMILE	☐	ADDRT_FACSIMILE_NUMBER		TTYP	0	0
66	EMAIL	☐	ADDRT_EMAIL_ADDRESS		TTYP	0	0
67	WEB	☐	ADDRT_WEB_ADDRESS		TTYP	0	0
68	TELEX	☐	ADDRT_TELEX_NUMBER		TTYP	0	0
69	TELETEX	☐	ADDRT_TELETEX_NUMBER		TTYP	0	0
70	RML	☐	ADDRT_REMOTE_MAIL_ADDRESS		TTYP	0	0
71	X400	☐	ADDRT_X400_ADDRESS		TTYP	0	0
72	PRINTER	☐	ADDRT_PRINTER		TTYP	0	0
73	SSF	☐	ADDRT_SSF_ADDRESS		TTYP	0	0
74	PAGER	☐	ADDRT_PAGER_NUMBER		TTYP	0	0
75	COMMUNICATION_PREFERENCE	☐	ADDRS_COMMUNICATION_PREFERENCE		STRU	0	0
76	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key
77	DEFLT_COMM	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)

History

Last changed by/on	SAP	20141013
SAP Release Created in	710