Table History....

[former_member186775]

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

[Former Member]

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

[Former Member]

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

[former_member186775]

Hi Kaushal

Plz explain me about this sentence....

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.

....I am trying it out plz help..

[Former Member]

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

[former_member186775]

Thank you so much

kaushal....

If you could plz guide me on BRTOOLS tooo plzz

manjula

[Former Member]

Hi,

check

regards,

kaushal