cancel
Showing results for 
Search instead for 
Did you mean: 

No SID found for value '*5.15 ' of characteristic 0LOC_CURRCY

Former Member
0 Kudos

Hi,

I have got this error while loading data data from R/3(2LIS_03_UM).

Please suggesr if any one come across such type of error.

Thanks,

Vijay

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Dear Vijay,

RSA1->SourceSystem->Select Source System, right click->TransferGlobalSettings..

regards,

Hari

Former Member
0 Kudos

Vijay,

Its invalid character problem, enter * in RSKC list and run the load.

OR

Go to PSA and remove this character then load from PSA .

OR

You can write code for this , let me know if you need the code.

Thanks

Ram

Former Member
0 Kudos

Hi Ram,

I have tryed changing the record value but still I got the same error.

Please let me know the process step wise how to overcome this error.

Your help would be appreciated greatly.

Many thanks,

Vijay

Former Member
0 Kudos

I think 0loc_currcy specifies the currency rather than the value..

cheers,

Vishvesh

Former Member
0 Kudos

Vijay,

Go to Transfer Rules, write the routine for 0LOC_CURRCY.

Code:

In the place of KNREF place the field name related to 0LOC_CURRCY.

DATA : I_KNREF LIKE TRAN_STRUCTURE-KNREF.

MOVE TRAN_STRUCTURE-KNREF TO I_KNREF.

IF I_KNREF0(1) = '#' or I_KNREF0(1) = '!'.

I_KNREF+0(1) = '?'.

ENDIF.

IF I_KNREF+0(1) = '{' .

I_KNREF+0(1) = ''.

ENDIF.

RESULT = I_KNREF.

  • Set Text To Upper case

TRANSLATE RESULT TO UPPER CASE.

  • Get Allowed Characters When Initial

  • And Store In Global Data Area For Subsequent Use

IF rsallowedchar-allowchar IS INITIAL.

SELECT SINGLE

allowchar

INTO (rsallowedchar-allowchar)

FROM rsallowedchar

WHERE allowkey = 'S'.

ENDIF.

  • Call Function To Convert Any Invalid Characters In RESULT

CALL FUNCTION 'Y_BIW_TEXT_CONVERT'

EXPORTING

allowchar = rsallowedchar-allowchar

CHANGING

RESULT = RESULT.

  • returncode <> 0 means skip this record

RETURNCODE = 0.

  • abort <> 0 means skip whole data package !!!

ABORT = 0.

Now load and see.

Thanks

Ram