SAP ABAP Table /SRMERP/S_PERSON_WP_ADDRESS_D (Workplace Address)

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_WP_ADDRESS_D	Table Relationship Diagram
Short Description	Workplace Address

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	ADMIN_DATA	☐	/SRMERP/S_PERSON_WP_ADDRESS_A		STRU	0	0
2	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
3	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
4	PERSON_NAME	☐	/BOFU/S_ADDR_PERSON_NAMEI		STRU	0	0
5	REPRESENTATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses
6	.INCLUDE	☐				0	0	Proxy Structure (APC_S_PERSON_NAME)
7	FORM_OF_ADDRESS	☐	/BOFU/ADDR_FRM_ADDRESS_CD		CHAR	4	0	Proxy Data Element (APC_C_FORM_OF_ADDRESS_CODE)
8	GIVEN_NAME	☐	/BOFU/ADDR_LANGIND_MEDIUM_NM		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_MEDIUM_NAME)
9	MIDDLE_NAME	☐	/BOFU/ADDR_LANGIND_MEDIUM_NM		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_MEDIUM_NAME)
10	FAMILY_NAME	☐	/BOFU/ADDR_LANGIND_MEDIUM_NM		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_MEDIUM_NAME)
11	ADDITIONAL_FAMILY_NAME	☐	/BOFU/ADDR_LANGIND_MEDIUM_NM		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_MEDIUM_NAME)
12	BIRTH_NAME	☐	/BOFU/ADDR_LANGIND_MEDIUM_NM		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_MEDIUM_NAME)
13	NICK_NAME	☐	/BOFU/ADDR_LANGIND_MEDIUM_NM		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_MEDIUM_NAME)
14	INITIALS_NAME	☐	/BOFU/ADDR_LANGIND_SHORT_NM		SSTR	10	0	Proxy Data Element (APC_V_LANGUAGEINDEP_SHORT_NAME)
15	ACADEMIC_TITLE1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key
16	ACADEMIC_TITLE2	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key
17	FAMILY_NM_PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)
18	FAMILY_NM_PREFIX2	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)
19	NAME_SUPPL_CODE	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)
20	DEVIATING_FULL_NAME	☐	/BOFU/ADDR_LANGIND_LONG_NM		SSTR	80	0	Proxy Data Element (APC_V_LANGUAGEINDEP_LONG_NAME)
21	NAME_FORMAT_COUNTRY_CODE	☐	INTCA3	INTCA3	CHAR	3	0	ISO country code 3 char
22	NAME_FORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format
23	GENDER_CODE	☐	AD_SEX	AD_SEX	CHAR	1	0	Gender key
24	KEY_WORDS_TEXT	☐	/BOFU/ADDR_KEY_WORDS_TEXT		CHAR	20	0	Proxy Data Element (APC_V_KEY_WORDS_TEXT)
25	ADDITIONAL_KEY_WORDS_TEXT	☐	/BOFU/ADDR_KEY_WORDS_TEXT		CHAR	20	0	Proxy Data Element (APC_V_KEY_WORDS_TEXT)
26	FORMATTED_NAME	☐	/BOFU/ADDR_LANGIND_LONG_NM		SSTR	80	0	Proxy Data Element (APC_V_LANGUAGEINDEP_LONG_NAME)
27	WORKPLACE	☐	/BOFU/S_ADDR_WORKPLACEI		STRU	0	0
28	REPRESENTATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses
29	FUNCTIONAL_TITLE_NAME	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
30	DEPARTMENT_NAME	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
31	BUILDING_ID	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
32	FLOOR_ID	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
33	ROOM_ID	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
34	INHOUSE_MAIL_ID	☐	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
35	CORRESPONDENCE_SHORT_NAME	☐	AD_ID_CODE	TEXT10	CHAR	10	0	Short name for correspondence
36	EMAIL	☐	/BOFU/S_ADDR_EMAILI		STRU	0	0
37	URI	☐			STRG	0	0
38	USAGE_DENIED_INDICATOR	☐	/BOFU/ADDR_EMAIL_INDICATOR	XFELD	CHAR	1	0	#Indicator# is a binarily coded fact with (APC_V_INDICATOR)
39	.INCLUDE	☐				0	0	Proxy Structure (APC_S_DATE_PERIOD)
40	START_DATE	☐	DATUM	DATUM	DATS	8	0	Date
41	END_DATE	☐	DATUM	DATUM	DATS	8	0	Date
42	DURATION	☐	/BOFU/ADDR_DURATION		STRG	0	0	Duration (APC_V_DURATION)
43	FACSIMILE	☐	/BOFU/S_ADDR_FACSIMILEI		STRU	0	0
44	.INCLUDE	☐				0	0	Proxy Structure (APC_S_PHONE_NUMBER)
45	AREA_ID	☐			CHAR	10	0
46	SUBSCRIBER_ID	☐			CHAR	30	0
47	EXTENSION_ID	☐			CHAR	10	0
48	COUNTRY_CODE	☐	INTCA3	INTCA3	CHAR	3	0	ISO country code 3 char
49	FORMATTED_NUMBER_TEXT	☐	/BOFU/ADDR_LANGIND_SHORTDESC		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_SHORT_DESC)
50	NORMALISED_NUMBER_TEXT	☐	/BOFU/ADDR_LANGIND_SHORTDESC		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_SHORT_DESC)
51	USAGE_DENIED_INDICATOR	☐	/BOFU/ADDR_EMAIL_INDICATOR	XFELD	CHAR	1	0	#Indicator# is a binarily coded fact with (APC_V_INDICATOR)
52	.INCLUDE	☐				0	0	Proxy Structure (APC_S_DATE_PERIOD)
53	START_DATE	☐	DATUM	DATUM	DATS	8	0	Date
54	END_DATE	☐	DATUM	DATUM	DATS	8	0	Date
55	DURATION	☐	/BOFU/ADDR_DURATION		STRG	0	0	Duration (APC_V_DURATION)
56	TELEPHONE	☐	/BOFU/S_ADDR_TELEPHONEI		STRU	0	0
57	.INCLUDE	☐				0	0	Proxy Structure (APC_S_PHONE_NUMBER)
58	AREA_ID	☐			CHAR	10	0
59	SUBSCRIBER_ID	☐			CHAR	30	0
60	EXTENSION_ID	☐			CHAR	10	0
61	COUNTRY_CODE	☐	INTCA3	INTCA3	CHAR	3	0	ISO country code 3 char
62	FORMATTED_NUMBER_TEXT	☐	/BOFU/ADDR_LANGIND_SHORTDESC		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_SHORT_DESC)
63	NORMALISED_NUMBER_TEXT	☐	/BOFU/ADDR_LANGIND_SHORTDESC		SSTR	40	0	Proxy Data Element (APC_V_LANGUAGEIND_SHORT_DESC)
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	MOBILE_PHONE_NUMBER_INDICATOR	☐	/BOFU/ADDR_EMAIL_INDICATOR	XFELD	CHAR	1	0	#Indicator# is a binarily coded fact with (APC_V_INDICATOR)
70	SMSENABLED_INDICATOR	☐	/BOFU/ADDR_EMAIL_INDICATOR	XFELD	CHAR	1	0	#Indicator# is a binarily coded fact with (APC_V_INDICATOR)

History

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