topic Using CDS Table function/AMDP in Application Development and Automation Discussions

Using CDS Table function/AMDP

Former Member — Mon, 21 Oct 2019 16:20:23 GMT

Hi Experts

I have created a CDS cube which has Company Code and GL Account as dimensions and EndingBalance as Measure. Now we need one more field called Average Monthly balance(which is calculated using a SAP Standard ABAP FM). To do it at the database level is it possible to wrap this as a CDS Table function implemented using AMDP method. If so can you direct me to sample code snipped where we call the ABAP FM Inside the AMDP Method.

(I did look up similar queries but did not find anything that had a code snippet for calling an ABAP FM. If there is one and i have missed it pls to post the link). Thanks.

Re: Using CDS Table function/AMDP

maheshpalavalli — Mon, 21 Oct 2019 18:35:04 GMT

You cannot call an FM inside an AMDP. Rewriting the code in hana SQL inside the AMDP is the only option.

BR,

Mahesh

Re: Using CDS Table function/AMDP

former_member1716 — Tue, 22 Oct 2019 03:53:58 GMT

Hello Meera R Corera,

CDS functionalities are part of Database layer, their purpose is to reflect the definition of an SQL View.

An ABAP FM belongs to the application Layer.

Hence it is not possible to for a database layer to call the FM from application layer.

Regards!