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_*.