what's the format of currency value in selection table?

[Former Member]

Hi,

i want to use a currency field in selection criteria, i set the it like:

IOBJNAME: Z_ORDER

S: I

OP: EQ

LOW: 12.0000

HIGH:

system always return error message: 299System error in program CL_RSR_CHABIT and from SET_BIT1-01- (see long text)

i want to ask what's the proper format of a currency value? (in the LOW field)

i tried 12.0000, USD12.0000, $12.0000, always get the same error message.

someone can help on this?

thanks

Perry

[rejish_balakrishnan]

hi,

Curr field possess value like USD,IND and so on.(and not 12.000 usd)

Eg;

You cannot combine a amount with currency field value.

Solution : define 2 fields one for amount and next for currency(curr) field.

IOBJNAME: Z_ORDER

S: I

OP: EQ

LOW: 120000

HIGH: 18000

IOBJNAME: Z_ORDER_curr

S: I

OP: EQ

LOW: ind

HIGH: usd

[Former Member]

Hi RBK,

i tried like this, but it still not work.

IOBJNAME: Z_ORDER

S: I

OP: EQ

LOW: 12.34

HIGH:

IOBJNAME: 0CURRENCY

S: I

OP: EQ

LOW: usd

HIGH: