Fixing Bad Data In New Data Table(ODS)

[Former Member]

Hi Roberto,

Here is an quick and high priority question, Can we change data(Fixing Bad Data) in ODS New Data Table, If so please let me know how.

Thnaks in Advance.

Regards

Reddy

[Former Member · Accepted solution]

Hi Reddy,

you can easily correct your data in the New Data Table because without the activation process, no changes are still performed in your active table, but above all, on your change log table (cause in this situation it's a bit more difficult..).

So, if wrong records are not so much, you can directly change them in SE16;

or you can do it by a little ABAP program;

or by a little file to load (but in this case you have to build an ad-hoc infosource)...

Let me know if you need more help...

however, it's important that you don't activate your records until you are sure of their validity !

Bye (and please don't forget to assign some points by clickin'on the yellow star to the contributors that help you!),

Roberto

[Former Member · Accepted solution]

Hi Roberto,

Thanks a lot for your early reply, There is a huge data(200 data packets) in New Data Table(ODS),Activation failed due to bad characters, Now i can fix bad data in PSA but it is taking too much time to reconstruct the ODS, So i want to fix the bad data in New Data Table itself and then activate but New data table can be open in Display mode only(even in SE16) where we cannot change the data.

Please give me more details how to change the data in New Data table.

One more thing i am working on production server.

If you have any questions or comments, please don't hesitate to ask me.

Once again Thanks in Advance.

Regards

Reddy

[Former Member · Accepted solution]

Hi Reddy,

in SE16 you have to debug every record in order to change the code from SHOW to EDIT....but, if you are not inured to do this operation, I suggest you (besides the file solution, that is the safer one) to write in development system a few rows of ABAP in SE38 and then to update the desired records.

Something like this:

SELECT SINGLE * FROM /BIC/Ayourods40

WHERE REQUEST = *** AND

DATAPAKID = *** AND

RECORD = ***.

IF SY-SUBRC = 0.

/BIC/Ayourods40-yourfield = ***.

MODIFY /BIC/Ayourods40.

ENDIF.

Let me know...

Bye,

Roberto

[Former Member · Accepted solution]

Thanks a lot Roberto, I will try this and let u know details.

Cheers

Reddy