Transaction ME2N using multiple selection parameters

[former_member770176]

Hi all,

I have used ME2N in SAP ECC for a while now and run into an issue. Hope you can help me.

When I use the selection parameters it works fine when I use a single parameters (e.g. WE102 and RECHNUNG). However, when I use a combination in the selection parameters, none of them are applied anymore.

Using my own examples, if I use WE102, I get a list of orders where the goods have been delivered. If I use the parameter RECHNUNG, I get a list of orders where the invoice is not yet received.
When I use this combination I would expect te get a list of purchase orders where:
1. the goods have been delivered
2. there is no invoice posting.

However, when I use the combination, it gives me everything, no filter applied at all.
For me it's the first time using a combination (I tried a few other combinations and each time same, filters not applied).

Is there something I missed for this kind of combination to work? Hope someone can help me with this.

Thanks.

[DominikTylczyn]

Hello danny12345

If you are not happy with the OR logic here, you can customize your own selection criteria in SPRO: Materials Management -> Purchasing -> Reporting -> Maintain Purchasing Lists -> Selection Parameters -> Define Selection Parameters.

I'd recommend to use only one selection criterion, so not to get confused by the OR logic.

Best regards

Dominik Tylczynski

[former_member770176]

Hi Bijay,

This transaction seems to give what I am looking for (could be different if we also allow invoice receipt before GR).

Thanks for your help.

[BijayKumarBarik]

ME2N report have multiple options for business ...

But for your case GR done but invoice pending---> check report should helpful with transaction code MB5S

[former_member770176]

Hi Dominik,

I am still fresh in this customization and first would like to know if any existing transactions/tables/reports can give me the output I want.

SAP huge and pretty sure I don't know all the possibilities, that's why I wanted to ask here if any one is aware of such possibility.

If there isn't then I need to look into customizing or using BI reports.

Thanks,

Danny

[TammyPowlas]

Hi Danny - it sounds like, reading the help on the selection field, it is doing what it says:

"

Selection parameter for purchasing lists

Determines which information is to be included in the list display.

Use

The selection parameter allows you to list only those purchase order items with open invoices for instance.

Note
If you have used multiple selection to select more than one selection parameter, then the system lists all purchasing documents that correspond with at least one criteria." source: SAP

"Then the system lists all purchasing documents that correspond with at least one criteria." is what is key. So it sounds like you are expecting an "AND" situation when it's really an "OR" situation. This is tough to explain...so I hope reading the help "helps".

[former_member770176]

Hi Tammy,

thanks for the explanation.
To me it means that the selection parameter is actually not very useful when you try to use more than 1 selection.

My next question then is:
Is there a way to obtain a list of purchase orders where the goods are delivered and the invoice is not posted? If not ME2N, any other transaction/table that can deliver this?
We have huge numbers of orders, so if we can prevent extraction (which SAP also doesn't handle well for large numbers) and vlookup in eexcel it would be grade.
Tables like Ekbe also don't help me as each type of posting is a separate line/row in the order).