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

Large number of records exist in P/Q tables for characteristic ABC while corresponding SIDs are missing in the S 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

SID mismatch, orphan records, InfoObject consistency, data quality, SID recreation, custom cleanup, development systems, quality systems, housekeeping, key violation, load failure, P table cleanup, Q table cleanup, consistency repair, reload process , KBA , BW-WHM-DBA-MD , Master Data , BW4-DM-MD , Masterdata , Problem