Skip to main content
Question

View Table: Display Datasets with no following Datasets (Join)

  • November 17, 2025
  • 3 replies
  • 13 views

thomas.keim
Level 10
Forum|alt.badge.img+3

Hello Celonis Team

I have a stupid question but I don’t find a solution yet.

The following SAP tables are connected

VBAK 1:N VBAP 1:N LIPS N:1 LIKP

My challenge is to display a document flow within a table. This works - but only for VBAK/VBAP dataset which have an following LIPS/LIKP dataset.

 

I expect to see the following:

 

But as result I only get 

 

My question: How to I configure the table that I also see VBAK/VBAP columns with no following LIPS/LIPS datasets?

 

Best, Thomas

3 replies

julia.bauer
Level 9
Forum|alt.badge.img+6
  • Level 9
  • 59 replies
  • November 17, 2025

@thomas.keim

Hello Thomas, are those tables connected in the backend or “only” in the datamodel?

Could it be that there’s an inner join used here that causes this?

 

BR

Julia Bauer


thomas.keim
Level 10
Forum|alt.badge.img+3
  • Author
  • Level 10
  • 11 replies
  • November 17, 2025

@julia.bauer 

The tables are connected “only” in the data model.

The curious thing is: When I add only the VBAK/VBAP columns to the table or have the LIPS/LIKP colums hided, all VBAK/VBAP data are shown. 


thomas.keim
Level 10
Forum|alt.badge.img+3
  • Author
  • Level 10
  • 11 replies
  • November 17, 2025

Here a good example:

As soon as I hide the “Delivery Item LIPS.POSNR” field, I see the VBAP/VBAK fields where there is no value for LIPS.POSNR.
However, I would also like to see VBAP/VBAK fields where there is no LIPS data record.