I want to create 2 ODS.
<u>ODS 1:</u> should contain data about customer, material, sales ord, invoiced quantity, order: net value, day, base unit, currency, conf. delivery date, confirmed qty, sales unit, open orders, document currency.
<u>ODS 2:</u> should contain data about customer, material, sales org, billing qty, net value billing document, day, base unit, currency.
I've found some 2LIS extractors with possible matching data.
But what is the best way to design my ODS: datasource, datasource enhancements, key fields for ODS...?
Thanks for your answers