Is there a way to determine which pristine objects have been modified

[BOster]

We have tried to document as much as possible any time we make modifications to a shipped JDE object (such as the P4210). But, I would like to write a report that looks at all the pristine JDE objects and determines if we have made any modifications to the object.

Would I use the logging tables for this? Is there some other type of flag that gets set when I check out an object (say the P4210), make changes, check it in, etc?

Any ideas would be helpful on how to do this would be very helpful.

 

[Sebastian Sajaroff]

Try the following

SELECT SIPATHCD, SIOBNM FROM F9861 WHERE SIMRGMOD='C'
ORDER BY SIPATHCD, SIOBNM

 

[BOster]

That definetly gets me a whole lot closer. However, there are quite a few objects showing up that I know we didn't make any modifications to. Any other flags that might further indicate modification?

 

[Sebastian Sajaroff]

Hi,

The flag sets to 'C' even if you checkout/checkin an
object without modifying it.
That's probably causing the extra entries you get.

 

[BOster]

Ya, thats gotta be it. I guess I can use that flag in conjunction with the logging to further narrow down the report. Still gets me a lot closer... instead of a list of 40K objects may just be several hundred. Thanks for your help.

 

[Owen Pay]

Have a look at the R9840D. You can choose the Path Code in the Data Selection. There may be TOO much detail, but it is a useful report.