SAP Table CRMD_TSS_DTRACK stores TSS Tracking of Documents: DB Table for Tracking Recordsdata

  

In this post, I will try and describe everything you need to know about the SAP crmd_tss_dtrack table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for CRMD_TSS_DTRACK what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from CRMD_TSS_DTRACK....Right lets get started!


SAP CRMD_TSS_DTRACK dictionary attributes

Object Name: CRMD_TSS_DTRACK
Dictionary Type: Transparent table
Description: TSS Tracking of Documents: DB Table for Tracking Records


CRMD_TSS_DTRACK field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTESTCRM
ORDERADM_H_GUIDCRMT_PROCESS_GUID_32CHAR32(0) GUID for a TransactionSYSUUID_CCRM
GUIDCRMT_PROCESS_GUID_32CHAR32(0) GUID for a TransactionSYSUUID_CCRM
TIMESTAMP_FROMCRMBWTSTMPDEC15(0) Creation dateCRMBWTSTMPCRM
TIMESTAMP_TOCRMBWTSTMPDEC15(0) Creation dateCRMBWTSTMPCRM
DURATIONCRMT_SRV_DURATIONQUAN13(3) DurationMENG13CRM
DURATION_UNITCRMT_SRV_DURATION_UOMUNIT3(0) *Unit for Duration of WorkMEINSCRM
REC_UPDATEDCRMBWTSTMPDEC15(0) Creation dateCRMBWTSTMPCRM
RECORDMODERODMUPDMODCHAR1(0) BW Delta Process: Record ModeRODMUPDMODCRM
OBJECT_IDCRMT_OBJECT_ID_DBCHAR10(0) Transaction NumberCRM_OBJECT_IDCRM
PROCESS_TYPECRMT_PROCESS_TYPE_DBCHAR4(0) *Business Transaction TypeCRM_PROCESS_TYPECRM
POSTING_DATECRMT_POSTING_DATEDATS8(0) Posting Date for a Business TransactionCRM
DESCRIPTIONCRMT_PROCESS_DESCRIPTIONCHAR40(0) Transaction DescriptionCRM_PROCESS_DESCRIPTIONCRM
DESCR_LANGUAGECRMT_PROCESS_DESCRIPTION_LANGULANG1(0) *Language Key of DescriptionSPRASCRM
LOGICAL_SYSTEMCRMT_LOGSYSCHAR10(0) *Logical SystemLOGSYSCRM
CRM_RELEASESAPRELEASECHAR10(0) SAP ReleaseCHAR10CRM
SCENARIOCRMT_SCENARIOCHAR10(0) Scenario IdentityCRM_SCENARIOCRM
TEMPLATE_TYPECRMT_TEMPLATE_TYPE_DBCHAR1(0) Template Type of CRM TransactionCRM_TEMPLATE_TYPECRM
CREATED_ATCOMT_CREATED_AT_USRDEC15(0) Created At (Output in User Time Zone)COM_TSTMPCRM
CREATED_BYCRMT_CREATED_BYCHAR12(0) User that Created the TransactionUNAMEUSER_ADDRBNAMECRM
CHANGED_ATCOMT_CHANGED_AT_USRDEC15(0) Changed At (Output in User Time Zone)COM_TSTMPCRM
CHANGED_BYCRMT_CHANGED_BYCHAR12(0) Transaction Last Changed ByUNAMECRM
HEAD_CHANGED_ATCRMT_CHANGED_ATDEC15(0) Time of Last Change to the TransactionBCOS_TSTMPCRM
ORDERADM_H_DUMMYDUMMYCHAR1(0) Dummy function in length 1DUMMYSAPCRM
.INCLU--AP0(0) CRM
INPUT_CHANNELCRMT_INPUT_CHANNELCHAR3(0) Input channelCRM_INPUT_CHANNELCRM
OBJECT_TYPECRMT_SUBOBJECT_CATEGORY_DBCHAR10(0) *Business Trans. Cat.CRM_OJ_NAME_PROCESSCRM
ARCHIVING_FLAGCRMT_ARCHIVING_FLAGCHAR1(0) Indicator Whether the Business Transaction Can Be ArchivedCRM_BOOLEANCRM
DESCRIPTION_UCCRMT_PROCESS_DESCRIPTION_UCCHAR40(0) Transaction Description (Upper Case)CRM_PROCESS_DESCRIPTION_UCCRM
OBJECT_ID_OKCRMT_OBJECT_ID_OKCHAR1(0) Indicator Whether Business Transaction Number is CorrectCRM_BOOLEANCRM
VERIFY_DATECRMT_VERIFY_DATEDEC15(0) Time Period of Last Archiving AttemptBCOS_TSTMPCRM
CRM_CHANGED_ATCRMT_ONLINE_CHANGED_ATDEC15(0) Time of Last Change in CRM OnlineBCOS_TSTMPCRM
NUMBER_INTCRMT_ITEM_NONUMC10(0) Item Number in DocumentCRM_ITEM_NOCRM
NUMBER_EXTCRMT_ITEM_NO_EXTNUMC10(0) External Item NumberCRM
SALES_EMPLOYEECRMT_SALES_EMPLOYEECHAR10(0) *EmployeeBU_PARTNERCRM
PERSON_RESPCRMT_PERSON_RESPCHAR10(0) *Employee ResponsibleBU_PARTNERCRM
CONTACT_PERSONCRMT_CONTACT_PERSONCHAR10(0) *Customer Contact PersonBU_PARTNERCRM
SALESPARTNERCRMT_SALESPARTNERCHAR10(0) *Sales PartnersBU_PARTNERCRM
SOLD_TO_PARTYCRMT_SOLD_TO_PARTCHAR10(0) *Sold-To PartyBU_PARTNERCRM
SHIP_TO_PARTYCRMT_SHIP_TO_PARTCHAR10(0) *Ship-To PartyBU_PARTNERCRM
BILL_TO_PARTYCRMT_BILL_TO_PARTCHAR10(0) *Bill-To PartyBU_PARTNERCRM
PAYERCRMT_RP_PAYERCHAR10(0) *PayerBU_PARTNERCRM
SOLD_FROMCRMT_SOLD_FROM_PARTY_IDCHAR10(0) *Salesperson IDBU_PARTNERBUPAPARTNERCRM
EXECUTING_CCCRMT_EXECUTING_CCCHAR10(0) *Executing Interaction CenterBU_PARTNERCRM
RESP_GROUPCRMT_RESPONSIBLE_GROUPCHAR10(0) *Responsible GroupBU_PARTNERCRM
SERVICE_TEAMCRMT_SERVICE_TEAMCHAR10(0) *Service TeamBU_PARTNERCRM
SERVICE_EMPLOYEECRMT_SERVICE_EMPLOYEECHAR10(0) *Executing Service EmployeeBU_PARTNERCRM
SALES_ORG_RESPOBJEKTIDNUMC8(0) Object IDNUM08PONPPCRM
SALES_ORGOBJEKTIDNUMC8(0) Object IDNUM08PONPPCRM
SALES_OFFICEOBJEKTIDNUMC8(0) Object IDNUM08PONPPCRM
SALES_GROUPOBJEKTIDNUMC8(0) Object IDNUM08PONPPCRM
DIS_CHANNELCRMT_DISTRIBUTION_CHANNELCHAR2(0) *Distribution ChannelCRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNELDIS_CHANNELCRM
DIVISIONCRMT_DIVISIONCHAR2(0) *DivisionCRM_DIVISIONCRM_DIVISIONDIVISIONCRM
SERVICE_ORG_RESPOBJEKTIDNUMC8(0) Object IDNUM08PONPPCRM
SERVICE_ORGOBJEKTIDNUMC8(0) Object IDNUM08PONPPCRM
PURCH_ORG_RESPOBJEKTIDNUMC8(0) Object IDNUM08PONPPCRM
PURCH_ORGOBJEKTIDNUMC8(0) Object IDNUM08PONPPCRM
PURCH_GROUPOBJEKTIDNUMC8(0) Object IDNUM08PONPPCRM
BWSTONESYS0CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTONESYS1CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTONESYS2CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTONESYS3CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTONESYS4CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTONESYS5CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTONESYS6CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTONESYS7CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTONESYS8CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTONESYS9CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTONESYSACRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTTECSYS0CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTTECSYS1CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTTECSYS2CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTLOCSYS0CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTLOCSYS1CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTLOCSYS2CRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTONESYSBCRMBWSTNUMC2(0) BW StatusJ_STONRCRM
.INCLU--AP0(0) CRM
BWSTZRVCNTICRMBWSTNUMC2(0) BW StatusJ_STONRCRM
BWSTZRVCNTHCRMBWSTNUMC2(0) BW StatusJ_STONRCRM


View list of all tables