topic Re: Join MARA with TKKH in Application Development and Automation Discussions

Join MARA with TKKH

Former Member — Tue, 02 Dec 2008 11:59:39 GMT

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

Re: Join MARA with TKKH

RaymondGiuseppi — Tue, 02 Dec 2008 12:09:03 GMT

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

Re: Join MARA with TKKH

Former Member — Tue, 02 Dec 2008 12:10:22 GMT

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

Re: Join MARA with TKKH

Former Member — Tue, 02 Dec 2008 12:51:24 GMT

A combination of both comments proved to be just right.

Thanks guys,

Simon