01-15-2018 6:45 AM
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.
01-15-2018 7:15 AM
You really need to give some context of the business requirement. What are you trying to get out the end?
01-15-2018 9:06 AM
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.
01-15-2018 2:02 PM
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?
01-17-2018 12:27 AM
Yes i know how to link it using join, your right i can use chain system. thanks i will try it. 🙂