topic Re: Table data log maintenance in Application Development and Automation Discussions

Table data log maintenance

Former Member — Wed, 06 Sep 2017 13:36:41 GMT

Dear Friends,

I have a 'Z' Table with 40 fields. Here I need to maintain log for each field i.e changed by user, changed on for each field.

Please suggest me the table structure for the same.

Current structure -

Field1, Field2,....Field40 Created_by, Created_on, Changed_by, Changed_on

Expected desire output-

Field1, Created_by, Created_on, Changed_by, Changed_on, Field2, Created_by, Created_on, Changed_by, Changed_on................Field40, Created_by, Created_on, Changed_by, Changed_on

Re: Table data log maintenance

pokrakam — Wed, 06 Sep 2017 13:47:42 GMT

You can just use bog standard SAP change documents: link

Re: Table data log maintenance

retired_member — Wed, 06 Sep 2017 14:55:37 GMT

Or standard logging.

Re: Table data log maintenance

pokrakam — Wed, 06 Sep 2017 21:13:47 GMT

I always understood that to be more of a basis/DB level functionality, more technical and not really suitable for business data.

And there is also the newer Audit Trail functionality, which also seems to suggest that that is more business-y and table logging more techie...?

Re: Table data log maintenance

retired_member — Thu, 07 Sep 2017 05:43:47 GMT

Hmm, well, there's a bunch of logging mechanisms out there. The table logging that can be set as a technical attribute of any database table is the most basic one. Since the question was posed in ABAP Development, I think it worth to mention it. In the end, the user has to decide which of the logging mechanisms fits him/her best, depending on benefits and limitations. This also includes the "technical" table logging, and as far as I know, there are business tables for which table logging is switched on. It is good, that you point out, that there are other (and maybe better) possibilities.

Re: Table data log maintenance

Former Member — Fri, 08 Sep 2017 07:36:00 GMT

Hey Friends,

Thanks for the comment on my question. Let me check and will get back to you.