Hello Community,

I hope you can help me to find the best approach of my issue. My challenge is to build a table with the complete SAP Process Flow: Order, Delivery, Shipment

For this I have created a data model with the following linked tables

VBAK (1) - (N) VBAP (1) - (N) LIPS (N) - (1) LIKP (1) - (N) VTTP (N) - (1) VTTK

When I try to add fields from all tables into one studio table I get the following error:

I have understand the problem but missing the best approach to solve it.

What do you think? Is the a studio table with different PQL formulas the solution? If yes, how can I do it?

Or is it better, when I create a table (e.g. TAB_PROCESS_FLOW) within the transformations that includes all the key columns and connect the other tables (VTTK, VBAK...) within the data model. So the table TAB_PROCESS_FLOW is like a case/common table.

Best, Thomas