on 06-26-2008 6:08 AM
I have one urgent requirement of checking table history in SAP.
Basically what we want is :
1. The free space and growth( date wise) of the particular table in SAP.
2. The history i.e., the no. of records added, deleted, modified for a particular table by date wise.
We are aware that these things can be done at Oracle level and we dont have previlages at oracle
level and hence we tried with db02, st02 and could not able to retrieve above info.
I observed that space consumed in database is 92% ..now
what should i do....
manjula
hi,
to view table growth history :
- goto DB02
- on section tables and indexes > detailed analysis
- on object name > enter table name, eg. TST03
- hit button > history
here you can review table growth of table.
question no.2 afaik no standard SAP program can display what you need.
but a near approach is table CDHDR and CDPOS which record change document of transaction.
rgds,
Alfonsus Guritno
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
1. The free space and growth( date wise) of the particular table in SAP.
You can access history data on tables and indexes by calling the DBA Cockpit and choosing Space -> History -> Tables and Indexes in the navigation frame of the DBA Cockpit.
2. The history i.e., the no. of records added, deleted, modified for a particular table by date wise.
for that you need to activate table logging.
check http://help.sap.com/saphelp_nw04/helpdata/en/7e/c81ebb52c511d182c50000e829fbfe/frameset.htm
regards,
kaushal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
To be able to use the logging in transports, you must make the entry r3transoptions = recclient="XXX" in the transport control profile. The entry XXX can have the same value as the profile parameter Rec/Client.
the above settings is necessary only if you want to use the logging in transports. ( it is optional)
for activate table logging in application client you have to make following entry in instance profile
rec/client -> <client>
where <client> is your application client. i.e 100 or 300
so if you want to activate logging in transport also then you need to add following entry in transport profile. i.e TP_DOMAIN_SID.PFL
r3transoptions = recclient="<client>"
after changes in instance profile you need to restart sap server.
regards,
kaushal
User | Count |
---|---|
74 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.