Odata读取合集值

目录

应用范围

1.创建Header Table

2.创建Item Table

总结

应用范围

Odata通过关联创建Associations创建合集数据。通过Fiori获取时要一次性进行获取父子关系数据。

一、操作步骤

1.创建Header Table

2.创建Item Table

3.创建Odata

 4.创建关联association

5。Odata 实施类DPC_EXT 

/IWBEP/IF_MGW_APPL_SRV_RUNTIME~GET_EXPANDED_ENTITYSET.

METHOD /iwbep/if_mgw_appl_srv_runtime~get_expanded_entityset.DATA : it_out_tab  TYPE STANDARD TABLE OF zdeep_s,wa_out_tab  LIKE LINE OF it_out_tab,it_header   TYPE STANDARD TABLE OF zheader,wa_header   TYPE zheader,it_item     TYPE STANDARD TABLE OF zitem,wa_item     TYPE zitem.CASE iv_entity_set_name.WHEN 'HeaderSet'.SELECT * FROM zheader INTO TABLE it_header.IF sy-subrc = 0.SELECT * FROM zitem INTO TABLE it_item FOR ALL ENTRIES IN it_header WHERE id = it_header-id.ENDIF.LOOP AT it_header INTO wa_header.MOVE-CORRESPONDING wa_header TO wa_out_tab.LOOP AT it_item INTO wa_item WHERE id = wa_header-id.APPEND wa_item TO wa_out_tab-headertoitemnav.CLEAR : wa_item.ENDLOOP.APPEND wa_out_tab TO it_out_tab.CLEAR : wa_header,wa_out_tab.ENDLOOP.copy_data_to_ref(EXPORTINGis_data = it_out_tabCHANGINGcr_data = er_entityset ).ENDCASE.ENDMETHOD.

6.在抬头和行项目表中维护数据

6.在GATEWAY客户端 测试/sap/opu/odata/sap/***_SRV/HeaderSet?$expand=HeaderToItemNav 测试合集结果

{"d" : {"results" : [{"__metadata" : {},"Id" : "100","Name" : "MOUSE","Dept" : "DEPT1","HeaderToItemNav" : {"results" : [{"__metadata" : {},"Id" : "100","Sdept" : "DEPT-1A","Stock" : "22"},{"__metadata" : {},"Id" : "100","Sdept" : "DEPT-1B","Stock" : "44"},{"__metadata" : {},"Id" : "100","Sdept" : "DEPT-1C","Stock" : "76"}]}},{"__metadata" : {},"Id" : "101","Name" : "KEYBOARD","Dept" : "DEPT2","HeaderToItemNav" : {"results" : [{"__metadata" : {},"Id" : "101","Sdept" : "DEPT2-SM","Stock" : "115"},{"__metadata" : {},"Id" : "101","Sdept" : "DEPT-2C","Stock" : "129"},{"__metadata" : {},"Id" : "101","Sdept" : "DEPT-2D","Stock" : "251"},{"__metadata" : {},"Id" : "101","Sdept" : "DEPT-2M","Stock" : "009"}]}}]}
}

使用URI : /sap/opu/odata/sap/***_SRV/HeaderSet(‘100’)?$expand=HeaderToItemNav, HeaderToItem1Nav测试单条查询

总结

以上就是今天要讲的内容，本文介绍了使用Odata查询合集数据。

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！