Mapping Between Legacy and Harmonized Analytics Schemas

ABAP Agent version 20.11.0 comes with a new harmonized Analytics API connector intended to reduce number of custom analytics schemas used by ABAP Agent. When harmonized connector is used, new custom harmonized schema names (schema groups) are used instead of legacy schema names.

Harmonized schemas contain fields sapTabname (SNP CrystalBridge® Monitoring Detail Table) and sapSchema (Legacy schema name) that can be used to easily migrate custom dashboards from legacy to harmonized schemas. Change source schema from legacy to harmonized name and add a new WHERE condition with sapTabname = <technical table name> or sapSchema = <legacy schema name> to existing queries.

Harmonized schemas contain fields from multiple legacy schemas, so it is recommended to select only relevant subset of fields instead of all harmonized schema fields.

Harmonized Schema Name	Legacy Schema Name	SNP CrystalBridge® Monitoring Detail Table
sap_bw_data	bw_process_chain_details	/DVD/MON_BW_S_PC_DETAIL
	bw_query_runtime_details	/DVD/MON_BW_S_QUERY_RUNTIME
	bw_process_chain_step_details	/DVD/MON_BW_T_PC_STEP_DET
sap_pi_data	pi_status_messages	/DVD/MON_PI_D1
	pi_channel_errors	/DVD/MON_S_PI_CHANNELS
	pi_message_errors	/DVD/MON_S_PI_MESSAGES
	pi_scenario_details	/DVD/MON_T_PI_SCEN_AGGR_DET
sap_log_data	abap_runtime_errors	/DVD/MON_S_DUMP_DETAILS
	system_logs	/DVD/MON_SLGINF2
	application_logs	/DVD/MON_S_APPLOG_DETAILS
	sap_landscape_transformation	/DVD/MON_S_SLT_DETAILS
sap_workload_data	sap_workload_transaction_profile	/DVD/MON_STAT_APPD
sap_workload_data	sap_workload_rfc_profile	/DVD/MON_STAT_APPD_RFC
sap_analytics_data_1	sap_qrfc_details	/DVD/MON_S_QUEUE_DETAIL
	monitored_bg_jobs	/DVD/MON_S_BG_JOB_DETAILS
	sap_locks	/DVD/MON_T_LOCK_DETAIL
	sap_cloud_connector	/DVD/MON_CLC_D01
		/DVD/MON_CLC_D02
		/DVD/MON_CLC_D03
	sap_rfc_cross_system_locks	/DVD/MON_S_RFC_LOCKS
	cancelled_update_requests	/DVD/MON_S_UPD_CANCELLED
sap_idoc_data	idocs_details	/DVD/MON_IDOC_D1
sap_idoc_data	idoc_values_detail_table	/DVD/MON_IDOC_S_DT
sap_biq_documents	sap_biq_documents	/DVD/APPD_BIQ_DOCUMENTS
sap_hana_data	hana_changed_parameters	/DVD/MON_HDBPARC
	hana_expensive_statements	/DVD/MON_HDB_SQL_EXP_STMT
	hana_alerts	/DVD/MON_HDB_S_ALERT_LIST
	hana_blocked_transactions	/DVD/MON_HDB_S_BLOCK_TRANS
	hana_replication_errors	/DVD/MON_HDB_S_REPLICATION
	hana_all_thread_info	/DVD/MON_HDB_T_THREAD
	hana_threads_connection_overview	/DVD/MON_HDB_T_THR_CONN_AGG
	hana_threads_connection_details	/DVD/MON_HDB_T_THR_CONN_DET
	hana_threads_connection_job_details	/DVD/MON_HDB_T_THR_CONN_JOB
	hana_threads_jobworker_overview	/DVD/MON_HDB_T_THR_JOBW_AGG
	hana_threads_jobworker_details	/DVD/MON_HDB_T_THR_JOBW_DET
	hana_threads_jobworker_job_details	/DVD/MON_HDB_T_THR_JOBW_JOB
sap_custom_data_1 sap_custom_data_2 sap_custom_data_3 sap_custom_data_4	<custom schema name>	<CUSTOM TABLE>

The same mapping and more details can be seen under Monitoring Connector Mapping in section KPI Detail Tables. Clicking on values in Custom event type (SNP CrystalBridge® Monitoring Detail Table) column reveals a list of fields in this table. These fields are mapped 1:1 to both legacy and harmonized custom schemas.

When custom schema field name and type conflicts occur, the harmonized connector adds the SNP CrystalBridge® Monitoring Detail Table value as field name prefix (example: /DVD/MON_IDOC_D1-DIRECT instead of DIRECT). This is mostly relevant for custom harmonized schemas sap_custom_data_*.