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!
Object Name: CRMD_TSS_EVENTS
Dictionary Type: Transparent table
Description: TSS Analysis: Database Table storing TSS Events for BW
Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
MANDT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
PROC_ANCHOR_GUID | CRMT_PROCESS_GUID_32 | CHAR | 32(0) | GUID for a Transaction | SYSUUID_C | CRM | ||||||
PROCESS_IDENT | CRMT_TSS_PROCESS | CHAR | 4(0) | * | Analysis Process Identifier | CRM_TSS_PROCESS | CRMH_TSS_PROCESS | PROC_IDENT | CRM | |||
PERF_KYF | CRMT_TSS_PERFKYF | CHAR | 4(0) | * | Performance Key Figure | CRM_TSS_PERFKYF | CRMH_TSS_PERFKYF | PERF_KYF | CRM | |||
PERF_KYF_DURA | CRMT_SRV_DURATION | QUAN | 13(3) | Duration | MENG13 | CRM | ||||||
PERF_KYF_DURUNIT | CRMT_SRV_DURATION_UOM | UNIT | 3(0) | * | Unit for Duration of Work | MEINS | CRM | |||||
HEADER_GUID | CRMT_PROCESS_GUID_32 | CHAR | 32(0) | GUID for a Transaction | SYSUUID_C | CRM | ||||||
OBJECT_GUID | CRMT_PROCESS_GUID_32 | CHAR | 32(0) | GUID for a Transaction | SYSUUID_C | CRM | ||||||
TABLE_UPDATE_TS | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | CRM | ||||||
RECORDMODE | RODMUPDMOD | CHAR | 1(0) | BW Delta Process: Record Mode | RODMUPDMOD | CRM | ||||||
SE_HEADER_GUID | CRMT_PROCESS_GUID_32 | CHAR | 32(0) | GUID for a Transaction | SYSUUID_C | CRM | ||||||
SE_GUID | CRMT_PROCESS_GUID_32 | CHAR | 32(0) | GUID for a Transaction | SYSUUID_C | CRM | ||||||
SE_PROCESS_TYPE | CRMT_TSS_SE_PRTYPE | CHAR | 4(0) | * | Transaction Type (Start Event) | CRM_PROCESS_TYPE | CRM | |||||
SE_ITEM_TYPE | CRMT_TSS_SE_ITTYPE | CHAR | 4(0) | * | Item Category (Start Event) | CRM_ITEM_TYPE | CRM | |||||
SE_EVENT_SRC | CRMT_TSS_EVTSRC | CHAR | 3(0) | * | Timestamp Service: Event Source (Application) | CRM_TSS_EVTSRC | CRM | |||||
SE_STATUS | CRMT_TSS_STATUS | CHAR | 5(0) | Status | CRM_J_STATUS | CRMH_TSS_STATUS | STATUS | CRM | ||||
SE_STATUS_SCHEMA | CRMT_TSS_STATUSPR | CHAR | 8(0) | * | Status Profile | CRM_J_STSMA | CRMH_TSS_STATUS | STATUS_SCHEMA | CRM | |||
SE_DATE_TYPE | CRMT_TSS_APPT_TYPE | CHAR | 12(0) | Timestamp Service: Date Type | CRM_TSS_APPT_TYPE | CRM | ||||||
SE_TIMESTAMP | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | CRM | ||||||
SE_FL_INDICATOR | CRMT_TSS_INDICATOR | CHAR | 2(0) | First-Event-Last-Event Indicator | CRM_TSS_INDICATOR | CRM | ||||||
EE_HEADER_GUID | CRMT_PROCESS_GUID_32 | CHAR | 32(0) | GUID for a Transaction | SYSUUID_C | CRM | ||||||
EE_GUID | CRMT_PROCESS_GUID_32 | CHAR | 32(0) | GUID for a Transaction | SYSUUID_C | CRM | ||||||
EE_PROCESS_TYPE | CRMT_TSS_EE_PRTYPE | CHAR | 4(0) | * | Transaction Type (End Event) | CRM_PROCESS_TYPE | CRM | |||||
EE_ITEM_TYPE | CRMT_TSS_EE_ITTYPE | CHAR | 4(0) | * | Item Category (End Event) | CRM_ITEM_TYPE | CRM | |||||
EE_EVENT_SRC | CRMT_TSS_EVTSRC | CHAR | 3(0) | * | Timestamp Service: Event Source (Application) | CRM_TSS_EVTSRC | CRM | |||||
EE_STATUS | CRMT_TSS_STATUS | CHAR | 5(0) | Status | CRM_J_STATUS | CRMH_TSS_STATUS | STATUS | CRM | ||||
EE_STATUS_SCHEMA | CRMT_TSS_STATUSPR | CHAR | 8(0) | * | Status Profile | CRM_J_STSMA | CRMH_TSS_STATUS | STATUS_SCHEMA | CRM | |||
EE_DATE_TYPE | CRMT_TSS_APPT_TYPE | CHAR | 12(0) | Timestamp Service: Date Type | CRM_TSS_APPT_TYPE | CRM | ||||||
EE_TIMESTAMP | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | CRM | ||||||
EE_FL_INDICATOR | CRMT_TSS_INDICATOR | CHAR | 2(0) | First-Event-Last-Event Indicator | CRM_TSS_INDICATOR | CRM | ||||||
EE_DELETE | XFELD | CHAR | 1(0) | Checkbox | XFELD | FB | CRM |