Change History Report

[Former Member]

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.

[bharath_k6 · Accepted solution]

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

[Former Member]

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