topic Re: Change Document output in Application Development and Automation Discussions

Change Document output

Former Member — Thu, 26 Nov 2009 16:41:45 GMT

Dear Experts,

Am using the Change Document FM 'CHANGEDOCUMENT_READ' to fetch the changed fields in my application.

The table is of structure CDRED and has F_OLD and F_NEW.

I have to output only fields where the new value has changed from the Old value.

Since both are of CHAR 254, for example, the amount field value is stored as 0.00 in the F_OLD and there is no value

in the F_NEW generated by the FM.

when i compare IF F_OLD ne F_NEW, still the record ouputs because F_OLD has 0.00 and F_NEW spaces.

Also this is the issue with date values.

MAJOR concern is the FM is outputting all record fields whose contents have not changed.

I request if anyone can throw some light on this.

Regards,

Sampath

Edited by: SampathKumarPilla on Nov 26, 2009 5:46 PM

Former Member — Thu, 26 Nov 2009 16:55:30 GMT

before comparing F_OLD and F_NEW, check if F_OLD is initial.

hope you understand it.

Former Member — Thu, 26 Nov 2009 17:03:28 GMT

Thanks Harsh,

The F_OLD is of CHAR 254 and has 0.00 sometimes and 0.0000 sometimes and 00/00/0000 sometimes.

So being a Character, it has filled values, even if i check as Initial, it woudnt be.

Former Member — Thu, 26 Nov 2009 17:21:55 GMT

Then check for all these possible values.

Former Member — Thu, 26 Nov 2009 21:33:40 GMT

Halo Sampath,

They why dont you check if F_NEW is initial .

This might be a problem if the user changes the value to None I suppose