2010 Jun 29 1:22 PM
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
2010 Jun 29 1:42 PM
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
2010 Jun 29 1:28 PM
Hi,
To include similar fields from both tables, give different name, Say
DATA: matnr1 like mara-matnr,
matnr2 like marc-matnr.
Regards
Mahesh
2010 Jun 29 1:37 PM
2010 Jun 29 1:43 PM
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
2010 Jun 29 1:42 PM
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
2010 Jun 29 1:49 PM
Hello Marius,
MARA and MARC are only an example, because the tables are dynamic.
I can't create a structure in SE11.
Thanks!
Kleber
2010 Jun 29 2:40 PM
Hi,
Use include structure like:
data begin of itab occurs 0.
include structure MARA.
include structure MARC.
-
-
data end of itab.
2010 Jun 29 2:58 PM
Hi,
Not at all we need to repeat the same field in the structure.
With Regards,
Sumodh.P