Skip to Content
avatar image
Former Member

Displaying empty fields in SQVI

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    May 28, 2015 at 02:46 PM

    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.

    How to create Report by using SQVI


    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


    fieldselection.PNG (56.6 kB)
    fieldoutup.PNG (17.7 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hey Arthur,

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

      Regards

      Sven

  • avatar image
    Former Member
    May 29, 2015 at 07:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded