how could I see the time of last record entered in a table

[Former Member]

Hello

how could I see the time of last record entered in a table

I am desperately trying to find out

[Former Member · Accepted solution]

Hello,

In SAP there are different ways where this info can be found.

Sometimes extra fields exist in a specific table containing last change date/time.

Some table changes are also stored in the so called change documents.

More info on change documents can be found here:

[http://help.sap.com/saphelp_nw70ehp1/helpdata/en/2a/fa015b493111d182b70000e829fbfe/frameset.htm|http://help.sap.com/saphelp_nw70ehp1/helpdata/en/2a/fa015b493111d182b70000e829fbfe/frameset.htm]

Change documents are stored in tables CDHDR and CDPOS.

You can also activate table logging which records all inserts/updates/deletes in a specific table.

More info on table logging can be found here:

[http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eaf9446011d189700000e8322d00/content.htm|http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eaf9446011d189700000e8322d00/content.htm]

I hope this can help.

Wim

[Former Member]

I know there is also possibility of tracing tables (more used for customizing tables).

Does anyone knows how to do it in praxis?