Using ABAP Function module in CDS view

[Former Member]

Hello,

Could you please let me know if it is possible to use ABAP function module into CDS ?

The aim here is to convert quantity field with the FM MATERIAL_CONVERT_QUANTITY.

Thanks in advance.

Hicham

[horst_keller]

Do you have any idea what CDS is? If yes, how should that work?

[Former Member]

if i understood correctly, CDS view is defined for existing database tables. this CDS view serves to define the structure of an SQL view and represents a projection onto one or several Dictionary tables.

the question here is if it is possible to add a new column to my cds view for example :

• converted_value

and convert 1KG to 1000G with MATERIAL_CONVERT_QUANTITY ABAP FM instead of function UNIT_CONVERSION like bellow :

define view demo_cds_unit_conversion
with parameters to_unit:abap.unit(3)
as select from demo_expressions
{ id,
dec3 as original_value,
cast( 'MI' as abap.unit(3) ) as original_unit,
unit_conversion( quantity => dec3,
source_unit => cast( 'MI' as abap.unit(3) ),
target_unit => :to_unit,
error_handling => 'SET_TO_NULL' ) as converted_value,
:to_unit as converted_unit }

Thanks in advance.

Hicham

[horst_keller]

Exactly, "CDS view serves to define the structure of an SQL view". How should a SQL view of the database layer call an ABAP FM of the application layer?

[Jelena_Perfiljeva]

Google -> CDS view unit conversion site:sap.com -> looks like plenty of information

[Former Member]

hi,

Did you manage to consume bapi in cds view ?

[former_member477623]

Hi,

CDS Views are basically designed to interact the DB directly and CDS create entity in DB level so basically we are using native DB quarry in CDS. But for any ABAP function or class method there is a way we can use inside our CDS via AMDP, so we call it CDS view with table functions. for that we have to create AMDP class and method and inside our method we can call Function module or Bapi. Then we can use the AMDP class method in side our CDS view to achive our requarement but compare to other CDS views AMDP uses CDS will decrease your performance.

https://blogs.sap.com/2016/03/25/my-cds-view-self-study-tutorial-part-6-consume-table-function-in-cd...

Thanks,

Suman Sekhar Mohapatra

[srahemi]

you can use cds virtual element

[Sandra_Rossi]

(via ABAP class which calls the function module.)