Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Nested table in hana by using Calc views

I have a requirement to get data in the below format from hana, I have written a Calc view..but I am not sure how get to store the looping data (Awards, Wall of fame) by using Nested table. So that I can get the data in the below format. I am using Java Spring Framework to call the calc view.

Main table have to contain Awards and Wall of fame has nested tables.

{

  "Name": "A",

  "No": 89700,

  "Awards": [

    {

      "Award_key": 1,

      "Award_name": "Best Performer1"

    },

    {

      "Award_key": 2,

      "Award_name": "Best Performer2"

    },

    {

      "Award_key": 3,

      "Award_name": "Best Performer3"

    }

  ],

  "Wall_fame": [

    {

      "WF_key": 1,

      "WF_name": "Best Performer1"

    },

    {

      "WF_key": 2,

      "WF_name": "Best Performer2"

    }

  ]

}

Need help.

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question