How to merge multiple tables without any common fields in SAP ABAP

[former_member554493]

I have a table name AUFK, JEST, TJ02T, and COEP. AUFK, JEST, and COEP have a common field but TJ02T and JEST only have common to each other. Now all i want to do is to merge all the specified table and how can i do that? Hoping that you can help me guys.

[matt]

You really need to give some context of the business requirement. What are you trying to get out the end?

[Siarljp]

This does not sound like an ABAP problem, more a data design issue, a common field means there is a relationship between one table and the other, if there are no common fields, then either there is a missing linking table(s), or you have no relationships between your data, and then really you need to think about what the relationships should be.

[SimoneMilesi]

Do you know how to link tables via join?
It's not madatory all the tables have the same common field: it's more like a chain.

AUFK -> COEP via OBJNR, COEP -> JEST via OBJNR -> JEST -> TJ02T via ISTAT.

And you got your chain.

Which is the problem?

[former_member554493]

Yes i know how to link it using join, your right i can use chain system. thanks i will try it. 🙂