SAP ABAP Table /TDAG/CPT_TASKHA (CP: Kopfdaten für Aufgaben / Archiv)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/TDAG/CPT_TASKHA	Table Relationship Diagram
Short Description	CP: Kopfdaten für Aufgaben / Archiv

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	HDRNO	☑	/TDAG/CPE_HDRNO	/TDAG/CPD_HDRNO	CHAR	20	0	Task Number
3	.INCLUDE	☐				0	0	CP: Structure of logical key fields
4	SUBID	☐	ESESUBID	ESDSUBID	CHAR	12	0	Specification
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	EXTID	☐	/TDAG/CPE_TASKEXTID	CHAR20	CHAR	20	0	External ID
7	ORIGIN	☐	/TDAG/CPE_ORIGIN	/TDAG/CPD_ORIGIN	CHAR	10	0	Initiated By
8	ORIGIN_KEY	☐	/TDAG/CPE_ORIGINKEY	CHAR32	CHAR	32	0	Specific Origin Key
9	REGCHECK	☐	/TDAG/CPE_CHECK	/TDAG/CPD_CHECK	CHAR	10	0	Check	/TDAG/CPC_CHECK
10	.INCLUDE	☐				0	0	CP: Structure of the task header
11	REGLIST	☐	/TDAG/CPE_REGLIST	/TDAG/CPD_REGLIST	CHAR	20	0	Regulatory/Customer List	/TDAG/CPC_SREG
12	TASKCAT	☐	/TDAG/CPE_TASKCAT	/TDAG/CPD_TASKCAT	CHAR	3	0	Task Category	/TDAG/CPC_TCAT
13	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
14	SUPPLIER	☐	/TDAG/CPE_SUPPLIER	LIFNR	CHAR	10	0	Supplier	LFA1
15	USERA	☐	/TDAG/CPE_XUBNAME	XUBNAME	CHAR	12	0	Task Processor	USR02
16	RESP_PERSON	☐	/TDAG/CPE_RESP_PERSON	XUBNAME	CHAR	12	0	Responsible Person	USR02
17	FORMAT_CAT	☐	/TDAG/CPE_IMPTYP	/TDAG/RCSD_TEMPLID	CHAR	10	0	Incoming Template	*
18	STATUS	☐	/TDAG/CPE_STATUS	/TDAG/CPD_STATUS	CHAR	5	0	Task Status	/TDAG/CPC_STATUS
19	FLG_ATTACH	☐	/TDAG/CPE_FLGATT	ESDBOOLE	CHAR	1	0	Attachment
20	PRIO	☐	/TDAG/CPE_PRIO	/TDAG/CPD_PRIO	NUMC	1	0	Task Priority
21	DUEDATE	☐	/TDAG/CPE_DUEDATE		DATS	8	0	Due Date
22	PLANDATE	☐	/TDAG/CPE_PLANDATE		DATS	8	0	Completion By
23	STARTDATE	☐	/TDAG/CPE_STARTDATE		DATS	8	0	Start Date of Processing
24	CRDATE	☐	ESECRDAT	DATUM	DATS	8	0	Created On
25	CRTIME	☐	/TDAG/CPE_CRTIME		TIMS	6	0	Creation Time
26	CRNAME	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
27	UPDDATE	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
28	UPDTIME	☐	/TDAG/CPE_UPDTIME		TIMS	6	0	Change Time
29	UPDNAME	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
30	SUP_MPN	☐	/TDAG/CPE_SUP_MPN	/TDAG/CPD_EMATNR	CHAR	40	0	Supplier Material Number (MPN)
31	CUS_MPN	☐	/TDAG/CPE_CUS_MPN	/TDAG/CPD_EMATNR	CHAR	40	0	Customer Material Number (MPN)
32	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
33	MSGTY	☐	MSGTY	MSGAR	CHAR	1	0	Message Type
34	MSGID	☐	MSGID	ARBGB	CHAR	20	0	Message identification	T100A
35	MSGNO	☐	MSGNO	MSGNR	CHAR	3	0	System Message Number	T100
36	MSGV1	☐	/TDAG/CPE_MSGV1	CHAR50	CHAR	50	0	Message Variable 1
37	MSGV2	☐	/TDAG/CPE_MSGV2	CHAR50	CHAR	50	0	Message Variable 2
38	MSGV3	☐	/TDAG/CPE_MSGV3	CHAR50	CHAR	50	0	Message Variable 3
39	MSGV4	☐	/TDAG/CPE_MSGV4	CHAR50	CHAR	50	0	Message Variable 4
40	PARENTNO	☐	/TDAG/CPE_PARENTNO	/TDAG/CPD_HDRNO	CHAR	20	0	Parent Record
41	GROUPA	☐	/TDAG/CPE_PROCGROUP	/TDAG/CPD_PROCGROUP	CHAR	10	0	Processor Group
42	REQDATE	☐	/TDAG/CPE_REQUESTDATE	DATE	DATS	8	0	Request Date
43	REQTIME	☐	/TDAG/CPE_REQUESTTIME	TIME	TIMS	6	0	Request Time
44	COMMTYPE	☐	/TDAG/CPE_COMMTYPE	/TDAG/CPD_COMMTYPE	CHAR	10	0	Communication Type
45	ESCCOUNTER	☐	/TDAG/CPE_ESCCOUNTER	U_INT_4	INT4	10	0	Number of Escalations
46	ESCREASONID	☐	/TDAG/CPE_ESCREASONID	/TDAG/CPD_ESCREASONID	CHAR	30	0	Escalation Reason	/TDAG/CPC_ESCRSN
47	ESCSEVERITY	☐	/TDAG/CPE_ESCSEVERITY	NUMC10	NUMC	10	0	Escalation Severity Description
48	.INCLUDE	☐				0	0	CP: Communication informations
49	EXTPROCESSOR	☐	/TDAG/CPE_EXTPROCESSOR	AD_PERSNUM	CHAR	10	0	External Processor	*
50	EMAILADDR	☐	/TDAG/CPE_EMAILADDR	AD_SMTPADR	CHAR	241	0	E-Mail Address
51	COMM_INFO	☐	/TDAG/CPE_COMM_INFO	CHAR15	CHAR	15	0	Communication Information
52	FLG_INCOMING_COM	☐	/TDAG/RCSE_COMDIRECT	ESDBOOLE	CHAR	1	0	Communication Direction

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/TDAG/CPT_TASKHA	CUSTOMER	KNA1	KUNNR
2	/TDAG/CPT_TASKHA	ESCREASONID	/TDAG/CPC_ESCRSN	REASONID		C	1
3	/TDAG/CPT_TASKHA	MATNR	MARA	MATNR
4	/TDAG/CPT_TASKHA	MSGID	T100A	ARBGB
5	/TDAG/CPT_TASKHA	MSGNO	T100	MSGNR
6	/TDAG/CPT_TASKHA	PLANT	T001W	WERKS
7	/TDAG/CPT_TASKHA	REGCHECK	/TDAG/CPC_CHECK	REGCHECK	REF
8	/TDAG/CPT_TASKHA	REGLIST	/TDAG/CPC_SREG	REGLIST
9	/TDAG/CPT_TASKHA	RESP_PERSON	USR02	BNAME	REF
10	/TDAG/CPT_TASKHA	STATUS	/TDAG/CPC_STATUS	STATUS
11	/TDAG/CPT_TASKHA	SUPPLIER	LFA1	LIFNR
12	/TDAG/CPT_TASKHA	TASKCAT	/TDAG/CPC_TCAT	TASKCAT	REF	1	N
13	/TDAG/CPT_TASKHA	USERA	USR02	BNAME		1	N

History

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