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.