Question Re: Insert into Collection(JSON Document store) using AMDP in Technology Q&A

Insert into Collection(JSON Document store) using AMDP

Mr_A — Mon, 12 Feb 2024 21:40:18 GMT

Hi,

I am not able to INSERT INTO 'Collection' using AMDP where as it working fine from SQL console on HANA studio. This collection is created under system schema

Error : "<Collection Name>" is unknown. ABAP objects and DDIC objects must be declared in the METHOD statement. Local names must start with ":" here.

Re: Insert into Collection(JSON Document store) using AMDP

Sandra_Rossi — Tue, 13 Feb 2024 06:19:51 GMT

Did you try ADBC instead of AMDP?

Re: Insert into Collection(JSON Document store) using AMDP

Sandra_Rossi — Tue, 13 Feb 2024 06:36:33 GMT

By the way, I see in one answer that it may work under user schema instead of system schema (cf. https://community.sap.com/t5/technology-q-a/amdp-select-from-document-store-collection/qaq-p/11946044)