SAP ABAP Table CRMD_TSS_DTRACK (TSS Tracking of Documents: DB Table for Tracking Records)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA-SRV-BW (Application Component) BW Data Exchange
     ⤷ CRM_SERVICE_TSS_BW (Package) Package for Timestamp Analysis and Tracking of Document Proc

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_TSS_DTRACK	Table Relationship Diagram
Short Description	TSS Tracking of Documents: DB Table for Tracking Records

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	ORDERADM_H_GUID	☑	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
3	GUID	☑	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
4	TIMESTAMP_FROM	☑	CRMBWTSTMP	CRMBWTSTMP	DEC	15	0	Creation date
5	TIMESTAMP_TO	☐	CRMBWTSTMP	CRMBWTSTMP	DEC	15	0	Creation date
6	DURATION	☐	CRMT_SRV_DURATION	MENG13	QUAN	13	3	Duration
7	DURATION_UNIT	☐	CRMT_SRV_DURATION_UOM	MEINS	UNIT	3	0	Unit for Duration of Work	*
8	REC_UPDATED	☐	CRMBWTSTMP	CRMBWTSTMP	DEC	15	0	Creation date
9	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
10	.INCLUDE	☐				0	0	General Header Data - Structure of External Fields
11	OBJECT_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
12	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
13	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
14	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
15	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
16	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
17	CRM_RELEASE	☐	SAPRELEASE	CHAR10	CHAR	10	0	SAP Release
18	SCENARIO	☐	CRMT_SCENARIO	CRM_SCENARIO	CHAR	10	0	Scenario Identity
19	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE_DB	CRM_TEMPLATE_TYPE	CHAR	1	0	Template Type of CRM Transaction
20	.INCLUDE	☐				0	0	Time and User of Last Transaction Processing
21	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
22	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
23	CHANGED_AT	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
24	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
25	HEAD_CHANGED_AT	☐	CRMT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change to the Transaction
26	.INCLUDE	☐				0	0	EEW Extension
27	ORDERADM_H_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
28	.INCLUDE	☐				0	0
29	.INCLU--AP	☐				0	0	Additional Fields in ORDERADM_H After Decoupling
30	INPUT_CHANNEL	☐	CRMT_INPUT_CHANNEL	CRM_INPUT_CHANNEL	CHAR	3	0	Input channel
31	BTX_CLASS	☐	CRMT_TRANSACTION_CLASSIFICATN	CRM_TRANSACTION_CLASSIFICATION	CHAR	1	0	CRM Business Transaction Classification
32	AUTH_SCOPE	☐	CRM_AUTH_SCOPE	CRM_AUTH_SCOPE	NUMC	6	0	Authorization Scope	*
33	COMP_TX_HEADER	☐	CRMT_COMP_TX_HEADER_GUID	SYSUUID	RAW	16	0	GUID of Composite Transaction Header
34	.INCLUDE	☐				0	0	General Header Data - Structure of System Fields
35	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY_DB	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Trans. Cat.	*
36	ARCHIVING_FLAG	☐	CRMT_ARCHIVING_FLAG	CRM_BOOLEAN	CHAR	1	0	Indicator Whether the Business Transaction Can Be Archived
37	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
38	OBJECT_ID_OK	☐	CRMT_OBJECT_ID_OK	CRM_BOOLEAN	CHAR	1	0	Indicator Whether Business Transaction Number is Correct
39	VERIFY_DATE	☐	CRMT_VERIFY_DATE	BCOS_TSTMP	DEC	15	0	Time Period of Last Archiving Attempt
40	CRM_CHANGED_AT	☐	CRMT_ONLINE_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change in CRM Online
41	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
42	NUMBER_EXT	☐	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number
43	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
44	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
45	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
46	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
47	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
48	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
49	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
50	.INCLUDE	☐				0	0	PARTNER (Sales) Data for BW DataSources
51	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
52	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
53	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
54	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
55	SOLD_FROM	☐	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
56	.INCLUDE	☐				0	0	PARTNER (Call Center) Data for BW Datasoures
57	EXECUTING_CC	☐	CRMT_EXECUTING_CC	BU_PARTNER	CHAR	10	0	Executing Interaction Center	*
58	RESP_GROUP	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
59	.INCLUDE	☐				0	0	Service Partner for BW Extraction
60	SERVICE_TEAM	☐	CRMT_SERVICE_TEAM	BU_PARTNER	CHAR	10	0	Service Team	*
61	SERVICE_EMPLOYEE	☐	CRMT_SERVICE_EMPLOYEE	BU_PARTNER	CHAR	10	0	Executing Service Employee	*
62	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
63	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
64	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
65	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
66	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
67	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
68	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
69	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
70	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
71	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
72	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
73	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
74	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
75	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
76	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
77	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
78	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
79	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
80	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
81	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
82	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
83	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
84	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
85	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
86	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
87	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
88	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
89	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
90	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
91	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
92	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
93	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
94	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
95	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status

History

Last changed by/on	SAP	20140802
SAP Release Created in	500