Consolidating PO PTP data

49 Views

Hi,

We are trying to make a consolidation design for PO ITM, SCHed_line, Conf_line data and EKBE (history data).

Any pointers on the design. (2lis_02_itm, 2lis_02_scl, 2lis_02_scn and a Zdatasource for EKBE .

1. itm-sch-conf

the consolidation ADSO1, first we load itm data, then sch data and conf data. what happens is we get itm with sch-conf fields blank. when we load sched_line data looking up itm data, conf data is blank. finally when we load scn data, itm-sch-conf data comes in all fields in a row (looking up itm and sched data for every processkey-sched-conf line item.

But this causes the ITM and schdule quantities to several times the actual value.

2. consolidation ADSO1 and EKBE data....

I request inputs on design for consolidation and sequence of loads (itm,sched,conf,history)

Regards,

Cleo