BW, How to adjust SID table?

[#1]

I got some invalid record in SID table, and I don't found any data include PE - 100% in ADSO. How to delete record?

When I try to transfer master data from BW to BPC, it got invalid record error and I don't found any way to skip the invalid record and continuous

[roland_szajko · Accepted solution]

You can simply use the standard and official master data deletion for this purpose. Just tick in the flag to delete the SID-s:

https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/4a407d85acb51cece10000000a421...

[erdempekcan]

You can use RSRV to fix master data table inconsistencies.

[yi]

Hi Jacky,

Have you solved your issue?

Andrei

[shraddha_mundwadkar]

Hi,

Please check if ZPROJ_COD is an attribute of Project Dimension in ADSO? If yes then find out for which Projects the ZPROJ_COD is PE - 100% is used and try to exclude those projects and rerun the transfer. If it runs fine you will have to correct the attribute value PE - 100% or delete the value from those projects which are using it and then include the projects again and rerun. Until and unless you remove the Projects reference from ADSO you wont be able to delete the master data.

note that the validation runs and checks for the attribute values also for the dimension used in ADSO and not only for dimension values.

Thanks,

Shraddha