SQVI duplication of records

[Former Member]

I ran a simple SQVI with MARA & MARC with selection field PLANT and listfields MATERIAL,REMAINING SHELF LIFE, SHELFLIFE,PERIOD INDICATOR, PLANT.

In the result, I find duplicate records. what could be the reason?

Thanks in advance.

PMR

[Former Member · Accepted solution]

Hi

Duplication of records takes place due to Language, Plants, Storage locations. so you need to ensure that by using more number of selection parameters or else you can remove the duplicates after export if you cannot fix the selction parameters

Thanks & Regards

Kishore

[csaba_szommer]

Hi Mano,

Please check how many records you have for your material in table MARC. If your material is extended e.g. to two plants please understand that in this case your query will result in two records.

You have only one record for one material in table MARA because it stores information at client level but MARC stores plant specific information and you may have several records in it for one material.

When you connect the two tables in SQVI the query will list all the existing records. If your query displays field from table MARA you will see the same value in each line but there must be some difference between fields from MARC (e.g. plant).

BR

Csaba

[Former Member]

Instead of inner join for the table make it uter join then you will not find duplicate or first assign MARC table and then MARA