topic Re: Syncing 3 tables and fields in Application Development and Automation Discussions

Syncing 3 tables and fields

Former Member — Tue, 15 May 2007 19:31:51 GMT

Hi,

I have a requirement where i need to display several fields from marc.

However, the material number (MARA-MATNR) and the description (MAKT-MAKTX) also have to be shown.

How do i sync all 3 tables and populate the correct data? I know that they are all connected by MATNR.

I don't want to filter any data. All data from MARC should should show up, but with those fields filled

in as well, in reference to there specific record.

amit_khare — Tue, 15 May 2007 19:35:29 GMT

Either you can use join on the three tables.

Select all MATNR from MARA.

SELECT all MAKTX from MAKT for all entries in MARA.

SELECT fields from MARC for all entries in MARC..

Regards,

Amit

Former Member — Tue, 15 May 2007 19:56:13 GMT

you could get matnr from marc itself. if no other field is required from mara, you could acheive this using marc and maktx.

select * from marc into corresponding fields of table t_marc.

if not t_marc[] is initial.

select matnr from mara into table t_mara for all entries in t_marc where

matnr = t_marc-matnr.

select matnr maktx from makt into table t_makt for all entries in t_mara where

matnr = t_mara-matnr.

endif.

loop at t_marc.

read table t_matnr with key matnr = t_marc-matnr.

if sy-subrc = 0.

move t_mara-field to t_marc-field.

endloop.