Download page Mapping Between Legacy and Harmonized Analytics Schemas.
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
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_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
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_*.