cancel
Showing results for 
Search instead for 
Did you mean: 

TABLE FOR SHOW DIFFERENCE WINDOW

former_member556845
Discoverer
0 Kudos

Hi,

I would like to know which table located is the show difference window (CHANGE LOG> DIFFERENCE)? I am doing a Posting Period change log report and the requirement is to give the field value of Updater, Date Updated, Changed Field, Previous Value and New Value.It would really be helpful if you can give me the query for it.

Thanks!

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member556845
Discoverer
0 Kudos

Hi Nagarajan,

I tried the AFPR and OFPR table but this not gives correct outcome.

Select *

FROM AFPR T0 left join OFPR T1 on T0.[AbsEntry] = T1.[AbsEntry]
and t0.loginstanc = t1.loginstanc-1
left join OUSR T2 on t2.userid = t0.usersign2
left JOIN OUSR T3 ON T3.USERID = T0.usersign2 ORDER BY T0.[AbsEntry]

To camall ADOC is use for transaction table I think.

Thanks.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Use table OFPR and AFPR to get change log for posting period.

Regards,

Nagarajan

former_member419030
Active Participant
0 Kudos

Dear Corina,

It is ADOC