Skip to Content
avatar image
Former Member

Change History Report

Our Business team wants to track particular fields with Old and New Values for a Particular FO or FO Types. Instead of going to search a particular filed in Change documents in FO UI Tab.We tried to develop a report to achieve these Changes.

For example : On a Particular Freight Order I have changed the carrier..so in a report it should display what was the old value of a carrier and new value of a carrier which I changed recently with particular user who changed it.Like these we successfully tracked Subcontracting status, Life Cycle Status, Carrier information using the tables CDHR,CDPOS.

But our requirement is to track Invoicing status, Distance Changed, Duration Changes, Quantity Changes, First and Last activity changes. We can fetch only current values on TOR BO but not Old recent value.That's where we got stopped with the report.

Please help me if anyone has any suggestion to retrieve above fields with Old and New values.

Analysis which I Worked on these report:

1.Invoicing Status  -  BO :/SCMTMS/TOR-TRANSPORTATIONCHARGES-INVOICING  (Does not appear in CDPOS).

2.Quantity -  Can be captured in TORROT table – NET WEI VAL (Appears multiple times in CDPOS for item level and header level).

3.Distance -  If stages distance changed , total distance also changes. In CDPOS distance appears multiple times for stages as
well as total distance.

4.Duration-  If stages duration changed , total duration also changes. In CDPOS duration appears multiple times for stages as
well as total duration.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 22, 2014 at 03:15 PM

    Dear Hemanth,

    It does not appear in CDPOS because Data element /SCMTMS/INVOICING_STATUS_CODE does not have CHANGE DOCUMENT enabled.

    I have also seen there is no such field to determine invoice status in /SCMTMS/D_TRQROT  or  /SCMTMS/D_TORROT tables. But we have appended customer specific fields to update the Invoicing status. You will have to do the same if you want.

    For quantity, Distance and duration, yes they appear multiple times.

    However, the only way is to reduce the number of records is to put a filter on CDHDR-UDATE (Creation date of the change document).

    You can also add Change document number additionally to your report selection criteria to improve the result.

    Thanks,

    Bharath.K


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 23, 2014 at 08:58 AM

    Hi Hemanth,

    Please check standard report CHANGEDOCU_READ.

    This report will help you in developing Z report if required.

    Selection Parameter :

    Object Class : /SCMTMS/CD_CFIR

    Object Value : select DB_KEY guid from table  /SCMTMS/D_CF_RT for invoice number or FWSD number.

    This will give you change log of FWSD number.

    Similar way you can see the change log for FWO , FRB by selecting respective Object class like /SCMTMS/CD_TRQ, /SCMTMS/CD_TOR respectively and Object value like DB_KEY guid from table /SCMTMS/D_TRQROT , /SCMTMS/D_TORROT respectively.

    Thanks and Regards,

    Kalpesh

    Add comment
    10|10000 characters needed characters exceeded