topic Re: ABAP OO Interface for DB Access in Application Development and Automation Discussions

ABAP OO Interface for DB Access

Former Member — Wed, 21 Feb 2018 20:36:45 GMT

Hello guys,

I'm searching for a best practice solution for accessing Z-Tables. My idea is to create an Interface for the CRUD operation, which can be used for all tables.

Maybe there is even a possibility to generate this class for new Z-Tables.

IF_DB_CRUD

create, update, delete, read

What about using "type ref to data" or "type data" as import/export structure?

And what about "mass" activities (deleting, creating several entries)?

Regards

Christopher

Re: ABAP OO Interface for DB Access

matt — Wed, 21 Feb 2018 20:45:09 GMT

There was the persistence framework, but nowadays, I create a class for handling CRUD with the SQL in various methods. including those for mass operations.

Re: ABAP OO Interface for DB Access

pokrakam — Wed, 21 Feb 2018 21:25:22 GMT

Ditto to Matthew’s answer. I have thought about it but don’t see much benefit. The added complication to make it generic negate the benefits - because now every developer is forced to use references or whatever. By hardcoding the IO parameters we make it easier for devs to just do a data(foo) = zcl_foo_db->read( ‘123’ ).

So explicit classes for me are a trade off in the developer’s favour. Persistent classes did a nice job of generating it for you, and I could also add object specific code in there, but they have sadly not kept up with the times.

Another idea is to go for BOPF. It’s a beastly framework but oh so versatile.

Re: ABAP OO Interface for DB Access

iftah_peretz — Thu, 22 Feb 2018 17:29:27 GMT

Not everybody gets access to BOPF.

Re: ABAP OO Interface for DB Access

iftah_peretz — Thu, 22 Feb 2018 17:30:57 GMT

Hi,

If you want a good point of reference, take a look at report adbc_demo.

Update: Please see the comments for constraints and caveats.

Re: ABAP OO Interface for DB Access

retired_member — Thu, 22 Feb 2018 18:06:12 GMT

Hmm, this wasn't created for that ...

Re: ABAP OO Interface for DB Access

iftah_peretz — Thu, 22 Feb 2018 18:17:17 GMT

I agree, looking at it is enough to spot the difference, but why it is not a point of reference for CRUD operations as the OP asked?

Re: ABAP OO Interface for DB Access

former_member557751 — Thu, 22 Feb 2018 18:53:39 GMT

I mentioned it already somewhere else, but IMHO there is a need for a more lightweight solution compared to BOPF.

Re: ABAP OO Interface for DB Access

retired_member — Thu, 22 Feb 2018 20:58:11 GMT

Cause I have written that example to demo some capabilities of ADBC (in fact there's the same for EXEC SQL), but not for CRUD.

Re: ABAP OO Interface for DB Access

iftah_peretz — Thu, 22 Feb 2018 21:28:11 GMT

I think you switched demo_amdp and adbc_demo.

I do agree that adbc_demo aim is to show the ABAP database call interface API and not for CRUD, but I found that the OO structure of it includes Creation of rows (method insert_rows), Reading of rows (methods select_into*), Updating of rows (method update_rows) and Deleting rows (method delete_rows), so that's why I pointed at it in this context.

Nonetheless, if you feel it is misleading or out of place, just say the word and I'll delete the answer and comments and deactivate my account 😉

Re: ABAP OO Interface for DB Access

Jelena_Perfiljeva — Thu, 22 Feb 2018 21:59:37 GMT

If this is "Christopher" then who is "Tanja Schipper"? I'm confused... Please be aware that profile sharing is frowned upon on SCN.

Re: ABAP OO Interface for DB Access

Jelena_Perfiljeva — Thu, 22 Feb 2018 22:05:04 GMT

I was just reading about this in the 2011 Thomas Jung's book "Next generation ABAP Development" (it was still too advanced for my old job in 7.01 version) and it seemed a bit heavy-handed to me. So are you saying we don't really need those persistent object classes anymore? Phew!

Re: ABAP OO Interface for DB Access

retired_member — Fri, 23 Feb 2018 06:16:45 GMT

Ah come on ...

If by chance the example hit something that can be called CRUD, so be it.

Re: ABAP OO Interface for DB Access

retired_member — Fri, 23 Feb 2018 06:18:11 GMT

The name of the game is BOPF and its follow ups ...

Re: ABAP OO Interface for DB Access

matt — Fri, 23 Feb 2018 07:31:42 GMT

...deactivate account, and take up a career as lion tamer. 😉

Re: ABAP OO Interface for DB Access

iftah_peretz — Fri, 23 Feb 2018 07:37:30 GMT

I'm on it!

Re: ABAP OO Interface for DB Access

pokrakam — Fri, 23 Feb 2018 11:41:19 GMT

I hope its follow ups are easier to work with...

Re: ABAP OO Interface for DB Access

retired_member — Fri, 23 Feb 2018 12:18:11 GMT

MeToo

Re: ABAP OO Interface for DB Access

jdloranger — Fri, 23 Feb 2018 14:26:38 GMT

I too create custom global class to handle the SQL for my Z tables.