When to use Table Function

[vikash_pathak]

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

[pfefferf · Accepted solution]

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.

[joltdx]

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.