Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ZTABLE ISSUE

0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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.

4 REPLIES 4

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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.