cancel
Showing results for 
Search instead for 
Did you mean: 

SQVI duplication of records

Former Member
0 Kudos

Hi Experts,

I need your help I have linked using SQVI tables MARC,MARA,QMAT and MAKT but on the extract I get multiple duplicate records. Can anyone help with this?

Thank you.

Lethu

Accepted Solutions (1)

Accepted Solutions (1)

eduardo_hinojosa
Active Contributor
0 Kudos

Hi

In your infoset the relations (cardinality) between tables is wrong. Check it again.

Regards

Eduardo

Answers (1)

Answers (1)

JL23
Active Contributor
0 Kudos

whenever you have several records for the same material number in one of your tables then it will display a multiple of the base record, except you add a key field to your selection and restrict the selection.

Assuming you have the description maintained in english and french, then your MARA records are duplicated, hence you have to add the language to the selection to restrict the result to english only.

same will happen if your material is maintained for 2 different plants,, then you should add the plant to the selction to pull the records only for one plant.

Former Member
0 Kudos

Thank you guys I checked my tables relations and I maneged to eliminate the duplicates. Thanks.