I have a problem with shipment cost. A shipment cost is assigned to a transport.
Datas are updated to BI system. When I delete a shipment cost in order to create an other one and assign it to the same transport, BI system detects changes, but it create 2 register with the same transport number but different shipment cost. I need a DSO to store data, but the KEY FIELD must be transport numer, shipment cost and shipment cost item. Then tha data are update into a cube.
Is there into SAP R/3 a field when I can store deleted shipment costs? The used table is VFKP, but there is no place where I can store deleted shipment cost. Do you know how I can solve this problem?
Thank you very much