How to view tables on S4HC

[former_member114268]

Hello All,

Can anyone tell how to view tables(SE16N/SE11/SE16) in S4HC?

[Sandeep_Kumar · Accepted solution]

Hi,

There is no SE16* functions in S/4HC, you may explore other options like custom cds views, custom analytical query etc which work on virtual data model based on underlyin tables/structures etc,,,

Best,

Sandeep

[former_member114268 · Accepted solution]

Thanks for your reply Sandeep

So in S4HC suppose i want to see some table level data like t030k,KNA1 etc. how can i check & on custom analytical query tile it showing error(Adaptation Transport Organizer (ATO) is not configured for the system.) & on custom cds tile also not showing properly data.

[MartyMcCormick · Accepted solution]

Hello

Do you have an error with custom analytical query tile? If so, can you provide more detail / screen shots? As Sandeep mentioned, viewing table level data using something like SE16 is not possible in S/4HC.

Thanks,

Marty

[Mathias_R_u_p · Accepted solution]

Hi together,

So far the app "Custom CDS Views" can be used to show a data preview. This is limited to 100 rows, however by creating a custom CDS view you can apply a filter to also find specific data. Another more comfortable option is to expose a CDS view as OData service (see https://blogs.sap.com/2018/01/23/create-cds-views-in-sap-s4hana-cloud-and-consume-them-as-apis/). This allows to download the data simply in Microsoft Excel format (just add URL parameter $format=xlsx - see https://help.sap.com/saphelp_nw74/helpdata/en/a2/4c8490449041b88b7890d299b57351/frameset.htm) or even access live data via Microsoft Excel (see https://www.youtube.com/watch?v=figt8pCOO0M)

We are also working on improving the View Browser to also provide access to data content. This is however only planned for early next year. Further details will be communicated in https://influence.sap.com/sap/ino/#/idea/225660 (also feel free to vote!)

Best regards,

Mathias

[former_member603011 · Accepted solution]

Thank you.