3424070 - Characteristic ABC: values from P/Q table do not exist in S table

There are huge number of records in the P/Q table, but not in the SID table. 

Data loading of such records failed with dump 

Category               ABAP Programming Error
Runtime Errors         MESSAGE_TYPE_X
ABAP Program           CL_RSDMD_UPDATE_MASTER_DATA===CP
Application Component  BW-WHM-DBA

DBSQL_DUPLICATE_KEY_ERROR 0 NEW_VALSID_SAVE-2-  

The RSRV checking or report RSDMD_CHECKPRG_ALL has error: 

Characteristic ABC: values from P/Q table do not exist in S table

RSDMD    267

• SAP NetWeaver 
• SAP BW/4HANA

KBA , BW-WHM-DBA-MD , Master Data , BW4-DM-MD , Masterdata , Problem