SID missing in table

[Former Member]

Friends,

  In material master unfortunately deleted p and s table data in se14 tcode. after again loaded 0material_attr and  se14 create the database table and activate the p and s table.

In rsrv master is showing green but the transaction give error "

SID 126224 of chacteristic 0MATERIAL missing in SID table /BI0/SMATERIAL

Message no. RSRV023"

Material master is common for all transaction so Not able to repair.

Its happend in production so we cant load full.

Pl suggest if anyone face same issue in production...

[former_member199945]

Try to run this program RSDMD_CHECKPRG_ALL (DEV) using that iobj  0material , it will check inconsistencies. & Then to do RSRV tests.

[Former Member]

Hi Seshu,

   Already mentioned 0material master not getting any issue. i got error on transaction SID not matching.

[former_member199945]

For generatign of  SID's 0material there might be some inconstinecy (During changes) , if you run that program then inconsistencies may go & perform rsrv tests after running that program .

[Former Member]

Correct seshsu. Already done on RSDMD_CHECKPRG_ALL and repaired in RSRV.

But getting same error.

[former_member199945]

If possible, Do RSRV tests for the Info providers that are involved on 0material ,  There might be some inconsistency for related info providers.

[Former Member]

Hi below error taken from rsrv transaction wd 0material.

SID 126224 of chacteristic 0MATERIAL missing in SID table /BI0/SMATERIAL.

mention already not repairable.