Opportunities without Products

[z6mod]

I was asked to create a report to list all Opportunities from our system without any products/line items. Unfortunately, I’m not able to because it appears that the system always adds an additional line as depicted on the below screenshot:

Data Source Name used for this report: Opportunity Header and Item

Looking at the screenshot from top to bottom, you’ll see that Opps 22 and 25 have no products assigned to them = good result.

Subsequently, the Opp 26 has the Product 10000010 or Line item 10 assigned to, but then it also has one unnecessarily added row below (marked in red).

Because of this issue I’m not able to filter out the actual Opportunities without Products.

Furthermore, I’ve tried using different Data Sources, such as:

• Opportunity Item
• Opportunity Header
• Created by me, a combined data source Opportunity Item + Opportunity Header

Unfortunately, they seem to use different field for Opportunity, because when I enter the selected Opp ID I get two different results (similarly as shown on the first screenshot):

Last but not least attempt of mine, was to use the “Master Data” switch for the Products field. It’s kind of worked, but unfortunately the system does not fetch all details:

[former_member497128 · Accepted solution]

Dear Marek,

Please note that data source "Opportunity Header and Item" is a combined data source and in such case, there may be 2 lines for the same data, where one of the lines shows the correct value and the other shows #.

The same has been explained in case document "2488796", you can access via below link:

https://apps.support.sap.com/sap/support/knowledge/public/en/2488796

Now regarding your requirement, you can either filter the data source (or report based on this data source) on field "Opportunity Item" or "Product".

Foe example, in selection, use not equal to # (as shown in attachment opp-filter.png) which will filter out all rows where Product will be not assigned.

And if this is not fulfilling your requirement, then you can also go for creation of joined (inner join preferable) data source between "Opportunity Header" and "Opportunity Item" and then you wont find multiple extra lines.

Please check further from your end and let us know in case of any further concerns.

Regards,
Saurav Kumar

[z6mod]

Hi Saurav,

I've found a way via the Key Figures 🙂

Thanks for your help and have a great day!

Best regards,
Marek

[z6mod]

Hi Saurav,

Thank you very much for your response - it's been very informative. :

However, with regards to your proposal, where Product = !(#) is exactly the opposite of what I am trying to achieve 🙂 I would like to display all Opps where Product = #, or in other words - all opportunities without products (or line items).

Furthermore, when I created my custom Data Source, it was not pulling all remaining details about the opportunity other than its ID, similarly as shown on the screenshot #4.

So, the investigation continues 🙂

Best regards,
Marek

[former_member497128]

Dear Marek,

To your concern "I would like to display all Opps where Product = #", you can use the filter as you also have mentioned "Product=#" and to your other concern "you are not getting data in custom data source", it may be the case that you are not joining both data sources in effective way. You can try to join both data source as inner join (you can use left outer as well if needed) and use one filed as joining condition (that field may be opportunity ID) and if this is not resolving your concern then please raise a incident as beyond this it wont be easy for us to debug further. We will have to login in your system and check your requirement and for this we need an incident.

Regards,

Saurav Kumar