ZTABLE ISSUE

[former_member410927]

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

[Former Member]

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

Category

I could now have MANY, MANY entries for the same DOCUMENT value....If I remove ITEM, LINE, CATEGORY, I can no longer have a table with a unique key DOCUMENT, since a unique key DOCUMENT means I could have document 1 stored only one time in the table.

yes, you can download ZTABLES....Display in SE11, for instance, removing the limit on number of entries to display. When displayed, choose SYSTEM>LIST>SAVE>LocalFile, etc.

[Former Member]

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

[Former Member]

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.

[Former Member]

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.