Integration of CargoWise with SAP for Cost & Revenue recognition in SAP system by pulling out cost & revenue data from CargoWise using CargoWise API – eAdaptor using Restful APIs in a middleware.

Our client Momentum Logistics – UAE  required functionality in middleware to:

  1. Map CargoWise – revenue A/C codes to the corresponding work-in-progress A/C codes and actual cost & revenue a/c codes in the SAP system.
  2. Take daily cost & revenue XML from CARGOWISE and post them to respective SAP system work-in-progress a/c codes.
  3. Create another XML for this cost & revenue in the format acceptable to the SAP system.
  4. Once a job is closed in CARGOWISE.
    (a) In middleware reverse the figures in the above work-in-progress a/c pertaining to that job and
     (b) Post the same to actual cost & revenue a/c codes in the SAP system.
    (c) Create an XML with data from above (a) & (b) in the format acceptable to SAP system.
  5. Ensure Data integrity in SAP and CargoWise.
  6. Ensure Accounting Data is in Sync with SAP and CargoWise.

Project Outcomes

Cost & Revenue recognition in SAP system is being done successfully  by taking cost & revenue data from CARGOWISE  Production environment and posting it in SAP Production System – through scheduled jobs using eAdaptor

ETL layer using CW1 eAdapter : Architecture Diagram

Solution Development: Integration Hansa Orga System & CW1