Oct 25, 2018 at 07:12 PM

How to INSERT/ADD new records in already Archived area (NLS Table of ADSO)?

586 Views Last edit Oct 25, 2018 at 07:16 PM 3 rev

Dear Experts,

I have a requirement like I need to insert a new record into my NLS Table of an ADSO, the record occurs in between of already archived area.

I have tried below approach to Add a new record in NLS Table but didn't work.

1. INSERT/MODIFY Statement using ABAP Program.

2. From HANA Perspective, SQL INSERT Statement failed with Error “operation is not permitted: remote source is restricted to read-only queries”.

Both the case failing because of NLS Table Setting “Display/Maintenance not allowed.”

3. Data Archival Process failed, when I tried to run the DAP manually to INSERT a new record occurs between archived area, gives error "Selected area already completely archived".

Note:

I am not allowed to change the setting of NLS table.
I am not allowed to unlock the previous archived request.

Can you please provide me any alternate solution for this?

Thanks in Advance.