Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Union with Nulls

Hi Gurus

I have done union on AUFK and RESB

Variable Selections on BUKRS from AUFK table.

When I am selecting the variable value I am getting single record instead of 2 records due to null values(?)

I want the below desired data.

Capture.PNG (11308 B)
Former Member

Here's one possible solution:

Create a view (call it V1) that joins AFKO and RESB, using the RSNUM field. In this view pull all RESB fields and the AFKO-BUKRSĀ  field. Do not pull any other fields from AFKO.

Then in another view (say V2), do a union between V1 and AFKO. That will meet the requirement.

If you are doing all this in a calc view, then V1 would be a join node in the calc view, and V2 would be a union node taking V1 and AFKO as inputs.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question