View

[Former Member]

hi folks

i hav created a view. it joins 4 tables and i want to display 5 fields.

they are:

mara-matnr

mara-mtart

marc-werks

mard-lgort

makt-maktx.

the prblem is each line item is duplicating in the output.

how i can avoid this?

[Former Member]

Hi,

after selecting data u can write delete adjacent duplicates.

[Former Member]

Hi

Have you given the valid Join condition with MATNR in all the tables

[Former Member]

Hi,

Inorder to get only unique records,

Do a join condition on all the tables..

For eg: MARA-MATNR = MARC-MATNR

MARA-WERKS = MARC-WERKS

This will get all the uniqure records from MARC..

Hence do the same join conditon on all the key fields in the restof the table MARD and MAKTX

Reward if useful

Regards

Shiva

[Former Member]

hi shiva

i hav written the join condition already.

still the same error...........

[Former Member]

use these conditions

mara-matnr = marc-mtart and

mara-matnr = mard-matnr and

mara-matnr = makt-matnr and

mara-werks = mard-werks.