Tracking Changes Using History Tables

In Eralis Job Costing, users cannot access the standard SAP Change Log feature directly from application screens (such as Job Line Processing or Direct Materials Entry).

However, Eralis maintains history log tables that capture all inserts and updates to key data. These tables can be queried using SQL to determine:

• Who made a change 
• What was changed 
• When the change occurred

This article provides practical examples for retrieving that information.

Key History Tables

• ENPRISE_JOBCOST_JOB_HISTORY
• ENPRISE_JOBCOST_SUBJOB_HISTORY
• ENPRISE_JOBCOST_JOBLINES_HISTORY
• ENPRISE_JOBCOST_CONTRACT_HISTORY
• ENPRISE_JOBCOST_CONTRACTLINES_HISTORY

Key Fields

• CHANGEACTION (e.g., INSERTED, UPDATED)
• CHANGEDBY (user who made the change)
• CHANGEDON (timestamp of change)
• STATUS (job line status indicator)

Use Case 1: Identify Who Added an Item to a Job and When

select subjobid, status, stockcode, description, convert(char(8),transdate,112) as 'Jobline trx date', 
          changedby, convert(char(8),changedon,112) as 'Status changed'
from ENPRISE_JOBCOST_JOBLINES_HISTORY 
where CHANGEACTION = 'INSERTED' 
and STATUS = 1 --status 1 = 'Entered' 
and STOCKCODE = 'A00003' 
and SUBJOBID = 14210001

Use Case 2: Identify Who Wrote Off Job Lines

select subjobid, status, stockcode, description, convert(char(8),transdate,112) as 'Jobline trx date', 
          changedby, convert(char(8),changedon,112) as 'Status changed' 
from ENPRISE_JOBCOST_JOBLINES_HISTORY 
where CHANGEACTION = 'UPDATED' 
and STATUS = 7 --status 7 = 'Written Off'