topic Re: View in Application Development and Automation Discussions

View

Former Member — Tue, 29 Jul 2008 11:26:51 GMT

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 — Tue, 29 Jul 2008 11:28:33 GMT

Hi,

after selecting data u can write delete adjacent duplicates.

Former Member — Tue, 29 Jul 2008 11:29:16 GMT

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

Former Member — Tue, 29 Jul 2008 11:29:27 GMT

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 — Tue, 29 Jul 2008 11:39:04 GMT

hi shiva

i hav written the join condition already.

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

Former Member — Tue, 29 Jul 2008 11:45:08 GMT

use these conditions

mara-matnr = marc-mtart and

mara-matnr = mard-matnr and

mara-matnr = makt-matnr and

mara-werks = mard-werks.