Dynamic start where in select hierarchy

[BhargavaReddy]

Hello Experts,

Would it be possible to write a hierarchy select statement (in ABAP / CDS / CTE) with dynamic start where-conditions?

below is a sample code

    SELECT FROM HIERARCHY( SOURCE demo_cds_parent_child_source
                           CHILD TO PARENT ASSOCIATION _relat
                           START WHERE id = 'A'
                                    OR id = 'D'
                           SIBLINGS ORDER BY id
                           MULTIPLE PARENTS ALLOWED)
           FIELDS id,
                  parent
           INTO TABLE @DATA(asql_result).

Below is the code I'm expecting. But it won't work and shows a syntax error like 'A Boolean expression was expected'

. DATA(lv_where) = | ID = 'A' OR ID = 'D' |.

SELECT FROM HIERARCHY( SOURCE demo_cds_parent_child_source
                           CHILD TO PARENT ASSOCIATION _relat
                           START WHERE(lv_where)
                           SIBLINGS ORDER BY id
                           MULTIPLE PARENTS ALLOWED )
           FIELDS id,
                  parent
           INTO TABLE @DATA(asql_result).

Thank you.

Best Regards,

Bhargava

[Sandra_Rossi]

Missing spaces + missing @ ? (NB: parentheses are optional)

WHERE @lv_where 

[lenapadeken]

Based on the syntax diagram of START WHERE and testing, it seems that dynamically specified relational expressions cannot be used here.

[Sandra_Rossi]

Lena is right, only fixed values are permitted, not dynamic values!