Skip to Content
0
Dec 24, 2020 at 02:39 AM

how to check whether a view is cds and get list of its field?

75 Views Last edit Dec 24, 2020 at 02:51 AM 2 rev

Hello:

Given a table name. Is there a method to check whether it's a table or a CDS view and get a list of its all fields including alias? Thx.

I find a FM DP_GET_FIELDS_FROM_TABLE which can get all fields. But it use the SQL view name not the CDS name. So suppose given a SQL clause , how to first get the SQL view name of it then get the fields list.