I am trying to create an AMDP for a CDS view.
Implementation of table function:
METHOD <method_name>BY DATABASE FUNCTION FOR HDBLANGUAGE SQLSCRIPTOPTIONS READ-ONLYUSING <view_entity_name>.RETURNSELECT id_1, id_2,ROW_NUMBER( ) OVER( PARTITION BY ...
Hey,
I would like to count the records that are associated to the same ID.
For example:
ID | DOCUMENT_NUMBER | COUNT
1000 200 1
1000 300 2 2000 400 1 3000 500 1 3000 ...
I am using the following steps to prevent the client issue:Insert "@ClientHandling.type: #CLIENT_DEPENDENT" in the table function definitionProvide the client as a parameter to the table functiondefine table function <table_function_name>with paramet...
Hey,I tried the suggested approach. However, when I use the mentioned additions then I am not allowed to use the "FOR TABLE FUNCTION <table_function>" line.CLASS-METHODS get_by_cndn_noAMDP OPTIONS READ-ONLYCDS SESSION CLIENT current.* FOR TABLE FUNC...
In my case I generate the original table using the following snippet:define view entity <view_name>
as select from <view_1>
inner join <view_2> on <view_2>.field= <view_1>.field {
...
}
group by
...The above view would provide the following outp...
