Skip to Content

TABLE FOR SHOW DIFFERENCE WINDOW

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 12 at 02:40 PM

    Hi,

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

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12 at 08:12 AM

    Dear Corina,

    It is ADOC

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 13 at 03:17 AM

    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 mll md ADOC is use for transaction table I think.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded