Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

CDS View field listing w/correct field name as defined in DD (upper/lower case)

sap_cohort
Active Contributor
0 Kudos

Hi, I know I can get a CDS View field listing using some of the abap tables, but they seem to have the fields names all stored in upper case. The field names in a CDS View DD are often Upper and Lower case and I would like a field listing with the field names (upper/lower case) as they are defined in the DD.

The reason is that when referring to fields names in OData, the OData string I believe requires the field name to be as defined in the DD.

Anyone know how to get this kind of field listing for a CDS View?

1 ACCEPTED SOLUTION

joltdx
Active Contributor

Hi!

Check this blog post about ABAP-Managed Database Objects and How to Access Them and also this link about ABAP CDS Views on the SAP Help Portal.

If I've got my head wrapped around this correctly, I don't believe that information is available in the DDIC database tables the way you want it to be. The "CDS View" is an artefact in the database layer, and not in the ABAP layer. There is a representation of it that you can see in SE11 (with a different name than the CDS itself), and it is known by the data dictionary so that it can be used in SELECTS, for instance, in the ABAP code. But to the ABPA dictionary the field names are upper case.

So the information IS there in a database artefact in the HANA DB (in this case) but I don't know how to extract it in the format you need, if possible... Hope this helps a bit anyway...

2 REPLIES 2

joltdx
Active Contributor

Hi!

Check this blog post about ABAP-Managed Database Objects and How to Access Them and also this link about ABAP CDS Views on the SAP Help Portal.

If I've got my head wrapped around this correctly, I don't believe that information is available in the DDIC database tables the way you want it to be. The "CDS View" is an artefact in the database layer, and not in the ABAP layer. There is a representation of it that you can see in SE11 (with a different name than the CDS itself), and it is known by the data dictionary so that it can be used in SELECTS, for instance, in the ABAP code. But to the ABPA dictionary the field names are upper case.

So the information IS there in a database artefact in the HANA DB (in this case) but I don't know how to extract it in the format you need, if possible... Hope this helps a bit anyway...

sap_cohort
Active Contributor
0 Kudos

SE11 provides the ADT link. Not sure how to get at it, but it's there as you say.