Question Re: SID missing in table in Technology Q&A

SID missing in table

Former Member — Wed, 23 Apr 2014 06:13:44 GMT

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

Re: SID missing in table

RamanKorrapati — Wed, 23 Apr 2014 08:35:08 GMT

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

Re: SID missing in table

Former Member — Wed, 23 Apr 2014 09:05:52 GMT

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.

Re: SID missing in table

RamanKorrapati — Wed, 23 Apr 2014 09:10:21 GMT

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.

Re: SID missing in table

Former Member — Wed, 23 Apr 2014 09:23:22 GMT

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

Re: SID missing in table

Former Member — Wed, 23 Apr 2014 11:25:49 GMT

Hi Seshu,

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

Re: SID missing in table

Former Member — Wed, 23 Apr 2014 11:33:18 GMT

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 .

Re: SID missing in table

Former Member — Wed, 23 Apr 2014 11:46:37 GMT

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

But getting same error.

Re: SID missing in table

Former Member — Wed, 23 Apr 2014 12:57:45 GMT

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

Re: SID missing in table

Former Member — Thu, 24 Apr 2014 09:35:41 GMT

Hi venkatesan,

You will have to load entire master data again.

You have no option,

Thanks

Saurabh

Re: SID missing in table

Former Member — Thu, 24 Apr 2014 18:11:54 GMT

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

Re: SID missing in table

Former Member — Thu, 24 Apr 2014 18:14:59 GMT

Hi below error taken from rsrv transaction wd 0material.

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

mention already not repairable.