Error Message for currency (0Currency) during activation of DSO

[Former Member]

Hi guys,

data which is transfered from datasource to dso contains an value " * " for currency which is unknown for some key figures.

During the activation of the data in DSO an error is appearing: No SID for value " * " of characteristic 0Currency found.

Is there some solution for that error available?

I checked the values for currency which are stored in 0Currency master data. There is one value for empty currency.

I thought one solution is to remove the " * " currency in ERP, then the currency will not have the " * " value and no error would appear in BW.

The other is to create a new InfoObject for currency and add the value " * " in master data. Then with the assignment of the new currency InfoObject also an error should not appear.

Any ideas about that?

Thank you in advance for answering!

[Former Member · Accepted solution]

Hi,

0CURRENCY is a unit infoobject and would accomodate only unit currencies like USD,JPYAUD...etc

In your case, there is * value which is fed to the 0CURRENCY and system is not able to accomodate it as this is invalid data.

Delete the request from the DSO and edit the record in PSA with the correct currency value and re-load it to the DSO and activate the request.

Also report it to the business users so that they would correct the data at source system level.

Regards,

Sudheer.

Edited by: Sudheer Kumar Kurra on Jan 21, 2011 3:16 PM

[Former Member · Accepted solution]

Thanks but it is not possible to change the currency value for data in source system with the correct value for currency because the data is particularly old (from 2009 and 2008) and the amount of data is huge. It would take a long time to assign the correct value manually.

But I did it meanwhile an deleted the * value and now the field is blank again. Will have to wait for results.

Edited by: saplaz on Jan 21, 2011 3:34 PM

[Former Member · Accepted solution]

Hi,

Ya, you will have to make the value in PSA blank for the incorrect (*) value if you are not aware of the correct value and save it.

Load this request from PSA again and this time, data in DSO should get activated....SID generation during the data activation will go fine even if blank value exists for a particular info object, but not with the incorrect value. (in your case *)

This only solves your data loading part but when u report on this data with currencies blank for some records, user may not be able to analyze the data properly.

i suggest you find the appropriate currency value for all such records and manually change them in PSA.

it's up to you if u want to leave the field blank.....data activation still goes fine.

Regards,

Sudheer.

[Former Member · Accepted solution]

I understand. But the data with unclear * value are a thousands of datasets and it is not clear which currency is correct. Also it is historical data so that nobody of the department would be able to make changes in ERP.

Does it make sense to create a new currency infoobject (copy of 0currency) with one * value in it and assign this new infoobject to the key figures?

[Former Member · Accepted solution]

Hi,

you can check with your functional consulatnts first , with out unit or curency measure amount or cureency can not be updted,when it is checkin to create the SID it shows error.

option: if less records & you know currency for those records you can update mannually at PSA Level

if the records more you know the currecy write the code

if 0currncy = '*'

result = 'USD'

else.

result = '0currency'.

endif.

like that you write the code , if the currecny is one,

but for each record different currencies then you should discuss with your functionla consulatant should maiantain the currncy also.

Thansk & Regarsd,

sathish

[Former Member · Accepted solution]

I tried it for the new records without the * value.

In the view I´m using now is no * value for currencies.

The amount of new records is about 35.

I have deleted all requests PSA and DSO.

But the system loads the old records first from ERP. About 17 records with * value for currency.

Is there some cache I have to delete in addition to requests?

[Former Member · Accepted solution]

Until now I don´t know the currency values for unkown currencies. Because the unknown currencies are not maintained well in receipts. So the problem starts from the bottom and there is nobody as far as I know who can provide the exact information about the correct currency values.

[Former Member]

I uploaded the data with empty values for currencies.

So there are a lot of records with empty values for currency.

In BEx Analyzer the key figures are showing for these records for currency "ERROR".

Actual I can´t edit the huge amount of records with empty values for currency.

Is there some adjustment in query designer to not display values with ERROR and leave it blank?

I thought because in 0Currency master data for blank value is available there will not be an ERROR message if records with empty values for currency are available.

[former_member182516]

have you tried the below

you may need to upload the currency 'master data'

Normally this is done via transfer global setting from r/3,

rsa1 - source system - r/3 right click 'transfer global setting',mark currency, unit converstion, etc and 'execute'

Have you checked for the values in TCUR table.

if values are not maintained in the TCUR and if you want to manually maintain the vlaues follow the below steps

To manually enter the INR currency, go to SPRO -> SAP reference IMG -> General settings -> Currencies -> Check currency codes and click on new entries. You currency should follow the standard ISO format.

NOTE:Please do this activity only if transferring the global settings from source system did not fix the issue

[Former Member]

> have you tried the below
> 
> you may need to upload the currency 'master data'
> Normally this is done via transfer global setting from r/3,
> rsa1 - source system - r/3 right click 'transfer global setting',mark currency, unit converstion, etc and 'execute'
> 
> 
> Have you checked for the values in TCUR table.
> if values are not maintained in the TCUR and if you want to manually maintain the vlaues follow the below steps
> 
> To manually enter the INR currency, go to SPRO -> SAP reference IMG -> General settings -> Currencies -> Check currency codes and click on new entries. You currency should follow the standard ISO format.
> 
> NOTE:Please do this activity only if transferring the global settings from source system did not fix the issue

I think this has nothing to do with TCURR because there is the currency conversion maintained. And for SPRO i don´t have authorization and I think that an currency with * would not make sense to enter it via SPRO as a currency code.

[Former Member]

Hi,

You need create a formula on the keyfigure and use NODIM function Inorder to reomve the ERROR and just display the keyfigure value without any currencies.

Regards,

Sudheer.

[Former Member]

Will the use of NODIM() take effect for all data and not display the currency?

Is it possible to not display currency only where no value for currency is available? That means that datasets where currency is availalbe will show for example:

1000 EUR

2000 USD

3000

4000

5000 EUR

6000 RMB

7000

8000 EUR

[former_member182516]

Hi Saplaz,

NODIM take effect on all the data.

Let me ask you one thing

Can you explain me how you had judgeded that tcur has nothing to do with this and inorder to change the values manually in TCUR table the way is to go throug SPRO.

Can you tell me how will the master data will be get loaded for 0currency filed?

Regards

KP

[Former Member]

> Hi Saplaz,
> 
> NODIM take effect on all the data. 
> 
> Let me ask you one thing 
> Can you explain me how you had judgeded that tcur has nothing to do with this and inorder to change the values manually in TCUR table the way is to go throug SPRO.
> Can you tell me how will the master data will be get loaded for 0currency filed?
> 
> Regards
> KP

Hi prashanthk,

you are right with TCURR and how the master data will be loaded. But I´m only writing about my specific case and the problem is that I don´t have authorization for SPRO (and will not get it). Also I´m thinking that an * value for TCURR makes no sense from my point of view because there are currency conversions maintained EUR > USD for example. Or am I wrong?

Regards

saplaz