topic Re: Read DBTABLOG with function module in Application Development and Automation Discussions

Read DBTABLOG with function module

martin_svik2 — Thu, 06 Jul 2023 08:27:58 GMT

Hi,

i have to read entries in DBTABLOG for a specific table in my Z-report.

The very old Table DBTABLOG has a LRAW field for the content which cannot be read directly.

I have searched SAP Notes and searched this forum here, but there is no "simple" solution for that: the functions modules DBLOG_READ*..... also only shows the LRAW field. The solution with submitting RSVTPROT and get back the ALV list into the report is horrible.

So is there any simple function module/class/method for reading the changes in a table -> i need the old value of a field and the new field.

br Martin

Re: Read DBTABLOG with function module

jasmin_gruschke — Thu, 06 Jul 2023 09:47:08 GMT

Hi Martin,

you might have a look here: https://answers.sap.com/questions/1703877/read-dbtablog.html

Even better might be to have a look at the "state to the art" access to the application log, see https://help.sap.com/docs/btp/sap-business-technology-platform/reading-application-log (in case you are already on a system featuring those interfaces ;-)).

Best,
Jasmin

Re: Read DBTABLOG with function module

fedaros — Thu, 06 Jul 2023 09:49:10 GMT

Take a look on this thread:
How to read DBTABLOG entries

Re: Read DBTABLOG with function module

martin_svik2 — Thu, 06 Jul 2023 10:10:07 GMT

jasmin.gruschke

Thank you, but link 1 i have already checked, it is exactly the problem i have -> there is no solution provided

About Link 2: the application log has nothing to do with my issue. I need a database-field change , there the application log is the wrong place 🙂

br Martin

Re: Read DBTABLOG with function module

jasmin_gruschke — Thu, 06 Jul 2023 10:14:44 GMT

Hi Martin,
did you try FM DBLOG_READ_TABLE as mentioned in the first link?

Best,
Jasmin

Re: Read DBTABLOG with function module

RaymondGiuseppi — Thu, 06 Jul 2023 12:49:11 GMT

You could also look at my answer at Get old and new values from DBTABLOG table

Re: Read DBTABLOG with function module

martin_svik2 — Fri, 07 Jul 2023 08:18:04 GMT

Hi Jasmin,

of course i have tried, but this FM also delivers the data ONLY in the LRAW format 😞

Re: Read DBTABLOG with function module

martin_svik2 — Fri, 07 Jul 2023 08:20:14 GMT

raymond.giuseppi I already saw your answer before i posted my question here. But this is exactly what i said: i just want to have a simple "ready to go" FM or class/method for that issue. Why do we have to code it in that way ourself ? I mean sometimes SAP is questionable not to provide such things 😞 🙂

Re: Read DBTABLOG with function module

Sandra_Rossi — Fri, 07 Jul 2023 08:59:47 GMT

martin.svik2 ABAP stuff is full of missing API. It has been like that since the beginning. SAP local initiatives sometimes, but it's globally a desert of APIs. I guess it's a mix of business objectives (time/cost for developing), education, etc. Ask SAP people directly of course.

Re: Read DBTABLOG with function module

RaymondGiuseppi — Fri, 07 Jul 2023 09:18:59 GMT

There is a SAP site Customer Influence and Adoption for this kind of request to SAP

Start with public page influencing SAP

Re: Read DBTABLOG with function module

martin_svik2 — Mon, 10 Jul 2023 08:59:05 GMT

raymond.giuseppi Sorry, but i need this within the nexe 2-3 weeks. Asking SAP for an Adoption will take...............until 2030 or so 🙂

Re: Read DBTABLOG with function module

RaymondGiuseppi — Mon, 10 Jul 2023 09:34:35 GMT

(2030 is optimistic, isn't it?)

I'm afraid you'll have to create your own custom tool.