Internal Table

Hi All

I would like to create an internal table with a few fields. Can someone let me know how i should declare the DATA & write the steps for the below req.

The first few fields in the internal table i want to fill with values from another internal table which is filled with values from a function module output & for each value (i.e. for IT_FUNcMod-Fld1) i want to read a few fields from MARC & DRAD tables.

Eg:

Internal table - Function Module (Table name: IT_FUNcMod)

Fld1 Fld2 Fld3...

M1 89 37

M2 33 45

& so on

MARC Table

Fld1 Fld2 Fld3...

M1 B AB

M2 H UY

& so on

DRAD Table

Fld1 Fld2 Fld3...

xM1 1234 RT78

xM2 2354 TY89

& so on

Link between IT_FUNcMod & MARC => IT_FUNcMod-Fld1 EQ MARC-Fld1

Link between MARC & DRAD => MARC-matnr Like DRAD-Objky

Output:

(Fld1 & Fld2 from IT_FUNcMod, Fld3 & Fld4 from MARC table, Fld5 & Fld6 from DRAD)

New Internal Table (Table name: IT_NEW)

Fld1 Fld2 Fld3 Fld4 Fld5 Fld6

M1 89 B AB 1234 RT78

M2 33 H UY 2354 TY89

& so on

Vivek