cancel
Showing results for 
Search instead for 
Did you mean: 

Query based report to pick up the value from differences table

Former Member
0 Kudos

Hi,

I am trying to pick up the value from change log differences feild but since it is system variable i am unable to pick it.which table i should pick up to get that .

Regards-

Monica.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

ISSUE SOLVED

Former Member
0 Kudos

Hi Monica,

This would be a tough job if you know the structure of the historical record tables. You need to familiar with all those A tables first. Any changes to one of the record would create a instance of the record before change. AITM is for OITM, AIT1 is for ITM1 etc. Which tables are you looking for?

Thanks,

Gordon

Former Member
0 Kudos

Hi, the history of which object are you looking for? These tables are usually the same as the original but starting with A. For instance the BP history is ACRD instead of OCRD, th journal history is AJDT instead of OJDT and so on.