Merge two differents tables in one new structure

[Former Member]

Hello guys,

How can I merge two differents tables in one new structure (workarea) dynamically?

For example, merge MARA and MARC in a new structure that contains all fields from MARA and all fields from MARC.

In this case, it isn't necessary that identical fields be repeated (MATNR).

Can you help me?

Thanks!

Kleber

[former_member222860]

Hi,

To include similar fields from both tables, give different name, Say

DATA: matnr1 like mara-matnr,

matnr2 like marc-matnr.

Regards

Mahesh

[Former Member]

Search sdn for "Create dynammic internal table"...

[Former Member]

Hello Veeranji,

I've searched a lot, but unfortunately I haven't find anything that help me.

In fact, I need to create a dynamic structure (workarea), and don't a dynamic internal table.

Thanks for your reply!

Kleber

[marius_greeff]

Hi,

One option is to create a table view in SE11 using the two tables. I am even shore the performance will be faster than writing a join in ABAP.

Regards,

Marius

[Former Member]

Hello Marius,

MARA and MARC are only an example, because the tables are dynamic.

I can't create a structure in SE11.

Thanks!

Kleber

[venkatasriram_mygapula]

Hi,

Use include structure like:

data begin of itab occurs 0.

include structure MARA.

include structure MARC.

-

---

-

---

data end of itab.

[Former Member]

Hi,

Not at all we need to repeat the same field in the structure.

With Regards,

Sumodh.P