How to export all the contents of CDS views to excel file?

[former_member610378]

Hi all,

By default, I am getting only 101 records.

I want to view all the contents of CDS view (more than 101) and export the same to excel file.

Please help.

Thanks,

[former_member132363 · Accepted solution]

Please check

KBA "2688661 - App: "Total Receivable" ��� How to export into Excel with all Customers included?

"https://launchpad.support.sap.com/#/notes/2688661 [View Article](https://answers.sap.com/questions/13238948/view.html)

I hope this answered your question! If it did, please mark it as the 'Best Answer' so I can continue learning and answering questions in the community.

[Feras_Al-Basha · Accepted solution]

Hello susheelkumar ,

Thank you for raising this point. Currently export using the app 'custom CDS views' during report previews is limited to 100 records. And the recommended solution would be simply to build a query on top of the CDS view and then export the required data without a record limit.

https://influence.sap.com/sap/ino/#/idea/225660

That being said, this limitation has been raised as an improvement request and I invite to you submit your vote.

Thank you,

Hope this helps,

Feras

[former_member610378 · Accepted solution]

Hi,

Thanks for response.

My query is...

say... I want to see all the records of cds view: I_SalesOrder which contains 500 records and export the same to excel file.

How could I get it?

Thanks,