SAP Knowledge Base Article - Preview

3704365 - A Hana SQL script query into an Abap internal table truncates String field exceeding 5000 characters

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

SAP HANA, platform edition 2.0 ; SAP S/4HANA all versions

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.