Displaying empty fields in SQVI

[Former Member]

Hello,

this my first question and I hope that this is the right place to ask it.

I am currently developing a report in SQVI and I am looking for and easy way to show the empty field. I want to see if information is missing.

Thanks in advance.

[Former Member · Accepted solution]

Hi Sven,

There is this well detailed document on how to create a view in SQVI.

It shows how to create a quickview using a layout view for the selection.

If you want to create it using the basis view, it is even easier!

I was able to test it in my system and as shown bellow, I retrieved three field from CRHD table, being the third one (Deletion Flag for Work Center) an empty field. For this I used the Basis Mode to display my selection.

After executing it, you can see that I could output the empty field seamlessly.

Hope this helps in your scenario.

Regards,

Arthur Braga

[Former Member · Accepted solution]

Hey Arthur,

thanks for your reply. I will test this solution and see if it works in situation!

Regards

Sven

[Former Member]

Hey Arthur,

thanks again for your effort, unfortunately it did not work in my case. But a new colleague pointed my in the direction of Left outer Joins:

Left Outer Join - Business Intelligence - SAP Library

This was in fact what I was looking for.

Thanks

Sven