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