on 10-29-2012 11:34 AM
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
Hi
In your infoset the relations (cardinality) between tables is wrong. Check it again.
Regards
Eduardo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.