Note 619987 - No SID for the 0UNIT or 0CURRENCY characteristic

Symptom

Message BRAIN 070 appears when you load transaction data into an InfoCube or into an ODS object:"No SID for value '&' of characteristic <...> found".<...> is a characteristic that refers to 0CURRENCY or 0UNIT.

Other terms

0UNIT, 0CURRENCY, BRAIN070

Reason and Prerequisites

As of 3.0B Support Package 9 or 3.1C Support Package 4, only valid values are allowed for currencies and units.A unit is valid if it is in the T006 table and a currency is valid if it is in the TCURC table.Note that there is a conversion exit on the MSEHI field of the T006 table.
Since only internal values can be posted there, you must deactivate the conversion exit during the analysis of the T006 table with transaction SE16 (Settings > User parameter > Tab DataBrowser > Consider conversion exit cannot be selected).

Solution

If you do not find the value in the T006 or TCURC table, you must insert it. Note that the initial value is always allowed.
If you nevertheless receive this error message for the initial value, this means that there is an inconsistency in the SID table for the 0UNIT or 0CURRENCY characteristic. You can eliminate this inconsistency by calling the RSDMD_INITIAL_LINE_INSERT function module with I_CHABASNM = 0UNIT or 0CURRENCY.
If units are loaded in the external format, you must either convert these into the internal format in the transfer or update rules or change the extractor/file.The CONVERSION_EXIT_CUNIT_INPUT function module converts the external value of a unit into the internal value.