How to add leading blank in CDS view?

[kalfen_xu2]

As of now, if use string function in CDS view, the leading blank will be removed automatically, so I have requirement that add leading blank in some CDS view field. but how to archive this ?

[horst_keller]

SAP's documentation does not say that leading blanks are generally removed in string functions. Why do you think so?

https://help.sap.com/http.svc/rc/abapdocu_751_index_htm/7.51/en-US/index.htm?file=abensql_functions_...

[kalfen_xu2]

I use substring and lpad and replace string function in my CDS view ,after that the leading blank is disappeared, so I don't know which string function can I use to add leading blank