Join MARA with TKKH

[Former Member]

Hi,

I need to make a join between the tables MARA & TKKH2.

The fields I need to retrieve are MARA-MTART, TKKH2-HRKFT and TKKH2-HRKTX

where MTART in ('ZENV', 'ZEMB', 'ZMAT')

I know there is no direct reference between the two but if anyone has any ideas about it let me know.

Regards,

Simon

[RaymondGiuseppi]

there is no direct link between MARA and TKKH, so no answer to your request,; more exactly there may be multiple values for one material number.

You need to start from MBEW, which has a HRKFT field related to TKKH1 table. Look at foreign key on table MBEW field HRKFT. (or build KOKRS from MBEW-BWKEY -(T001K)-> BUKRS -(TKA02)-> KOKRS.)

I almost forgot to mention that TKKH2 is TKKH1 text table.

Regards

[Former Member]

Hi,

Try this way.

1. Use SQVI transaction,

2. Create a View

3. Enter title,

4. Choose the Data source as Table Join

5. Now use Insert table option.

6. And insert the tables which you want. It will propose the relation between them.

Thanks

Nitesh

[Former Member]

A combination of both comments proved to be just right.

Thanks guys,

Simon