help! Modeling of ODS object
We have a requirement to display all CRM sales contracts with their associated historical sales, even if the sales contract has no historical sales history.
We have 2 ODS objects:
0CRM_CNT2(CRM Sales Contract Master)
ZRG_O16(Sales history for sales contracts)
Each ODS has the following key characteristics that need to be in the input selection and/or in the display output of the report.
- Contract Number
- Contract Start Date
- Contract End Date
- Material Price
- Fiscal Year/Period
- Material Number
- Net Sales Value(KF)
On the input selection screen would like the ability to enter a date range for the <b>Contract End Date</b> to then select the domain of sales contracts from 0CRM_CNT2(which would then become input into ZCRG_016 for the relevant sales contract history), as well as then enter a <b>Fiscal Year/Period</b> from which to select and display sales history from ZCRG_O16.
So the report output would have the following on one row:
Contract Number, Start Date, End Date, Material, Contract Price, FYP1$, FYP2$,FYP3$,FYP4$
Need a way to combine 0CRM_CNT2 with ZCRG_O16, but using an infoset or multiprovider is only showing results for contracts that exist in ZCRG_O16(and not all contracts from 0CRM_CNT2)
Anyone experience this type of issue in the past and/or suggest how to achieve through modeling or on the front-end BEX?
Thank you in advance.