Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.