how to retrieve the creation date of clients ?

[Former Member]

Dear all,

I have few DEV clients which are copied from Production clients. When want to perform client deletion I want to delete the oldest client in DEV. But which is the oldest client ?

Is there a table or tcode that can show me when are those DEV clients created ?

What I am doing now is very time consuming, i have to login to production, execute SCC3 and find out when is the client exported and what is the TR number. Then in DEV i execute SCC3 to find out which DEV is created with what TR number.

By doing this i will know

a.) The DEV client is a copy of PRD as per which date.

b.) and when is the DEV client created.

In SCC4, it has the information of when is the client changed, but not when it is created.

In SE16, table T000 refers to same info in SCC4 as well.

Your advice and input are highly appreciated.

Thanks.

Regards,

Kent

[JPReyes · Accepted solution]

You can go to SCC4 -> choose client -> Utilities -> Change Log -> Select a "From date" old enough to cover the creation date -> Execute -> the creation entry in the log should be under "Data record created" and you'll find the person, client, date and time of the creation.

Regards

Juan

[Former Member · Accepted solution]

Hi Juan,

Follow your steps, I got below output, but no "Data record created".

Parameters for Analysis:
         System ID:            PRD
         SAP Release:          700
         Client:               199
         Date :                28.05.2009
         Time:                 20:29:01
         User:                 KENT
Selected Period
         From (date/time)      22.05.2005 00:00:00
         To (date/time)        28.05.2009 20:28:18
Selected Customizing Objects:
T000             S Clients
Analysis without archived log data
No logs found for the selected period

Then I clicked on "Logging: Display status" it says "Logging is switched off".

Questions

a.) This will only work when the logging is turn on, right ?

b.) Assuming the logging is turn on and i manage to get the creation info, at table level how do i retrieve the same info ? Because if I have 10 clients, i hope to see all the info and dates at one glance.

Please advise.

Thanks.

Regards,

Kent

[JPReyes · Accepted solution]

Actually.. if you go to SCC3 and click "All clients" you'll see the creation date.

Regards

Juan

[Former Member · Accepted solution]

Hi Juan,

In SCC3, it will show those unwanted clients which have been deleted.

Anyway, thanks for the advice.

I still hope to see answer that involves table.

Regards,

Kent

[Former Member · Accepted solution]

Kent

I believe the table you are looking for is:

DBTABLOG

Where you would select on field:

TABNAME

Hope this helps!

PJ

[Former Member · Accepted solution]

Hi PJ,

There is no entry in DBTABLOG.

SE16 --> DBTABLOG --> "number of entries" = 0

Regards,

Kent