ARCHIVING ZTABLE

[Former Member]

HI,

CAN ANYONE TELL ME HOW TO ARCHIVE CUSTOM TABLE ( ZTABLE)

THKS,

VN

[Former Member]

Hi Vijay,

while creation of table in table properties there are options for Archiving.

1) partially archieve

2) fully archieve

This should be checked based on the use of table. If table has fixed lines and will require frequently than you can fully archieve so whenever you write Select on this table it will fetch all the data from Application server so Database wont get called at DB level so it will improve the performance of the program.

Similarly if it is rarely updated or some other scenarios there are different options.

Reward if it helps

[Former Member]

Hi,

Some additional information would be to use archive object EXAMPLE to help guide you in creating a Z custom archive object. As for LIKP, this table is archived with archive object RV_LIKP.

To find out which archive object archives data for a particular table, you can use transaction DB15.

Check this link

/people/santosh.v/blog/2007/03/20/cdb-data-archiving--part-2

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a111ae90-0201-0010-4bbe-809ec562...

PDF doc ...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a111ae90-0201-0010-4bbe-809ec562...

Archiving custom table requires to build customized archiving object. So creating customized archiving object please refer to help.sap.com

Once you develop the customized archiving object then do

1. Technical settings for Archiving object specific customizing.

Logical file name, deletion program setting, content repository, store job settings.

2. Create variant and schedule the job

Regards,

Kumar(Reward if helpful).

Edited by: shiva kumar on Apr 15, 2008 2:32 PM