topic Re: Delete dependencies at database level in Application Development and Automation Discussions

Delete dependencies at database level

former_member634879 — Mon, 18 May 2020 14:13:09 GMT

Hi,

We have deleted a table extension and due to a misunderstanding we have not cleaned up all dependencies before. Re-implementing the enhancement to delete the dependencies encounters a problem because the deletion was created in a repair order. Is there a way to delete the remaining dependencies at a deeper level?

Re: Delete dependencies at database level

MateuszAdamus — Mon, 18 May 2020 14:21:11 GMT

Hi nw.

If these dependencies are in a separate Z* table, then you could probably use SE14 transaction to clear all data in the table. You'd need access to the SE14, obviously.

Regards,
Mateusz

Re: Delete dependencies at database level

former_member634879 — Mon, 18 May 2020 14:31:33 GMT

Hi Mateusz,

It was a standard SAP enhancement CI_PRPS. With se14, I can only edit the table itself (PRPS).

Re: Delete dependencies at database level

MateuszAdamus — Mon, 18 May 2020 14:40:30 GMT

Hi Nadine,

I understood the dependencies as records in the DB, which were dependent on the data from the deleted enhancement.

This is not the case, correct?

What are these dependencies you mentioned?

Regards,
Mateusz

Re: Delete dependencies at database level

former_member634879 — Tue, 19 May 2020 06:22:46 GMT

Hi Mateusz,

Yes, the dependencies are not in the table itself. The deleted extension was still used in other places. So I'm thinking about how I can find out where it was used and SAP stores everything in tables, so I assume that the connections are stored somewhere. It should be able to delete them.

Re: Delete dependencies at database level

MateuszAdamus — Tue, 19 May 2020 06:44:34 GMT

Hi Nadine,

Did you have custom data elements in this extension? If yes, and if you did not delete them, then I would look using the Where-Used option of these.

When it comes to ABAP source codes, these are stored in a table named REPOSRC. The codes are compressed and you won't be able to access them via SQL or other tools. You could use report RPR_ABAP_SOURCE_SCAN to search for the use of the removed fields in any source code.

Regards,
Mateusz

Re: Delete dependencies at database level

former_member634879 — Tue, 19 May 2020 07:00:02 GMT

Hi,

That sounds like a possibility, I'll look into it. Thanks for the tip.

Re: Delete dependencies at database level

Sandra_Rossi — Tue, 19 May 2020 11:59:59 GMT

You say: "Re-implementing the enhancement to delete the dependencies encounters a problem because the deletion was created in a repair order."

I don't see why it would be a so big problem. Can you clarify?