Keyfigure populated in Characteristic

[Former Member]

Hi All,

I have a characteristic in cube "Net Price" (CHAR 10) which stores the values coming from a key figure (CURR type).

Could anyone tell me how the entry for such a value be present in SID table for the characteristic?

i found that if actual KF value is 9.29.

then the value in characteristic is stored as " 9.29 "

i.e. with space before last digit

but if the value is full 10 digit it is stored as it is.

Am unable to filter in query using these values.

Any suggestions would be appreciated with points.

Regards,

Vidya.

[Former Member]

Write the update routine for this char as

CONDENSE <Net Price> NO-GAPS.

Regards, Siva

[Former Member]

Hi

The output length is proper.

i need to maintain all changes in prices for a material.

So price is a char so that records do not get aggregated in cube / query.

Regards,

Vidya

[Former Member]

Chk infoobject definition and see what is output length?

Also, is there any specific reason price has been defined as characteristics?