Upload Error

[Former Member]

Hello:

The delta upload jump the short error:

Error Convert,Foreign Currncy ->Local Currncy 0.000000000000000E+00 not found ,Document 000200003.

How to solve the problem,pls give me some advice.

Regards&Thanks

zagory

[edwin_harpino · Accepted solution]

hi Zagory,

check if helps oss note 527076

also check oss notes 727481,385790,385297

may help if you can specify what datasouce/infosource

and from psa-ods or ods-cube or ?

527076

Symptom

During Upload from PSA to Data Targets/Infoprovider (Infocube 0CRM_C04),error appears in Currency conversion for Opportunities

Error Convert. Foreign Currncy -> Local Currncy

0.0000000000000000E+00 not Found, Document0000000

Other terms

Currency conversion, Update rules

problem in currency translation, Infocube 0CRM_C04, ODS 0CRM_OPPH,

0CRM_OPPT_H

Reason and Prerequisites

Check for zero valued currencies not maintained in the update rule for

opportunity header Infocube (0CRM_OPPH) update rule(for currency

conversion).

(Note released on 11.06.2002. No change in the content of the note)

Solution

Change the update rules as follows:

For the update rule of Infocube (0CRM_C04), Double click on the update rule Technical name: 80CRM_OPPH

1. Go to the routine of 'Budget Sales Prospect in ref_currency'.

Change the coding as follows:

Rate = COMM_STRUCTURE-CRM_EXCRAT.

IF NOT COMM_STRUCTURE-CRM_BUDGBP IS INITIAL AND

COMM_STRUCTURE-CRM_CURREN NE COMM_STRUCTURE-crm_refcur

*code added+++++++++++++++++++++++++++++++++++++++++++++++++++++

AND NOT COMM_STRUCTURE-crm_refcur is initial AND

NOT COMM_STRUCTURE-CRM_CURREN is initial.

*end code added++++++++++++++++++++++

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'

2. Go to the update rule of 'Expected Sales Volume in ref_currency'

IF NOT COMM_STRUCTURE-CRM_EXPREV IS INITIAL AND

COMM_STRUCTURE-CRM_CURREN NE COMM_STRUCTURE-crm_refcur

*code added+++++++++++++++++++++++++++++++++++++++++++++++++++++

AND NOT COMM_STRUCTURE-crm_refcur is initial AND

NOT COMM_STRUCTURE-CRM_CURREN is initial.

*end code added++++++++++++++++++++++

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'

3. Go to the update rule of 'Weighted Sales Volume in ref_currency'

*code delete start++++++++++++++++++++++++++++++++++++++++++++++

IF NOT REV_EXP IS INITIAL AND

*code delete end

*code added start++++++++++++++++++++++++++++++++++++++++++++++

IF NOT COMM_STRUCTURE-crm_exprev IS INITIAL AND

*end code added++++++++++++++++++++++

COMM_STRUCTURE-CRM_CURREN NE COMM_STRUCTURE-crm_refcur.

US_RATE_TYPE = COMM_STRUCTURE-CRM_EXCTYP.

IF US_RATE_TYPE EQ SPACE.

US_RATE_TYPE = 'M'.

ENDIF.

ENDIF.

*code delete start++++++++++++++++++++++++++++++++++++++++++++++

IF NOT REV_EXP IS INITIAL AND

COMM_STRUCTURE-CRM_CURREN NE COMM_STRUCTURE-crm_refcur.

*code delete end

*code added start++++++++++++++++++++++++++++++++++++++++++++++

IF NOT COMM_STRUCTURE-crm_exprev IS INITIAL AND

COMM_STRUCTURE-CRM_CURREN NE COMM_STRUCTURE-crm_refcur AND

not COMM_STRUCTURE-crm_refcur is initial and not

COMM_STRUCTURE-CRM_CURREN is initial.

*end code added++++++++++++++++++++++

4. Go to the routine for 'Expected Sls Vol. in ref_curr(Weighted by

System)'

*code added start++++++++++++++++++++++++++++++++++++++++++++++

IF NOT COMM_STRUCTURE-CRMSYSPROB IS INITIAL OR

NOT COMM_STRUCTURE-CRMSYSPROB = 0.

*end code added++++++++++++++++++++++

if COMM_STRUCTURE-recordmode = 'X'.

SYS_REV_EXP = - COMM_STRUCTURE-crm_exprev / 100 *

COMM_STRUCTURE-CRMSYSPROB.

else.

SYS_REV_EXP = COMM_STRUCTURE-crm_exprev / 100 *

COMM_STRUCTURE-CRMSYSPROB.

endif.

*code added start++++++++++++++++++++++++++++++++++++++++++++++

ENDIF.

*end code added++++++++++++++++++++++

*code delete start++++++++++++++++++++++++++++++++++++++++++++++

IF NOT COMM_STRUCTURE-CRM_BUDGBP IS INITIAL AND

COMM_STRUCTURE-CRM_CURREN NE COMM_STRUCTURE-crm_refcur.

*end code delete++++++++++++++++++++++

*code added start++++++++++++++++++++++++++++++++++++++++++++++

IF NOT COMM_STRUCTURE-CRM_EXPREV IS INITIAL AND

COMM_STRUCTURE-CRM_CURREN NE COMM_STRUCTURE-crm_refcur AND

not COMM_STRUCTURE-crm_refcur is initial and not

COMM_STRUCTURE-CRM_CURREN is initial.

*end code added++++++++++++++++++++++

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'

[Former Member]

Hi,A.H.P:

Ur advice is full point answer,and the routine code is same as note.

And when I edited code by note 527076 and saved.There is a short jump:Unspecified error in the update.So I edited code didn't save.Why heppened this error?

Hope its clear!Can you give me other help.

Regards&Thanks

zagory