Purpose : How we can create custom fields based on some certain condition like arithmetic calculation or concatenation of two field or add to system time & System user name in CDS view.
Step 1: Open the App Custom CDS View in cloud.
Click on create to create custom CDS view
Click on Add Primary Data Source to add the primary data source.
Now Go to field selection and click on Add to add a calculated custom field in Custom CDS view.
Provide the Field label and ID.
Use the required function to populate the value in custom field.
Like for Concatenation use below function.
Apply the changes and publish the CDS view to see the data preview.
Similar way we can use various operations like covert field type, populate system time or user name,conversion ,cast and case statements as well.