Filtering by

[bartlomiejolszewski]

Hi there!

I kindly ask you for help.

In SAP 4HANA, in transaction FBL1N (Vendor Line Items), in column Reference, I need to find invoice by number and blank.

I'm setting filter by invoice no. e.g. 123456CR, 123456DN, so I put 123456* and at this same time I need blanks. I tried with # but does not work.

Is it possible?

Thanks in advance!

Bartek

[former_member751964]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A, as the overview provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a Picture to your profile you encourage readers to respond.

[TammyPowlas · Accepted solution]

Hello - please go to FBL1N, select dynamic selections, select reference field, then select = blank

See screen shot below: