Symptom
When using HANA SQL Script to query data into an ABAP internal table, the string field `json_data` is truncated if its length exceeds 5000 characters.
The truncation occurs during the mapping of the HANA query result to the ABAP internal table.
The issue is observed with the function `string_agg(t5.json_data, ' ' order by canum) as json_data`.
Read more...
Environment
SAP HANA 2.0
Product
Keywords
hana sql script, abap internal table, string truncation, json_data field, varchar limitation, nvarchar limitation, clob, nclob, hana query mapping, string_agg, data type limit, hana sql resolution, abap hana integration, sql cast nclob. , KBA , HAN-DB-ENG , SAP HANA DB Engines , HAN-DB-ENG-JSON , SAP HANA JSON Document Store , HAN-DB , SAP HANA Database , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview