I need to create an external view for a calculation view which has mandatory Input variable. I read from few posts that it is not possible to create an external view in this case. Is that the case or do we have an alternate solution to achieve?
As the online documentation clearly describes (External Views for SAP HANA Views, check chapter Notes), it is not supported to pass parameters to HANA column views via an external view.
Please can you check if you can use for instance a CDS view which implements all the logic, a CDS view which uses a CDS table function which calls the HANA view or an AMDP which calls the HANA View. All that top-down approaches give you the option to pass the parameters from the ABAP layer.