SAP Table CRMD_TSS_EVENTS stores TSS Analysis: Database Table storing TSS Events for BWdata

  

In this post, I will try and describe everything you need to know about the SAP crmd_tss_events 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_EVENTS 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_EVENTS....Right lets get started!


SAP CRMD_TSS_EVENTS dictionary attributes

Object Name: CRMD_TSS_EVENTS
Dictionary Type: Transparent table
Description: TSS Analysis: Database Table storing TSS Events for BW


CRMD_TSS_EVENTS field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) *ClientMANDTTESTCRM
PROC_ANCHOR_GUIDCRMT_PROCESS_GUID_32CHAR32(0) GUID for a TransactionSYSUUID_CCRM
PROCESS_IDENTCRMT_TSS_PROCESSCHAR4(0) *Analysis Process IdentifierCRM_TSS_PROCESSCRMH_TSS_PROCESSPROC_IDENTCRM
PERF_KYFCRMT_TSS_PERFKYFCHAR4(0) *Performance Key FigureCRM_TSS_PERFKYFCRMH_TSS_PERFKYFPERF_KYFCRM
PERF_KYF_DURACRMT_SRV_DURATIONQUAN13(3) DurationMENG13CRM
PERF_KYF_DURUNITCRMT_SRV_DURATION_UOMUNIT3(0) *Unit for Duration of WorkMEINSCRM
HEADER_GUIDCRMT_PROCESS_GUID_32CHAR32(0) GUID for a TransactionSYSUUID_CCRM
OBJECT_GUIDCRMT_PROCESS_GUID_32CHAR32(0) GUID for a TransactionSYSUUID_CCRM
TABLE_UPDATE_TSTIMESTAMPDEC15(0) UTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSCRM
RECORDMODERODMUPDMODCHAR1(0) BW Delta Process: Record ModeRODMUPDMODCRM
SE_HEADER_GUIDCRMT_PROCESS_GUID_32CHAR32(0) GUID for a TransactionSYSUUID_CCRM
SE_GUIDCRMT_PROCESS_GUID_32CHAR32(0) GUID for a TransactionSYSUUID_CCRM
SE_PROCESS_TYPECRMT_TSS_SE_PRTYPECHAR4(0) *Transaction Type (Start Event)CRM_PROCESS_TYPECRM
SE_ITEM_TYPECRMT_TSS_SE_ITTYPECHAR4(0) *Item Category (Start Event)CRM_ITEM_TYPECRM
SE_EVENT_SRCCRMT_TSS_EVTSRCCHAR3(0) *Timestamp Service: Event Source (Application)CRM_TSS_EVTSRCCRM
SE_STATUSCRMT_TSS_STATUSCHAR5(0) StatusCRM_J_STATUSCRMH_TSS_STATUSSTATUSCRM
SE_STATUS_SCHEMACRMT_TSS_STATUSPRCHAR8(0) *Status ProfileCRM_J_STSMACRMH_TSS_STATUSSTATUS_SCHEMACRM
SE_DATE_TYPECRMT_TSS_APPT_TYPECHAR12(0) Timestamp Service: Date TypeCRM_TSS_APPT_TYPECRM
SE_TIMESTAMPTIMESTAMPDEC15(0) UTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSCRM
SE_FL_INDICATORCRMT_TSS_INDICATORCHAR2(0) First-Event-Last-Event IndicatorCRM_TSS_INDICATORCRM
EE_HEADER_GUIDCRMT_PROCESS_GUID_32CHAR32(0) GUID for a TransactionSYSUUID_CCRM
EE_GUIDCRMT_PROCESS_GUID_32CHAR32(0) GUID for a TransactionSYSUUID_CCRM
EE_PROCESS_TYPECRMT_TSS_EE_PRTYPECHAR4(0) *Transaction Type (End Event)CRM_PROCESS_TYPECRM
EE_ITEM_TYPECRMT_TSS_EE_ITTYPECHAR4(0) *Item Category (End Event)CRM_ITEM_TYPECRM
EE_EVENT_SRCCRMT_TSS_EVTSRCCHAR3(0) *Timestamp Service: Event Source (Application)CRM_TSS_EVTSRCCRM
EE_STATUSCRMT_TSS_STATUSCHAR5(0) StatusCRM_J_STATUSCRMH_TSS_STATUSSTATUSCRM
EE_STATUS_SCHEMACRMT_TSS_STATUSPRCHAR8(0) *Status ProfileCRM_J_STSMACRMH_TSS_STATUSSTATUS_SCHEMACRM
EE_DATE_TYPECRMT_TSS_APPT_TYPECHAR12(0) Timestamp Service: Date TypeCRM_TSS_APPT_TYPECRM
EE_TIMESTAMPTIMESTAMPDEC15(0) UTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSCRM
EE_FL_INDICATORCRMT_TSS_INDICATORCHAR2(0) First-Event-Last-Event IndicatorCRM_TSS_INDICATORCRM
EE_DELETEXFELDCHAR1(0) CheckboxXFELDFBCRM


View list of all tables