Symptom
Custom OData Service returns an error message - Error occurred while processing property 'XYZ' of entity no. 1|Property 'XYZ' has invalid type '\TYPE=XSDDATETIME_ISO' when executing the custom Odata Service
XYZ - PDI field
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Administrator work center
- Select Odata Service Explorer
- Select Custom Odata Services
- Highlight the custom Odata Service
- Select Test button
- Select Execute button
System throws above error
Cause
Cause for the issue is that the Data Type of a PDI field is maintained as DateTime
Resolution
DateTime is no longer intended for direct usage. Use derived GDTs TIMEZONE_INDEPENDENT_DateTime, GLOBAL_DateTime, LOCAL_DateTime and LOCALOFFSET_DateTime instead.
The same is documented in Help Center - Date and Time (Reuse Library)
See Also
Keywords
datetime, XSCDATETIME_ISO, Error occurred while processing property, has invalid type , KBA , AP-RC-ODF , OData framework (C4C Only) , AP-RC-BDS-LM , ByDesign Studio Lifecycle Management , LOD-CRM-INT-DWB , Data Workbench , Problem