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

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

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