How do I store nested JSON objects directly in ABAP DDIC?

[Former Member]

ABAP Databases, oracle, MaxDB et al., are mostly RDBMS. Right now, I have a JSON structure that cannot be normalised and hence I want to store it as is.

What's the best way to achieve this? Is data cluster an option? Perhaps the only option?

Customer is on an older version of ERP. So, HANA and the like are ruled out.

[matt · Accepted solution]

Data cluster is most efficient. You could use string or xstring fields.

[Sandra_Rossi · Accepted solution]

Why most efficient than a simple database table with a string/xstring field? (see also locators for "big LOBs", in the ABAP documentation)

+1 for using a string/xstring table column

[matt · Accepted solution]

Your are right. For this scenario, it makes no difference. Data clusters should be used where you're storing ABAP data structures.

[horst_keller]

XSTRINGS in BLOBs