No SID found for value '000' of characteristic 0PO_UNIT

[Former Member]

Experts,

I am loading data via DTP from DSO1 to DSO2. I have done this multiple times and have not faced any issue.

Today I changed some abap coding in END ROUTINE and then tried loading using DTP.

The DTP loads but when I try to activate the data in DSO, i get the following error:

"

No SID found for value '000' of characteristic 0PO_UNIT

Message no. BRAIN070

Diagnosis

Characteristic value 000 does not exist in the master data table of characteristic 0PO_UNIT. Therefore, this value could not be transformed into the internal SID.

"

Any ideas?

Thanks

[former_member226999]

Just to add, I had the same issue for 0DOC_CURRCY ...

The root cause was because the currency mapping for the keyfigure routine was not set

Under the currency section the target currency has to be mapped with source currency.

[Former Member]

Thanks Dennis for your help.

The END ROUTINE code was not working correctly and since PO_UNIT is been assigned via code, wrong field was getting assigned

[dennis_scoville4]

0UNIT is the Reference Characteristic for 0PO_UNIT and the value '000' isn't in 0UNIT. Go to RSA1, click on Source Systems in the left navigation bar, find the source system that the data was originally extracted, right-click on it and click on Transfer Global Settings. Check the 'Units of measurement' checkbox and the 'Update tables' radio button.

After you have done this, validate that the UOM of '000' has been updated to the T006 table. If it hasn't, the Best Practice would be to contact someone in your business to update the UOM in the source system and then re-transfer the Global Settings. However, you can update the table in BW, by going to tcode CUNI (this should be the last resort however).

[Former Member]

I had executed the first steps i.e. transfer of Global settings.

But the entry 000 does not exist after the updation. Not does it exist in R3.

My question isthat I am loading from DSO1 to DSO2. The DSO1 has not been updated from R3 and I was able to load from DSO1 to DSO2 lot of times and activate the data.

It just that I changed the END ROUTINE and after that I am facing this issue.

Any ideas?

Thanks

[Former Member]

Dennis,

In my DSO I have the setting "SID's Generation upon Activation" checked. If I uncheck it, the performance of query will go down.

Does it affect anything else. What do you suggest?

Thanks

[dennis_scoville4]

If you uncheck the SID generation field, your load performance shouldn't change, but you should get better performance during activation because it doesn't have to do the SID lookups (basically smaller SQL statements to get the data activated).

The area that you'll get performance issues with having this turned off, or unchecked, is if you're doing any joins within an InfoSet on a column in the DSO or if any of the InfoObjects are being used as a filter or variable.