Alias for field name is not working in srv layer of CDS file for service declaration

[hmchnd]

I tried using alias for some fields of my entity but it does not showing record with alias name and showing incorrect column name of table issue.

1. Alias name decribed as below.
   entity LprPlantVh as select werks as plant , name1 as description from workcenters.LprPlantVh;

2. activity performed in SRV folder of SAP CAP in service.cds file.

[gregorwolf]

I would suggest you post your question in the CAP Q&A and provide the example based on the Bookshop. That way others can simply follow and try. Also use the code formatting capabilities to make it better readable.