Hello,
I want to do a TO BE / AS IS comparison of production orders on operation level on Duration per Piece.
I already get successfully my as is times over summed up confirmations of the AFRU table.
Currently I am not able to extract the TO BE values (like you see them in an order using transaction CO02/03 and going on operation level). This duration comes as far as I know from the Routing (CA03) which contains the Default Duration per Piece.
My first idea was to get those values out of the Routing Table (can you name them to me?). But then I realized that after the order is created the planner could change the values.
So my question is: On which tables do I have to make a SELECT/JOIN to find my finalized Duration per Piece values and which fields do I have to join on? I have the order number, operation number, confirmation number. Those orders have to be stored somehwere after values and times have been finalized, I just don't get it where...
I attach an example picture of an order to clarify of which field (VGWRT) i am talking of.
Thanks!
Dominik