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