Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.



Not what you were looking for? View more on this topic or Ask a question