Skip to Content
0
Former Member
Jun 09, 2009 at 09:51 AM

Key Fields in the Consolidation ODS

30 Views

Hi All,

We need a consolidation ODS which has to get data from four of the underlying ODSs'.The key fields in first ODS are Document Number,Date and Material.

The key fields in second ODS are Material,Component,Date and Order Number.The Key fields in third ODS are Material and Order Number.

The Key Fields in fourth ODS is Material.

So Now the confusion is regarding the Key Fields in the consolidation ODS.

The data in the consolidation ODS has to look like

Doc Num Date Material Component OrderNum Workcenter

56776767 09.06.2009 MCJ564 MCH123 4567878787 XC7875555

The above data comes from four diff ODSs.

I tried including DocNum Date Material Component OrderNum as key fields for consolidation ODS.But I am getting two records for the same values.I need to get this as a single record.

Could someone help me with this?

Regards,

Shravani