Question Re: When to use Table Function in Technology Q&A

When to use Table Function

vikash_pathak — Sat, 27 Mar 2021 05:47:44 GMT

Hello Friends,

I am new to CDS and AMDP, i read about CDS view and AMDP i understood about this too

but didn't get exact explanation about CDS table function, when Table function should be used?

if multiple return table is needed AMDP could be used otherwise CDS view is used,

Then what is the use of Table function and when it should be used?

Please share your knowledge .

Thanks

Vikash

Re: When to use Table Function

joltdx — Sat, 27 Mar 2021 06:16:21 GMT

Hi!

The super short answer is that CDS table functions implement AMDP table functions and are used in Open SQL statements.

Longer answer is in ABAP News for Release 7.50 – CDS Table Functions Implemented by AMDP.

Re: When to use Table Function

pfefferf — Sat, 27 Mar 2021 06:18:10 GMT

CDS Table functions are used for instance in case you want to integrate some HANA features, not available directly via the ABAP SQL or CDS layer, into your (Virtual-)CDS-Model. An example could be that you want to use SQL Window functions or some imperative logic.

As a CDS Table function is represented by a CDS entity, you can join/associate that CDS entity in CDS views/entities.