Demantra Collection - New Series Config

Hi All

We got a requirement that we need to report the Shipped Qty by RD, Shipped Qty By Actual Ship Date in Demantra.

We need to define new series and collect the data from EBS.

Can someone please guide on this?

Which is the correct path?

Option 1 -

Define new columns in T_SRC_SALES_TMPL and SALES_DATA.

Populate the data in T_SRC_SALES_TMPL and run EP_LOAD which will populate the SALES_DATA.

Option 2 -

Define new columns in SALES_DATA.

Create custom program to populate these new columns.

Ideally, I want to go with Option 1 since standard EP_LOAD will take care.