Issue with trailing spaces for DSO key figure field

[former_member1363188]

When I am loading data from DSO to Cube, it is throwing the following error:

"The unit/currency 112.000 with the value 'space' is assigned to the key figure /BIC/ZBRGEW with the value 112.000  ."

The issue is that I have to remove the trailing space for all the values of that particular field. Since condense and other trimming options are used for CHAR, I am wondering how it is done for Key Figures.

Your help would be appreciated. Thanks.

[surendra_p]

Hi VK,

You are loading data from DSO to Info cube right,

So,Please check the Data type of info objects used in both DSO as well as Info cube.

I think we always use Amount with Currency,Quantity with Unit Etc For key figure .

you are saying while loading Data from DSO to Info cube the key figure data having spaces.

If in you are not added in space as allowed symbol in RSKC T-Code then while loading DATA from PSA to DSO only you will get error SPACE is not allowed.

Please check there is any other issue.

Regards

Surendra

[former_member189845]

Hi

You can try the below

Use SHIFT statement to delete the leading spaces in a character field.

DATA V_CURR(17).

V_CURR = ITAB-CUR_FIELD.

SHIFT V_CURR LEFT DELETING LEADING SPACE.

WRITE / V_CURR.

Or Try with condense with No Gaps

Thx,

Siva

[former_member1363188]

Hi, it is not a CHAR field.

[former_member189845]

sorry I didnt get it, can you please be clear .. Is that v_curr is chat is that you mean ??

[former_member186399]

Hello,

Can you check whether PACK/UNPACK helps you

Regards

Gajesh

[former_member1363188]

PACK/UNPACK seems to be correction in the ECC. I am sending the data from DSO to Cube, maybe a routine might help?  Thanks.