I have a requirement to take an SAP iDoc (Shipment) information and pass it through Mercator to produce several output files in CSV format.
The iDoc is, roughly speaking, structured so:
SHIPMENT
|–Delivery
| |–Material
| |–Material
|–Delivery
| |–Material
| |–Material
What I need is a CSV file containing (at the highest level) the following repeating data:
“Shipment Number”, “Customer”, “Material”, “Qty”
What is holding us up at the moment is that the developer working on the project cannot get data from higher level segments while parsing the lower level, i.e when iterating through Delivery Materials, the Shipment Number is “unavailable.”
It has been suggested that what we need to do is create a series of maps for each segment and pass the higher level data through to the lower level (i.e pass Shipment data to Delivery, Shipment *and* Delivery data to Material). Can anyone confirm this or suggest an alternative?? Please? before I go insane 🙂
TIA.
Ben.