cancel
Showing results for 
Search instead for 
Did you mean: 

Information regarding SAP Tables

Former Member
0 Kudos

HI All,

I am new to SAP.As a part of archiving project,we recently archived the entire SAP database using a tool.When we started archiving we stopped the SAP and all the jobs which are running to make sure that all the tables are stagnant.This is due to the fact that once we archive, we do a row count on the Oracle(SAP) and archived tales to make sure every thing is archived.

But unfortunately, As we archiving the oracle database(SAP) got restarted as there was a backup job which ran and restarted the server.Now when we completed the full archiving and did a row count comparision we found that the below tables have different counts from the Oracle(SAP) i.e source.I think that these tables are SAP metadata and when system got restarted due to the back p job, these tables might have been updated.

Please see the list of tables below and let me know whether these tables contain any Data which might e useful to the customer or is it just some metadata used by SAP and nothing else...

DBABARL

DBAML

DBATL

DBSNP

DDLOG

MONI

PAHI

SDBAD

SDBAH

SGOSHIST

SNAP

TBTCO

TBTCP

TSP01

TSP02

TSPEVDEV

TSPEVJOB

TST01

TXMILOGRAW

UTAB

VARI

Thanks in Advance

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

I understand that during the archiving, a process started the SAP system. Then, the SAP system was stand online a period of time during your archiving process. Under this circumstance, I strongly assume that the SAP standard good house keeping jobs updated those tables.

You can find the information on the note 16083 - Standard jobs, reorganization jobs.

Best regards,

Orkun Gedik

markus_doehr2
Active Contributor
0 Kudos

> Please see the list of tables below and let me know whether these tables contain any Data which might e useful to the customer or is it just some metadata used by SAP and nothing else...

Well - you can check the content of the tables in SE11 and SE16. Whether the data is used or not depends on the customizing of the system and the applications/modules used. Whether this is "only" metadata can only be determined by the customer himself.

Markus