Bind data to table from multiple entity set

[former_member248760]

Hi,

I need to bind data to table from two separate entities. VBAK & KNA1.

currently the data is binded to table via

oTable.bindAggregation("items", {

  path: "/VBAK",

  template: oItemTemplate,

  filters: filters

Table contains fields from both VBAK AND KNA1. Need the address of KUNNR from KNA1 and display it as title.

<items>

     <ColumnListItem  id="colListItems">

  <cells>

  <ObjectIdentifier text="{Vbeln}"/>

  <Text text="{Kunnr}"

  title = ""/>                                   --------> NEED TO GET ADDRESS FROM KNA1 and display it.

  </cells>

  </ColumnListItem>

  </items>

How to achieve this......

[former_member232384]

If you want to use multiple entityset with one request,

you have to use Navigation.

And at client-side, call it by this code.

...../VBAK?$expand=KNA1

and bind it

<items>

     <ColumnListItem  id="colListItems">

  <cells>

  <ObjectIdentifier text="{Vbeln}"/>

  <Text text="{Kunnr}"

  title = "KNA1/Title"/>                                   --------> NEED TO GET ADDRESS FROM KNA1 and display it.

  </cells>

  </ColumnListItem>

  </items>