topic Re: ZTABLE ISSUE in Application Development and Automation Discussions

ZTABLE ISSUE

former_member410927 — Wed, 01 Dec 2010 12:30:09 GMT

Hi experts , can a ztable be downloaded , if not what is the other possibility ,

and secondly if we remove 3 out of 4 key fields from the ztable

what is the consequence or impact on the data.

ztable has important data and it is live data .

Unless i am convinced i dont want to process that action .

thanks in advance.

Moderator message: please use more descriptive subject lines with more lower case letters from now on.

Edited by: Thomas Zloch on Dec 1, 2010 1:55 PM

Re: ZTABLE ISSUE

Former Member — Wed, 01 Dec 2010 12:50:24 GMT

If you have four key fields and you remove three, then your single remaining key field is not at all likely to be unique within the table, is it? Consider key structure:

Document

Item

Line

Re: ZTABLE ISSUE

Former Member — Wed, 01 Dec 2010 12:51:08 GMT

Hi,

You want download ZTABLE data.We can download ztable data.

STEP1:GotoSE11~~>ZTABLENAME~~->DISPLAY~~->SELECTCONTENTS~~->EXCUTE THE TABLE DATA-->if that data display ALV format THEN select SELECT ALL BUTTON AND RIGHT CLICK ON THAT BUTTON IN THAT ONE OFTHE BUTTON IS THE 'SPREADSHEET' THE U CAN PRESS THE ENTER THEN ALL THE DATA DOWNLOADED INTO EXCEL.

regards,

MURALII

Moderator message: please do not use all upper case when posting.

Edited by: Thomas Zloch on Dec 1, 2010 1:56 PM

Re: ZTABLE ISSUE

Former Member — Wed, 01 Dec 2010 13:37:27 GMT

You can download the ztable data using System->List->save option.

But before removing these primary fields please check tht wether single primary key can handle the uniqueness for your table data.

Even changing key fields may results into loss of data.

Re: ZTABLE ISSUE

Former Member — Wed, 01 Dec 2010 17:24:00 GMT

Key field combination should uniquely identify each of the table records.

So if we remove one of the key field of table, the above property may be violated.

This might result in loss of data.

Also when we modify table structure we need to adjust database in SE14. During database adjustment we have option of adjust database saving the existing data.