Skip to Content
Feb 16, 2022 at 02:58 PM

Is an AMDP respecting the filter values provided in an ON condition of an association in a CDS View?

123 Views Last edit Feb 16, 2022 at 03:08 PM 3 rev

Hello all,

given is the following scenario:

  • CDS View (1) is created on a table
  • CDS View (2) is defined as table function consuming an AMDP
  • CDS View (3) is consuming CDS View (1) as primary data source and has an association to the CDS View (2).

The question now is whether the AMDP is respecting the filter values specified in the ON condition of the association? Or is the AMDP executed on the entire data set?

As an example, with data:

  • CDS View (1) is providing data for Sales Organization 4711
  • CDS View (2) has a data set for the Sales Organizations 4711, 4712, 4713, 4714, 4715

Is the AMDP respecting the filter value 4711 (ON condition of the association in CDS View (3) ) and is only executed for the subset of data, or is the AMPD executed for all available Sales Organizations 4711, 4712, 4713, 4714, 4715?

Best regards