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 Member]

Hi venkatesan,

You will have to load entire master data again.

You have no option,

Thanks

Saurabh

[Former Member]

Hi Vaidya, already loaded 0material , again it gives same..