cancel
Showing results for 
Search instead for 
Did you mean: 

Data Missing if cell is blank

Former Member
0 Kudos

I am trying to build a SQVI based on the VBAP table linking a custom table. Querying by Sales Order, but if one of the cells on the custom table is empty, the lines from the sales order do not appear on the report. I need them to appear because if the data is missing, need to be able to identify them.  Any suggestions?  Thanks,

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member218251
Active Participant
0 Kudos

Try a left outer join.

With a left outer join, all records of your base table are shown and only those of the other table where the record is an exact match.

You can set the left outer join in the join view > Right click on the connecting arrow.

Remember 1: SQVI is a database. In a database query there is no such thing as a fuzzy search. It is a match or it is not a match.

Remember 2: All joins between 2 tables must be equal, so when there are more relations, then all heft to become left outer joins.

Former Member
0 Kudos

Hi Dana,

read this Important Tools and Techniques - Advanced Techniques | SAP-SD

you may find some valuable information regarding quick viever.

You problem is typical, viewer joins two table based on you field. Equal lines are listed. try to find another field to join. However it may not possible in your case.

Cheers,

Sarhan.

Former Member
0 Kudos

Thanks, I will take a look.