Purchase Order to Confirmation Link in ODS 0BBP_CON
I am trying to get a link between confirmation and PO in ODS 0BBP_CON. I am extracting Confirmation data from EBP (Extended Classic) and corresponding data for PO from R3 through 2LIS_02_HDR, 2LIS_02_ITM, 2LIS_02_SCL. After loading data into 0BBP_CON ODS I noticed that Confirmation Number and PO number appear in seperate rows instead of one. The KF's match but Confirmation Number and PO number are not appearing in a single row which is leading to report inconsistencies.
Example of data records in ODS.
-(PO No)-(COnf Qnty)---(Conf Val)
4000123--- - --- 2 --- 100
-3500123- 2 --- 100
Did anyone face the same issue before? or is it just the way the extractor behaves. Any input is highly appreciated.
Thanks in advance,