Hi @DucourtyEtan ,
It seems to me that you can have some issue with filtering or paging.
I will share with you a simplified example of two custom entities with a parent-child relationship. There you also find the example of code that handles filtering, paging, and sorting functionality for custom entities.
ZMHL_C_CUSTOM_HEADER - parent custom entity.
@ObjectModel.query.implementedBy: 'ABAP:ZMHL_CL_CUSTOM_ENTITY'
@EndUserText.label: 'Header'
@UI: {
headerInfo: {
typeName: 'Header',
typeNamePlural: 'Headers',
title: { type: #STANDARD, label: 'Header', value: 'HeaderID' }
}}
define root custom entity ZMHL_C_Custom_Header
{
@UI.facet : [
{
id : 'Header',
purpose: #STANDARD,
type : #IDENTIFICATION_REFERENCE,
label : 'Header',
position: 10
},
{
id : 'Item',
purpose : #STANDARD,
type: #LINEITEM_REFERENCE,
label : 'Items',
position : 20,
targetElement: '_Item'
} ]
@UI.lineItem : [ { position: 10 } ]
@UI.identification : [ { position: 10 } ]
@EndUserText.label : 'Header ID'
key HeaderID : abap.numc( 3 );
@UI.lineItem : [ { position: 20 } ]
@UI.identification : [ { position: 20 } ]
@EndUserText.label : 'Description'
Description : abap.char(40);
_Item : composition [1..*] of ZMHL_C_Custom_Item;
}ZMHL_C_CUSTOM_ITEM - child custom entity.
@ObjectModel.query.implementedBy: 'ABAP:ZMHL_CL_CUSTOM_ENTITY'
@EndUserText.label: 'Item'
@UI: {
headerInfo: {
typeName: 'Item',
typeNamePlural: 'Items',
title: { type: #STANDARD, label: 'Item', value: 'Item' }
}}
define custom entity ZMHL_C_Custom_Item
{
@UI.facet : [ { id : 'Item',
purpose: #STANDARD,
type : #IDENTIFICATION_REFERENCE,
label : 'Item',
position: 10 } ]
@UI.hidden : true
key HeaderID : abap.numc( 3 );
@UI.lineItem: [ { position: 10 } ]
@UI.identification : [ { position: 10 } ]
@EndUserText.label : 'Item'
key Item : abap.numc( 2 );
@UI.lineItem: [ { position: 20 } ]
@UI.identification : [ { position: 20 } ]
@EndUserText.label : 'Description'
Description : abap.char( 40 );
_Header : association to parent ZMHL_C_Custom_Header on _Header.HeaderID = $projection.HeaderID;
}ZMHL_CL_CUSTOM_ENTITY - class with implementation for both custom entities Header and Item. Filtering and sorting functionality is implemented using the ability of SELECT statements with dynamic WHERE and ORDER BY clauses. Paging functionality is implemented by UP TO n ROWS and OFFSET clauses of SELECT statement.
CLASS zmhl_cl_custom_entity DEFINITION
PUBLIC
FINAL
CREATE PUBLIC .
PUBLIC SECTION.
INTERFACES: if_rap_query_provider.
PROTECTED SECTION.
PRIVATE SECTION.
ENDCLASS.
CLASS zmhl_cl_custom_entity IMPLEMENTATION.
METHOD if_rap_query_provider~select.
DATA: lt_header TYPE STANDARD TABLE OF zmhl_c_custom_header,
lt_item TYPE STANDARD TABLE OF zmhl_c_custom_item,
lv_order_by TYPE string.
lt_header = VALUE #( ( headerid = '001' description = 'Header 1' )
( headerid = '002' description = 'Header 2' )
( headerid = '003' description = 'Header 3' ) ).
lt_item = VALUE #(
( headerid = '001' item = '01' description = 'Item 1.1' )
( headerid = '001' item = '02' description = 'Item 1.2' )
( headerid = '001' item = '03' description = 'Item 1.3' )
( headerid = '002' item = '01' description = 'Item 2.1' )
( headerid = '002' item = '02' description = 'Item 2.2' )
( headerid = '003' item = '01' description = 'Item 3.1' ) ).
"Get Filters
DATA(lv_filter) = io_request->get_filter( )->get_as_sql_string( ).
"Get paging properties
DATA(lv_offset) = io_request->get_paging( )->get_offset( ).
"Get positive page size, to avoid -1
DATA(lv_page_size) = abs( io_request->get_paging( )->get_page_size( ) ).
"Get sorting
DATA(lt_sort_elements) = io_request->get_sort_elements( ).
LOOP AT lt_sort_elements ASSIGNING FIELD-SYMBOL(<fs_sort_element>).
lv_order_by = |{ lv_order_by }{ COND #(
WHEN <fs_sort_element>-descending = abap_false
THEN |, { <fs_sort_element>-element_name }|
ELSE |, { <fs_sort_element>-element_name } DESCENDING| ) }|.
ENDLOOP.
SHIFT lv_order_by BY 2 PLACES LEFT.
CASE io_request->get_entity_id( ).
WHEN 'ZMHL_C_CUSTOM_HEADER'.
"Apply filter, get table with all results
SELECT * FROM @lt_header AS header
WHERE (lv_filter)
INTO TABLE @DATA(lt_header_result).
"Apply paging and sorting, get requested part of results
IF lv_order_by IS INITIAL.
lv_order_by = |HEADERID|.
ENDIF.
SELECT * FROM @lt_header_result AS header
ORDER BY (lv_order_by)
INTO TABLE @DATA(lt_requested_header)
UP TO @lv_page_size ROWS OFFSET @lv_offset.
"set total count of results
IF io_request->is_total_numb_of_rec_requested( ).
io_response->set_total_number_of_records( lines( lt_header_result ) ).
ENDIF.
"set data
io_response->set_data( lt_requested_header ).
WHEN 'ZMHL_C_CUSTOM_ITEM'.
"Apply filter, get table with all results
SELECT * FROM @lt_item AS item
WHERE (lv_filter)
INTO TABLE @DATA(lt_item_result).
"Apply paging and sorting, get requested part of results
IF lv_order_by IS INITIAL.
lv_order_by = |ITEM|.
ENDIF.
SELECT * FROM @lt_item_result AS item
ORDER BY (lv_order_by)
INTO TABLE @DATA(lt_requested_item)
UP TO @lv_page_size ROWS OFFSET @lv_offset.
"set total count of results
IF io_request->is_total_numb_of_rec_requested( ).
io_response->set_total_number_of_records( lines( lt_item_result ) ).
ENDIF.
"set data
io_response->set_data( lt_requested_item ).
ENDCASE.
ENDMETHOD.
ENDCLASS.
Service binding in OData V4. Service definition:
@EndUserText.label: 'Custom Entity Service Definition'
define service ZMHL_Custom_Entity {
expose ZMHL_C_Custom_Header;
expose ZMHL_C_Custom_Item;
}Application demo:
I hope it will help you to solve the issue.
Best Regards,
Maryia
| User | Count |
|---|---|
| 66 | |
| 10 | |
| 8 | |
| 7 | |
| 6 | |
| 6 | |
| 6 | |
| 6 | |
| 6 | |
| 5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.