Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Data Loss / Data Inconsistencies

Former Member

‎2006 Dec 01 7:57 AM

0 Likes
420

Hi All,

First of all let share my experience with u all , one of my colleague has changed the existing data element ( Z-Data element ) which is used in lot of tables , he has changed the length of the field without knowing the affect which is going to be there on the DB level ...and bcoz of this change we have lost lot of data .

Can any one share some precautions/ur experience/tips where we can find this kind of situations , so that it will be a check list for all new ABAPers

1 . In what conditions data loss will occur

2. In what conditions data Inconsistencies will occurs .

Thanks in advance for ur great help.

Hi All,

First of all let share my experience with u all , one of my colleague has changed the existing data element ( Z-Data element ) which is used in lot of tables , he has changed the length of the field without knowing the affect which is going to be there on the DB level ...and bcoz of this change we have lost lot of data .

Can any one share some precautions/ur experience/tips where we can find this kind of situations , so that it will be a check list for all new ABAPers

1 . In what conditions data loss will occur

2. In what conditions data Inconsistencies will occurs .

Thanks in advance for ur great help.

Reply
2 REPLIES 2
Read only

Former Member

‎2006 Dec 01 8:20 AM

0 Likes
343

Hi Ramana

Kindly close this duplicate thread. Request you to avoid opening duplicate threads.

Kind Regards

Eswar

Read only

Former Member

‎2006 Dec 01 5:48 PM

0 Likes
343

Dear Ramana,

1. After changing the Z data element, if the changed length of data element is less than what it originally had (e.g. changed from CHAR 10 to CHAR 8), data loss will occur in all tables where this data element is used; i.e. last 2 characters from the associated fields will be dropped.

2. Regarding data inconsistency, if the new length is less than the old one, it is obvious that it would impact existing data (as explained above) and hence will become inconsistent. But if the new field length is more than the old one, it can create issues in the programs where this field is passed as parameter. If reference variables are not defined using LIKE but are declared explicitly (like CHAR 10 ), then it can have impact on SQL operations that rely on the source field to be of same type, length, format as the table field.

Regards,

Chetan