Capture last value in Transformation
I am passing data from an external system into BW DSO. I am passing Production Order, Operation, Qty into BW but we are viewing this data at the Production Order Level (not down to the Operation). The problem I am having is each Prod Order can have several Operations and the value coming in for the Quantity is the same at each Operation. I only want to capture that quantity value for the last operation.
I thought I might be able to handle this in RSD1 for the Qty InfoObject in the Aggregation tab but that doesn't work. What is the best way to select only the last operation and collect the value for Qty at that last operation? Do I need to do this in the start routine putting the results in an internal table and finding last operation? I'm not sure how to delete duplicates since only the production order is the same and the operations are different. Thanks