topic Re: ARCHIVING ZTABLE in Application Development and Automation Discussions

ARCHIVING ZTABLE

Former Member — Tue, 19 Feb 2008 02:40:58 GMT

HI,

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

THKS,

Re: ARCHIVING ZTABLE

Former Member — Tue, 15 Apr 2008 08:47:35 GMT

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

Re: ARCHIVING ZTABLE

Former Member — Tue, 15 Apr 2008 12:29:51 GMT

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-809ec5627433

PDF doc ...

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

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