Export data to excel hide some key field

[Joanna]

Hi, Experts,

I want to export data to excel through CDS View API,

But this CDS View have several key fields, I don't want to export detail data based on these key fields, just summary the data based one 1 key field.

So I set “Hidden” for some key fields, but no effect.

what's the function for this "Hidden", and how can I summary the data based on 1 key field in cds view?

RGDS

Joanna Qiu

[Varun_Agarwal · Accepted solution]

Hi Qiu,

The function of Hidden field is to hide certain fields when using the Custom CDS View in a API.

Note: The spreadsheet may contain more fields than those that are visible on the UI (for example hidden fields).

For ore details refer to https://help.sap.com/viewer/0f69f8fb28ac4bf48d2b57b9637e81fa/2008.500/en-US/1d77c396e7fc43bc94c46947....

Best Regards,

Varun