Skip to Content
-3

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

Jan 15 at 06:45 AM

132

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Julian Phillips Jan 15 at 09:06 AM
2

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.

Share
10 |10000 characters needed characters left characters exceeded
Simone Milesi Jan 15 at 02:02 PM
1

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?

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0