SAP ABAP Table /BOFU/S_ADDR_POSTAL_ADDRESSI (Node structure for postal address data - internal)

Hierarchy

☛ SAP_BS_FND (Software Component) SAP Business Suite Foundation
   ⤷ CA-EPT-BRC (Application Component) Reusable Components of Business Suite Foundation
     ⤷ /BOFU/ADDRESS_DO (Package) DO Address

Basic Data

Table Category	INTTAB	Structure
Structure	/BOFU/S_ADDR_POSTAL_ADDRESSI	Table Relationship Diagram
Short Description	Node structure for postal address data - internal

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	REPRESENTATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	TSADV
2	COUNTRY_CODE	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
3	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
4	CITY_NAME	☐	AD_CITY1	TEXT40	CHAR	40	0	City
5	CITY	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	ADRCITY
6	ADDITIONAL_CITY_NAME	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
7	CITY2	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	ADRCITY
8	DISTRICT_NAME	☐	AD_CITY2	TEXT40	CHAR	40	0	District
9	DISTRICT	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	ADRCITYPRT
10	STREET_POSTAL_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
11	POBOX_POSTAL_CODE	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
12	COMPANY_POSTAL_CODE	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
13	STREET_PREFIX_NAME	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
14	ADDITIONAL_STREET_PREFIX_NAME	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
15	STREET_NAME	☐	AD_STREET	TEXT60	CHAR	60	0	Street
16	STREET	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	ADRSTREET
17	STREET_SUFFIX_NAME	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
18	ADDITIONAL_STREET_SUFFIX_NAME	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
19	HOUSE_ID	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
20	ADDITIONAL_HOUSE_ID	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
21	BUILDING_ID	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
22	ROOM_ID	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
23	FLOOR_ID	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
24	CARE_OF_NAME	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
25	MAIL_NO_DELIVERY	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag	*
26	REGION_GROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
27	POBOX_DEVIATING_COUNTRY_CODE	☐	INTCA3	INTCA3	CHAR	3	0	ISO country code 3 char
28	REGION2	☐			STRG	0	0
29	POBOX_DEVIATING_CITY_NAME	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
30	CITY3	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	ADRCITY
31	POBOX_ID	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
32	POBOX_INDICATOR	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
33	MAIL_NO_DELIVERY2	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag	*
34	TAXJURISDICTION	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
35	TIME_ZONE_CODE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	TTZZ
36	REG_STRUC_CONSISTENCY_CODE	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/BOFU/S_ADDR_POSTAL_ADDRESSI	CITY	ADRCITY	CITY_CODE	REF	1	CN
2	/BOFU/S_ADDR_POSTAL_ADDRESSI	CITY2	ADRCITY	CITY_CODE	REF	1	CN
3	/BOFU/S_ADDR_POSTAL_ADDRESSI	CITY3	ADRCITY	CITY_CODE	REF	1	CN
4	/BOFU/S_ADDR_POSTAL_ADDRESSI	COUNTRY_CODE	T005	LAND1	REF	C	CN
5	/BOFU/S_ADDR_POSTAL_ADDRESSI	DISTRICT	ADRCITYPRT	CITYP_CODE	REF	1	CN
6	/BOFU/S_ADDR_POSTAL_ADDRESSI	REGION	T005S	BLAND	REF	1	CN
7	/BOFU/S_ADDR_POSTAL_ADDRESSI	REGION_GROUP	ADRREGGRP	REGIOGROUP	REF	1	CN
8	/BOFU/S_ADDR_POSTAL_ADDRESSI	REPRESENTATION	TSADV	NATION	REF	1	CN
9	/BOFU/S_ADDR_POSTAL_ADDRESSI	STREET	ADRSTREET	STRT_CODE	REF	1	CN
10	/BOFU/S_ADDR_POSTAL_ADDRESSI	TIME_ZONE_CODE	TTZZ	TZONE	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	701