Regarding Database's Table history collection

[Former Member]

Hello,

We have very strange requirment to collect database table's history.

Requirnment is:

We have PSAPSR3 Schema, i have to collect last 4-5 months growth (Up/Down) history from current date.

i am doing this thing using DB02 tx.code from tablespace history, but it is time consuming.

is there any way / document /script/report or transaction code to geather this data.

We are working on SAP ECC 6.0/Solaries/Oracle Database

Waiting for your kind regards.

Thanks,

K R Singh

[former_member204746 · Accepted solution]

look for 3rd party programs. there are many solutions available on the net with this info.

[Former Member · Accepted solution]

Hello Eric,

Thanks for your response.

Is there any alternate or query to get desired result.

Thanks,

V.Singh

[former_member204746 · Accepted solution]

create an SQL trace with ST05, then, go into DB02, and check back in ST05 which table contains these entries. Ask an abapper to help you out.