Skip to Content
-3

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 15 at 09: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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 15 at 02: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?

    Add comment
    10|10000 characters needed characters exceeded