Skip to Content
0
Former Member
Apr 21, 2006 at 04:21 AM

Purchase Order to Confirmation Link in ODS 0BBP_CON

13 Views

Hi,

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.

(Conf No) -(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,

Pavan