SAP ABAP Table /SRMERP/S_PERSON_ADDRESS_INF (Address Information)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-PUR-SSP (Application Component) Self-Service Procurement
     ⤷ /SRMERP/OL_MO (Package) Master Data Objects/Access

Basic Data

Table Category	INTTAB	Structure
Structure	/SRMERP/S_PERSON_ADDRESS_INF	Table Relationship Diagram
Short Description	Address Information

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	Include Structure for Key Information
2	KEY	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
3	PARENT_KEY	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
4	ROOT_KEY	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
5	.INCLUDE	☐				0	0	Address Information
6	ADMIN_DATA	☐	/SRMERP/S_PERSON_ADDRESS_D		STRU	0	0
7	SOURCE_BO_KEY	☐	/BOBF/OBM_BO_KEY	/BOBF/CONF_KEY	RAW	16	0	Business Object
8	SOURCE_KEY	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
9	ADDRESS_ID	☐	/BOFU/ADDRESS_ID		CHAR	40	0	Unique Identifier for Address (APC_V_ADDRESS_ID)
10	REF_ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
11	REF_PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
12	IS_STANDARD	☐	/SRMERP/STANDARD_IND	BOOLE	CHAR	1	0	Standard Entry
13	IS_EXPIRED	☐	/SRMERP/EXPIRATION_IND	BOOLE	CHAR	1	0	Expired Entry
14	WERK_ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
15	ORGANISATION_NAME	☐	/BOFU/S_ADDR_ORG_NAMEI		STRU	0	0
16	REPRESENTATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
17	.INCLUDE	☐				0	0	Proxy Structure (APC_S_ORGANISATION_NAME)
18	FORM_OF_ADDRESS	☐	/BOFU/ADDR_FRM_ADDRESS_CD		CHAR	4	0	Proxy Data Element (APC_C_FORM_OF_ADDRESS_CODE)
19	FIRST_LINE_NAME	☐	/BOFU/ADDR_LANGIND_MEDIUM_NM		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_MEDIUM_NAME)
20	SECOND_LINE_NAME	☐	/BOFU/ADDR_LANGIND_MEDIUM_NM		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_MEDIUM_NAME)
21	THIRD_LINE_NAME	☐	/BOFU/ADDR_LANGIND_MEDIUM_NM		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_MEDIUM_NAME)
22	FOURTH_LINE_NAME	☐	/BOFU/ADDR_LANGIND_MEDIUM_NM		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_MEDIUM_NAME)
23	KEY_WORDS_TEXT	☐	/BOFU/ADDR_KEY_WORDS_TEXT		CHAR	20	0	Proxy Data Element (APC_V_KEY_WORDS_TEXT)
24	ADDITIONAL_KEY_WORDS_TEXT	☐	/BOFU/ADDR_KEY_WORDS_TEXT		CHAR	20	0	Proxy Data Element (APC_V_KEY_WORDS_TEXT)
25	POSTAL_ADDRESS	☐	/BOFU/S_ADDR_POSTAL_ADDRESSI		STRU	0	0
26	REPRESENTATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
27	COUNTRY_CODE	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
28	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
29	CITY_NAME	☐	AD_CITY1	TEXT40	CHAR	40	0	City
30	CITY	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
31	ADDITIONAL_CITY_NAME	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
32	CITY2	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
33	DISTRICT_NAME	☐	AD_CITY2	TEXT40	CHAR	40	0	District
34	DISTRICT	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
35	STREET_POSTAL_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
36	POBOX_POSTAL_CODE	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
37	COMPANY_POSTAL_CODE	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
38	STREET_PREFIX_NAME	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
39	ADDITIONAL_STREET_PREFIX_NAME	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
40	STREET_NAME	☐	AD_STREET	TEXT60	CHAR	60	0	Street
41	STREET	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
42	STREET_SUFFIX_NAME	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
43	ADDITIONAL_STREET_SUFFIX_NAME	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
44	HOUSE_ID	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
45	ADDITIONAL_HOUSE_ID	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
46	BUILDING_ID	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
47	ROOM_ID	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
48	FLOOR_ID	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
49	CARE_OF_NAME	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
50	MAIL_NO_DELIVERY	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag	*
51	REGION_GROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	*
52	POBOX_DEVIATING_COUNTRY_CODE	☐	INTCA3	INTCA3	CHAR	3	0	ISO country code 3 char
53	REGION2	☐			STRG	0	0
54	POBOX_DEVIATING_CITY_NAME	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
55	CITY3	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
56	POBOX_ID	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
57	POBOX_INDICATOR	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
58	MAIL_NO_DELIVERY2	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag	*
59	TAXJURISDICTION	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
60	TIME_ZONE_CODE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	*
61	REG_STRUC_CONSISTENCY_CODE	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
62	EMAIL	☐	/BOFU/S_ADDR_EMAILI		STRU	0	0
63	URI	☐			STRG	0	0
64	USAGE_DENIED_INDICATOR	☐	/BOFU/ADDR_EMAIL_INDICATOR	XFELD	CHAR	1	0	#Indicator# is a binarily coded fact with (APC_V_INDICATOR)
65	.INCLUDE	☐				0	0	Proxy Structure (APC_S_DATE_PERIOD)
66	START_DATE	☐	DATUM	DATUM	DATS	8	0	Date
67	END_DATE	☐	DATUM	DATUM	DATS	8	0	Date
68	DURATION	☐	/BOFU/ADDR_DURATION		STRG	0	0	Duration (APC_V_DURATION)
69	FACSIMILE	☐	/BOFU/S_ADDR_FACSIMILEI		STRU	0	0
70	.INCLUDE	☐				0	0	Proxy Structure (APC_S_PHONE_NUMBER)
71	AREA_ID	☐			CHAR	10	0
72	SUBSCRIBER_ID	☐			CHAR	30	0
73	EXTENSION_ID	☐			CHAR	10	0
74	COUNTRY_CODE	☐	INTCA3	INTCA3	CHAR	3	0	ISO country code 3 char
75	FORMATTED_NUMBER_TEXT	☐	/BOFU/ADDR_LANGIND_SHORTDESC		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_SHORT_DESC)
76	NORMALISED_NUMBER_TEXT	☐	/BOFU/ADDR_LANGIND_SHORTDESC		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_SHORT_DESC)
77	USAGE_DENIED_INDICATOR	☐	/BOFU/ADDR_EMAIL_INDICATOR	XFELD	CHAR	1	0	#Indicator# is a binarily coded fact with (APC_V_INDICATOR)
78	.INCLUDE	☐				0	0	Proxy Structure (APC_S_DATE_PERIOD)
79	START_DATE	☐	DATUM	DATUM	DATS	8	0	Date
80	END_DATE	☐	DATUM	DATUM	DATS	8	0	Date
81	DURATION	☐	/BOFU/ADDR_DURATION		STRG	0	0	Duration (APC_V_DURATION)
82	TELEPHONE	☐	/BOFU/S_ADDR_TELEPHONEI		STRU	0	0
83	.INCLUDE	☐				0	0	Proxy Structure (APC_S_PHONE_NUMBER)
84	AREA_ID	☐			CHAR	10	0
85	SUBSCRIBER_ID	☐			CHAR	30	0
86	EXTENSION_ID	☐			CHAR	10	0
87	COUNTRY_CODE	☐	INTCA3	INTCA3	CHAR	3	0	ISO country code 3 char
88	FORMATTED_NUMBER_TEXT	☐	/BOFU/ADDR_LANGIND_SHORTDESC		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_SHORT_DESC)
89	NORMALISED_NUMBER_TEXT	☐	/BOFU/ADDR_LANGIND_SHORTDESC		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_SHORT_DESC)
90	USAGE_DENIED_INDICATOR	☐	/BOFU/ADDR_EMAIL_INDICATOR	XFELD	CHAR	1	0	#Indicator# is a binarily coded fact with (APC_V_INDICATOR)
91	.INCLUDE	☐				0	0	Proxy Structure (APC_S_DATE_PERIOD)
92	START_DATE	☐	DATUM	DATUM	DATS	8	0	Date
93	END_DATE	☐	DATUM	DATUM	DATS	8	0	Date
94	DURATION	☐	/BOFU/ADDR_DURATION		STRG	0	0	Duration (APC_V_DURATION)
95	MOBILE_PHONE_NUMBER_INDICATOR	☐	/BOFU/ADDR_EMAIL_INDICATOR	XFELD	CHAR	1	0	#Indicator# is a binarily coded fact with (APC_V_INDICATOR)
96	SMSENABLED_INDICATOR	☐	/BOFU/ADDR_EMAIL_INDICATOR	XFELD	CHAR	1	0	#Indicator# is a binarily coded fact with (APC_V_INDICATOR)
97	NOTE	☐	/BOFU/S_ADDR_NOTE_ELI		STRU	0	0
98	REPRESENTATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
99	.INCLUDE	☐				0	0	Structure for "NOTE"s in Dep. Object Address
100	LANGUAGE_CODE	☐	SPRAS	SPRAS	LANG	1	0	Language Key
101	NOTE	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes

History

Last changed by/on	SAP	20130529
SAP Release Created in	606