Question Re: WebIDE - Database Explorer - Open Data dont display any data in CRM and CX Q&A

WebIDE - Database Explorer - Open Data dont display any data

Former Member — Fri, 19 Mar 2021 07:42:25 GMT

Hi Experts,

I am pretty new to SMC. I am trying to view a table data in Database Explorer using "Open Data" option. But I am not getting any results. Please let me know if I am missing anything here.

Regards,

Naveen

Re: WebIDE - Database Explorer - Open Data dont display any data

SCHNEIDERT — Fri, 19 Mar 2021 08:09:12 GMT

Hi Naveen,

so you really need the content of the table and not only the structure?

This is (as per my knowledge) unfortunately not possible on that way in SAP Marketing Cloud.

BR Tobias

Re: WebIDE - Database Explorer - Open Data dont display any data

KunalBansal — Fri, 19 Mar 2021 08:20:29 GMT

Hello navn.metts,

WebIDE is the tool to model your views and tables, and you won't be able to access the data here.

In case it's CRM system for BUT000 etc, you need to use se16 transaction itself.

Hope this clarifies.

Thank you.

Best Regards,

Kunal Bansal, SAP Marketing Consultant

Re: WebIDE - Database Explorer - Open Data dont display any data

Former Member — Fri, 19 Mar 2021 08:29:22 GMT

Hi Tobias & Kunal,

I followed this Link to view the table content. Is there any other ways of viewing the table contents in SMC.

Regards,

Naveen

Re: WebIDE - Database Explorer - Open Data dont display any data

SCHNEIDERT — Fri, 19 Mar 2021 10:54:20 GMT

Hi navn.metts,

yes, there are two apps, called Customer Data Return - Extraction and Customer Data Return - Provisioning which you could use to extract the data and download it as a zip file which includes then xml files which hold the data for the specific tables.

Here you can find the information about how to use them and trigger such a file download: https://help.sap.com/viewer/a630d57fc5004c6383e7a81efee7a8bb/2011.500/en-US/74db242020e848ddb64014d54979b8e0.html

Hope that helps.

BR Tobias