Skip to Content

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

Query based on 2 date fields


I have a following report requirement.

Identify the sales figure for multiple periods (variable of type range) for those contracts validity date ending a particular date range (variable of type range). Report should show contract numbers even though there is no sales activity in the given period. Expected output is

Contract No, Item, Start dt, End dt, Material, Sales Amount

I have 2 ODS one for the contract and the other for the sales. I tried with Infoset it showing report only when sales transaction present for the contract.

how can I achieve this report?


Thanks in advance.


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