system
#1
Is it possible to do something like SQL Server with a comma delimited list for a parameter in a WHERE clause inside of a ABAP dataflow?
Something like:
WHERE TABLE.COLUMN IN ( $PARAM )
having set $PARAM to ‘A, B, C’
Is there any way to do that?
mikebowen (BOB member since 2010-08-10)
Is this possible or am I out of luck?
mikebowen (BOB member since 2010-08-10)
system
#3
Bouncing this as I’m having the same isssue.
I can pass hardcoded values in ABAP DF’s ie.
WERKS IN (‘UK1’, ‘UK2’)
However if I try and use a global variable I just cannot get it to work and I’ve tried loads of different ways of setting the variable.
WERKS IN ($G_WERKS_List)
Has anyone got ideas?
ScoobyDoo (BOB member since 2007-05-10)
system
#4
Never, but really never got this working while this would have been extremely handy.
Johannes Vink (BOB member since 2012-03-20)
system
#5
Try pushdown_sql(‘Datastorename’,’{$P_IN_LIST}) in the where clause.
srinivaslikesit (BOB member since 2007-04-03)
system
#6
In the abap flow?
And as far as I know in a DF with SQL this either prevents a full push down or at least has a severe performance impact.
Johannes Vink (BOB member since 2012-03-20)