Monday, October 12, 2015

Quicker Way to Refresh Cross Reference

Normally the cross reference facility takes quite a long time to populate the tables when running the R980011.


The steps mentioned below will drastically shorten the runtime of the R980011:-
  1. Copy the �All Objects� version of R980011 to create a new version.
  2. In data selection add a condition for BC Date � Update (F9861) (UPMJ) is greater than the date you last ran the rebuild.


This will cause the R980011 to check the Last Updated Date (UPMJ) field in Object Librarian and only process those records with a date more recent than the date specified. 

No comments:

Post a Comment

Featured Post

Generate single index on table 

Transaction tables such as F0911, F4111 etc hold a huge amount of data probably a third of petabyte. Generating indexes on such tables (th...

Popular Posts