2849242 - Error Property 'ProjectVisibility' has invalid value 'N' when creating a Custom CDS view using I_EngagementProject as data source

When trying to use field ProjectVisibility field of view I_EngagementProject to create a custom CDS view you get error Property 'ProjectVisibility' has invalid value 'N'.

SAP S/4HANA Cloud.

When any field with data element having patter *FLAG, OData expects the field to return Boolean values.

Since field ProjectVisibility with data element /CPD/PWS_WS_CONFIDENTIAL_FLAG returns values as Y and N the error is raised.

Add a new calculated column "Confidential" in the Custom CDS View with OData Service and implement the below formula based on the field ProjectVisibility:

case I_EngagementProject.ProjectVisibility
when 'Y'
then 'X'
else ' '
end as Confidential

 CDS view, data element, ProjectVisibility, Project, Plan customer projects, cloud, I_EngagementProject, create custom cds views, Property, invalid value, In the context of Data Services an unknown internal server error occurred, Value N is not a valid truth value according to the XML format for ABAP, An exception with the type CX_ST_SERIALIZATION_ERROR was raised, but was not handled locally or declared in a RAISING clause. , KBA , i_internalproject , CA-CPD-SS , S/4HANA Public Cloud – Professional Service Projects , Problem