I need to Find all entries in AFVC that have changed between 2 given dates. The change dates for orders are in AUFK (AUFK.ERDAT and AUFK.AEDAT).
I can link from AFVC to AUFK via table AFKO. The "where clause" looks like this:
AFVC.AUFPL = AFKO.AUFPL and
AFKO.AUFNR = AUFK.AUFNR
The problem is that AFVC is Order Operations for all types of Orders (production planning, maintenance, service, etc.)
But the intermediate table AFKO is Production Planning Only. So when I make this join I can only get to the AUFK records for the Production orders. The AFVC records for Maintenance orders, etc. are lost.
Is there another way to find out which AFVC records have changed between two dates?
Another possibility would be to check table CDHDR for changes with OBJECTCLAS = "ORDER". But that will only work if a change to the AFVC record triggers a change to CDHDR. Is that a good option?
thanks in advance for all your help on this.
Edited by: Lenny Galatioto on May 22, 2010 2:55 PM