ASSOCIATION inside AMDP

[shubham_banerjee]

Dear Experts,

Can we use ASSOCIATION inside AMDP methods or only JOIN is permissible ? In other case, Table Function being a CDS artifact when implemented by an AMDP method, can it perform any operations other than returning a result set ? In which type of requirements shall we use a Table Function implemented by and AMDP method ?

Thanks in advance.

[shubham_banerjee]

Hi Both,

I found a post that indicates as following. If the same is permissible, then it's the solution of my doubt.

1. Create a TABLE FUNCTION, B with Parameters and without SELECT-OPTIONS and implement the same in an AMDP method.

2. Inside the AMDP method use Database Table A as the data source.

2. Create a CDS view and use the TABLE FUNCTION as a data source or as one of the data sources. Also perform JOIN/ ASSOCIATION between A and B in the CDS if needed.