SAP ABAP Table /TDAG/CPS_ADDR_PERSON_EXT (CP: Extended Personal address)

Hierarchy

☛ TDAGBCA (Software Component) TechniData Basic Components
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ /TDAG/CP (Package) Compliance for products

Basic Data

Table Category	INTTAB	Structure
Structure	/TDAG/CPS_ADDR_PERSON_EXT	Table Relationship Diagram
Short Description	CP: Extended Personal 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	.INCLUDE	☐				0	0	CP: Personal address
2	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
3	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
4	TITLE_P	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
5	NAME_FIRST	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
6	NAME_LAST	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
7	NAME2_P	☐	AD_NAME2_P	TEXT40	CHAR	40	0	Name of person at birth
8	NAMEMIDDLE	☐	AD_NAMEMID	TEXT40	CHAR	40	0	Middle name or second forename of a person
9	NAME_LAST2	☐	AD_NAMLAS2	TEXT40	CHAR	40	0	Second surname of a person
10	NAME_TEXT	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
11	CONVERTED	☐	AD_NAMCONV	AD_NAMCONV	CHAR	1	0	Status of Field 'Full Name' NAME_TEXT
12	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
13	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	*
14	PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	*
15	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	*
16	TITLE_SPPL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	*
17	NICKNAME	☐	AD_NICKNAM	TEXT40	CHAR	40	0	Nickname or name used
18	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
19	NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	*
20	NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	*
21	LANGU_P	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
22	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
23	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
24	BUILDING_C	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
25	FLOOR_C	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
26	ROOMNUM_C	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
27	ADDR_COMP	☐	AD_ADDRCOM	AD_ADDRNUM	CHAR	10	0	(not used)	*
28	DEFLT_COMM	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
29	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
30	EXT_NUMBER	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
31	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
32	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
33	TEL_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
34	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
35	BP_PARNR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
36	TITLE_PTX	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
37	TELEFFROM	☐	SKTELFFROM	CHAR4	CHAR	4	0	International Dialing Code for Telephone/Fax
38	TELEFTO	☐	SKTELFTO	CHAR4	CHAR	4	0	Country telephone/fax dialling code

History

Last changed by/on	SAP	20141109
SAP Release Created in	110_600