Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
Showing results for 
Search instead for 
Did you mean: 
ABAP CDS views provide a set of string functions and also support regular expressions from release 7.55. But sometimes your string manipulation requirements go beyond aforesaid capabilities. In this case my blog is for you.

Below is a perfect example, when CDPOS values which are saved as a plain text need to be properly formatted.

Number, percentage and date values need to be identified as such and formatted accordingly. What makes it even more challenging is a requirement to format numbers and dates as per user settings. All above can easily be done using data element casting.

Below function module does the trick. If identifies amounts, percentage and date values using regular expressions and format them according to user settings.


Active Contributor
Good one, Thanks documenting.
Yes, really good idea to use conversion exit to format string using CDS views!!!
0 Kudos

I think it's the feature of ALV and not the CDS View. I tried to display the data in Data explorer it didn't work.

I'm on 1909 and I'm in similar situation. While in ABAP the conversion exit is triggering but in CDS it's not.

define view zprep_message1
as select from zprep_message
case when msgnr = '022'
then cast( ltrim(msg, ' ') as zde_message_text )
else cast( ltrim(msg, ' ') as zde_message_text ) end as Message



0 Kudos

This is a good idea, but unfortunately when you publish the CDS to use it as an OData service, it doesn´t work, not only the conversion is not executed but also when retrieving the metadata it returns an error. Please consider before using it for string manipulation in FIORI apps.

Hi Pablo,

thank you for interest in my blog. Fiori apps of use of CDS view string manipulation is beyond the scope of the blog. If you find a solution to your requirement, please share with SAP community.

Regards, Uladzislau
Labels in this area