£ symbol load to Bw 3.5

dataservices sap-erp-bw
1

I have a problem loading a free text field into BW that contains a £ symbol .

I can import the symbol in the field from source CP1252 codepage and see them in the sql staging table but on transfer to the BW transaction target it fails (stays amber). Had same problem before with apostrophe but expected £ symbol to be allowed.

If i strip out the symbol it loads fine .

Any advice welcome :slight_smile: nb: Bw is set to allow it . (user wants to see it)

BW 3.5 not unicode sits on Oracle d/base.

Wylie_Coyote (BOB member since 2011-09-08)

2

apologies for simple question here but how do you confirm your bw codepage setting required for the datastore set-up ?

Wylie_Coyote (BOB member since 2011-09-08)

3

Answer is report : RSCP0018.

Resolved issue with combination of codepage settings from source to staging sql table and target plus removal of ‘#’ and fiels starting with ‘!’ and replacement of ‘ with '.

Tip - be carefull of viewing your data in listcube or the change log and don’t export to excel.

I found that viewing in Se16 tables underlying the DSO or logs showed a true picture of the data without any gui conversion.

Wylie_Coyote (BOB member since 2011-09-08)

4

Thanks!

Werner Daehn :de: (BOB member since 2004-12-17)