Characters that have hexadecimal display between HEX00 and HEX1F are not permitted

[iburcham]

All,

We have created a virtual info provider based on a Hana view of the ACDOCA table in Simple Finance.  We then have a Bex query on that virtual provider to display data.  A text field ,"SGTXT" - Document Line Item Text,  on the ACDOCA table is included in the expressed characteristics, but returns the "Characters between HEX00 and HEX1F are not allowed" error when displaying.  Since this is the Universal Journal, repopulating this field is not an option - is there a way, perhaps through the use of an exit variable to over come this display error?  In creating the BW characteristic for this Hana field, you have the ability to specify a Conversion Routine - could you code a conversion routine to say HEX00 display as ' ' or some other allow character?

[roland_szajko]

Hi

What type of virtual provider are you using? ODSV, HCPR, Virtual Cube?

Is the source of the virtual provider a Datasource, Infosource, Transformation or the HANA CV directly?

br

Roland

[iburcham]

Hi Roland,

It is a Virtual Cube, pointed directly at the HANA CV. 

[roland_szajko]

In that case I would suggest to have some sort of formula in your HANA CV, that converts the invalid characters of SGTXT to a space.

I think a

replace_regexpr( '([^[\x00-\x1F]]|[#|!])' in "SGTXT" with ' ' occurrence all ) 

could do the trick.