Skip to Content
0
Aug 03, 2023 at 06:47 PM

CX_SY_ITAB_LINE_NOT_FOUND during a get call of API Odata Service

437 Views Last edit Aug 03, 2023 at 06:53 PM 6 rev

Hello colleagues,

I am getting the following error CX_SY_ITAB_LINE_NOT_FOUND during a get call of my API Odata Service after adding a child entity to Service Definition:

image.png

Root Entity Interface View

define root view entity ZI_DM_CSORDER_ROOT
  as select from zdm_csorder_root as CSOrder
  composition [0..*] of ZI_DM_CSORDER_COMP as _Components
  ...
  { key guid,
	...
	_Components
  }

Child Entity Interface View

define view entity ZI_DM_CSORDER_COMP 
  as select from zdm_csorder_comp
 association to parent ZI_DM_CSORDER_ROOT as _csorder on $projection.Orderguid = _csorder.guid
{
  key guid               as Guid,
  orderguid          as Orderguid,
  ...
  _csorder
}

Root Entity Projection View

define root view entity ZC_DM_CSORDER_ROOT
  provider contract transactional_query
  as projection on ZI_DM_CSORDER_ROOT as CSOrder
{
  key guid,
  ...
  _Components : redirected to composition child ZC_DM_CSORDER_COMP
}

Child Entity Projection View

define view entity ZC_DM_CSORDER_COMP as projection on ZI_DM_CSORDER_COMP
{
    key Guid,
    Orderguid,
	...
	_csorder : redirected to parent ZC_DM_CSORDER_ROOT 
}

Service Definition

define service ZAPI_DM_CSORDER_ROOT {
  expose ZC_DM_CSORDER_ROOT as Orders;
  expose ZC_DM_CSORDER_COMP as Components;
}

Odata Service is working, when I remove child entity from service definition, but is not working with child.

What would you suggest, what I am doing wrong?

Attachments

image.png (158.8 kB)