Timestamp Service: Performance Key Figures

DataSource Transactional Data: 0CRM_TSS_PKYF

Technical Data

Application Component	0CRM_SERVICE
Available as of Release	CRM 5.0
Shipment	NW 2004s
Content Versions	BI Content Add-On 2
RemoteCube-Capable	No
Delta-Capable	No
Extraction from Archives	No
Verifiable	No

Prerequisites

You have performed the required Customizing settings using the following business transaction:

Integration with Other mySAP Components ->Data Transfer to the SAP Business Information Warehouse ->Settings for Application-Specific DataSources (CRM) -> Settings for Extracting CRM Objects —> Define Performance Key Figures for Timestamp Service Analysis

Data Modeling

Delta Update

This DataSource uses the delta method AIED (after images with delete indicator) in combination with a generic delta, which is based on the timestamp TABLE_UPDATE_TS.

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
MANDT	Client	CRMD_TSS_EVENTS	MANDT
PROC_ANCHOR_GUID	GUID for a Transaction	CRMD_TSS_EVENTS	PROC_ANCHOR_GUID
PROCESS_IDENT	Analysis Process Identifier	CRMD_TSS_EVENTS	PROCESS_IDENT
PERF_KYF	Performance Key Figure	CRMD_TSS_EVENTS	PERF_KYF
PERF_KYF_DURA	Duration	CRMD_TSS_EVENTS	PERF_KYF_DURA
PERF_KYF_DURUNIT	Unit for Duration of Work	CRMD_TSS_EVENTS	PERF_KYF_DURUNIT
HEADER_GUID	GUID for a Transaction	CRMD_TSS_EVENTS	HEADER_GUID
OBJECT_GUID	GUID for a Transaction	CRMD_TSS_EVENTS	OBJECT_GUID
TABLE_UPDATE_TS	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	CRMD_TSS_EVENTS	TABLE_UPDATE_TS
RECORDMODE	BW Delta Process: Update Mode	CRMD_TSS_EVENTS	RECORDMODE
SE_HEADER_GUID	GUID for a Transaction	CRMD_TSS_EVENTS	SE_HEADER_GUID
SE_GUID	GUID for a Transaction	CRMD_TSS_EVENTS	SE_GUID
SE_PROCESS_TYPE	Transaction Type (Start Event)	CRMD_TSS_EVENTS	SE_PROCESS_TYPE
SE_ITEM_TYPE	Item Category (Start Event)	CRMD_TSS_EVENTS	SE_ITEM_TYPE
SE_EVENT_SRC	Timestamp Service: Event Source (Application)	CRMD_TSS_EVENTS	SE_EVENT_SRC
SE_STATUS	Status	CRMD_TSS_EVENTS	SE_STATUS
SE_STATUS_SCHEMA	Status Profile	CRMD_TSS_EVENTS	SE_STATUS_SCHEMA
SE_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	CRMD_TSS_EVENTS	SE_TIMESTAMP
SE_FL_INDICATOR	First-Event-Last-Event Indicator	CRMD_TSS_EVENTS	SE_FL_INDICATOR
EE_HEADER_GUID	GUID for a Transaction	CRMD_TSS_EVENTS	EE_HEADER_GUID
EE_GUID	GUID for a Transaction	CRMD_TSS_EVENTS	EE_GUID
EE_PROCESS_TYPE	Transaction Type (End Event)	CRMD_TSS_EVENTS	EE_PROCESS_TYPE
EE_ITEM_TYPE	Item Category (End Event)	CRMD_TSS_EVENTS	EE_ITEM_TYPE
EE_EVENT_SRC	Timestamp Service: Event Source (Application)	CRMD_TSS_EVENTS	EE_EVENT_SRC
EE_STATUS	Status	CRMD_TSS_EVENTS	EE_STATUS
EE_STATUS_SCHEMA	Status Profile	CRMD_TSS_EVENTS	EE_STATUS_SCHEMA
EE_DATE_TYPE	Timestamp Service: Date Type	CRMD_TSS_EVENTS	EE_DATE_TYPE
EE_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	CRMD_TSS_EVENTS	EE_TIMESTAMP
EE_FL_INDICATOR	First-Event-Last-Event Indicator	CRMD_TSS_EVENTS	EE_FL_INDICATOR

Extractor Logic

Archive-enabled: Archiving object CRM_TSSEVT