SAP ABAP Table /TDAG/CPS_USER_EXT (CP: Extended structure of users)

Hierarchy

☛ TDAGBCA (Software Component) TechniData Basic Components
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ /TDAG/CP_WL (Package) CP: Work list handling

Basic Data

Table Category	INTTAB	Structure
Structure	/TDAG/CPS_USER_EXT	Table Relationship Diagram
Short Description	CP: Extended structure of users

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	.INCLUDE	☐				0	0	SAPoffice: Structure of the API Recipient List
37	RECEIVER	☐	SO_RECNAME	SOEXTADRI1	CHAR	1215	0	SAPoffice: Name of the recipient of a document (also ext.)
38	REC_TYPE	☐	SO_ESCAPE	SO_ESCAPE	CHAR	1	0	Specification of recipient type
39	REC_ID	☐	SO_REC_ID	SO_OBJ_ID	CHAR	17	0	Recipient ID
40	REPLY_DOC	☐	SO_REP_DOC	SO_ENTRYID	CHAR	46	0	Object ID of the document being replied to
41	REC_DATE	☐	SO_DAT_RC	DATUM	DATS	8	0	Date document was received
42	PROXY_ID	☐	SO_SUB_ID	SO_OBJ_ID	CHAR	17	0	ID of the substitute who (also) received the object
43	RETRN_CODE	☐	SO_RET_COD	SO_NUMC004	CHAR	4	0	Return code
44	.INCLUDE	☐				0	0	SAPoffice: Send Attributes
45	EXPRESS	☐	SO_SND_EX	SO_FLAG	CHAR	1	0	Send express
46	COPY	☐	SO_SND_CP	SO_FLAG	CHAR	1	0	Send: As copy
47	BLIND_COPY	☐	SO_SND_BC	SO_FLAG	CHAR	1	0	Send as a blind copy
48	NO_FORWARD	☐	SO_FORFB	SO_FLAG	CHAR	1	0	You cannot forward this message
49	NO_PRINT	☐	SO_PRIFB	SO_FLAG	CHAR	1	0	Object cannot be printed
50	TO_ANSWER	☐	SO_OBJ_RR	SO_FLAG	CHAR	1	0	A reply must be sent for this object
51	TO_DO_EXPL	☐	SO_ACALL	SO_FLAG	CHAR	1	0	ToDo by all recipients
52	TO_DO_GRP	☐	SO_DO_GRP	SO_NUMC001	CHAR	1	0	ToDo group of the recipient
53	.INCLUDE	☐				0	0	SAPoffice: External Send Attributes for API
54	COM_TYPE	☐	SO_SND_ART	SO_SND_ART	CHAR	6	0	Transmission Method (Fax, Telex, ...)
55	LFDNR	☐	SO_LFD_NR	LFDNR	CHAR	3	0	Addresses: Sequence Number of Address
56	FAX	☐	SO_FAX_NR	SO_TEXT030	CHAR	30	0	SAPoffice: Fax number
57	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
58	SPOOL_ID	☐	SO_SPOOL	SO_NUMC005	CHAR	5	0	ID of the spool entry (e.g. after faxing)
59	NOTIF_DEL	☐	SO_NF_DELI	SO_FLAG	CHAR	1	0	Acknowledgment of receipt expected
60	NOTIF_READ	☐	SO_NOTREC	SO_TEXT001	CHAR	1	0	Read acknowledgment expected
61	NOTIF_NDEL	☐	SO_NOTDELI	SO_FLAG	CHAR	1	0	Acknowledgment of receipt expected
62	SAP_BODY	☐	SO_SAP_BDY	SO_FLAG	CHAR	1	0	Send externally with SAP data part

History

Last changed by/on	SAP	20141109
SAP Release Created in	222_46C