Where-Clause in AMDP for table function

[former_member551365]

Hello there,

i created an AMDP for table function which should do the following:

1) Select the "root" record based on the where-clause of the CDS (head material)
2) Select (in a DO...END loop) all subsequent child nodes in a recursive call (bom objects)
3) Pass all data (root + child) as an union back to CDS

(Yes, of course i had a look at the "mat_bom_explode_key" amdp function, but as this can not be called via CDS, and also returns way too many fields, the performance of my own function is way better)

But i'm now facing a problem with the given where clause, as it seems, that only the RETURN SELECT is considering my where clause, but the previous ones ignore it...

e.g. If i try to select only one single materialnumber via the CDS or ABAP, it takes AGES, but if it put this single material number into the ADMP at the FIRST "root" select, then it runs insanely fast!

How do i have to adjust the AMDP, so the where-clause of the initial select-statement is used ONLY at the very first root-select - if this is possible at all?

Many thanks in advance!