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

History

Last changed by/on	SAP	20141109
SAP Release Created in	0207B0406C