Skip to Content
0
Jan 06, 2012 at 01:35 PM

using parameters in filter in a CE_PROJECTION

44 Views

Hi,

I am trying to build a filter with parameters in my CE_PROJECTION statement.

this is working, but it is fixed, so I need to use parameters

lt_fat2 = CE_PROJECTION(:lt_fat1,

["MANDT", "XBLNR", "BLDAT", "AWKEY", "BUKRS", "VL_SERV"]

, ' "BUKRS" = ''1000'' ' ) ;

So I wrote this and it compiles, but it does not matches any records (and there are records to be matched, as shown by the fixed statement!)

lt_fat2 = CE_PROJECTION(:lt_fat1,

["MANDT", "XBLNR", "BLDAT", "AWKEY", "BUKRS", "VL_SERV"]

, ' "BUKRS" = '':P_BUKRS'' ' ) ;

may be the font is not clear but I am using double-quotes on BUKRS (field name) and double single-quotes on P_BUKRS (parameter) and in 1000 (in the frist statement).

The value in the parameter is 1000, I tested it, but it is not finding any records with BUKRS = 1000 when using the parameter. Is there anything wrong with the syntax I am using?

thanks for the help.

regards,

Mauricio