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

[RamanKorrapati]

Hi,

Can you activate your master data and check it.

Use RSRV tests on master data and do the required correction.

RSRV--->test in transaction rsrv ---> all elementary tests--> masterdata -->

Check Flags in the SID Table of an InfoObject

Initial Values in the SID Tables and Master Data Tables for a Characteristic

Thanks

[Former Member]

Hi Ramanjaneyulu,

There is no issue in 0material when i check in rsrv but in transaction with all target material dimension wherever comes got that error in rsrv. not repairable.

i hope u understand.

[RamanKorrapati]

Can you check material sid(/bio/smaterial) table and value for sid - 126224.

it may have balnk. if its balnk then you need to maintain value in that blank.