on 10-10-2013 1:56 PM
Hi,
i have problem in the SQVI- Quick Viewer kindly suggest the Best solution
i have used the Table join with KNA1,KNVP,PA0001
i have selcted the following options both for selection and Display
customer,sales org,distri channel,division,partner function and sales employee name
But in the Output iam able to see Duplicate records repeating three times for the same sales area
Plz help me to resolve the Duplicates.
Thanking you
Siva Prasad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
duplicates will always show if you do not restrict it by selection criteria.
But you have not shown yet from where the duplicates are coming.
you have always said you've got just one record in the table with SE16, I actually do not believe this, Thats why I asked you to make screen shots of SE16 selection and screen shots from the result.
we go round in circles.
I trust the SAP join, I am certain SAP is not wrong, your selection criteria are just to few to to find a unique record.
To know which selection to add we need to know which records you find in each table based on the given selection.
Hence you should post your selection used in SQVI
and from SE16
How can you expect to get help in a technical detail if you do not share the important information?
Hi all ,
It is normal result , you created customers in all sd areas, you will get duplication records , i quess.
Can you check this document about duplication problem solution in sd ?
http://scn.sap.com/docs/DOC-45884
Regards.
M.Ozgur Unal
Siva,
Well, if the data relationships in the tables are 'one-to-many', 'many-to-one' or 'many-to-many', then the data displayed in the join will be multiple records, each of which has some bits of data that are common to the two tables. This is 'Standard' in any relational database.
PA0001 has a 'special' key, I will assume that in YOUR system, there is only one record for each Personnel Number, as you have said.
KNVP, however, has been structured by SAP with the keys of MANDT, KUNNR, VKORG, VTWEG, SPART, PARVW, and PARZA. Inherent in this structure is that every individual combination of, say, KUNNR+ VTWEG + SPART + PARVW (the fields displayed in your report) may appear multiple times in KNVP. In General, MANDT is irrelevant in most SQVI reports, so you should, as a test, display ALL of these key fields in your report. This will tell you why you are getting duplicates.
Best Regards,
DB49
M,
I think Mr Siva should perform the test that I recommended, and find out for himself, and then publish his findings. The ultimate learning experience is discovering through logic how to get the answers. Having someone just tell you a few facts is, in my opinion, a poor substitute.
Best Regards,
DB49
Siva,
MANDT (Client number), as I stated before, is irrelevant in most queries. Although it is a key in table KNVP, for your query, there should not be more than one entry under MANDT. You should be able to ignore it for now.
I will assume you are
1. still joining KNA1 to KNVP on KUNNR; and you are
2. still joining PA0001 to KNVP on PERNR. I will further assume that
3. you have examined PA0001 table in detail, and you have verified that for every PERNR, there is one and only one entry. Please confirm these three facts.
Now that you have displayed KUNNR, VKORG, VTWEG, SPART, PARVW, and PARZA in the output of your query, execute the query and examine the output for duplicated entries. What do you find? Do you still find display rows where EVERY field in the output is duplicated?
Best Regards,
DB49
Siva,
Puzzling.
Please confirm that there are no other tables used in the SQVI.
Please select one KUNNR that you know is duplicated and execute the query against that KUNNR only. Please provide screenshot of the output, displaying KUNNR, VKORG, VTWEG, SPART, PARVW, PARZA, and PERNR.
Then, take the PERNR found in that display, and enter it into SE16 for PA0001. Provide a screenshot of the output.
Best Regards,
DB49
Hi
Please check once again. Check each field carefully because there must be some difference in any field which is causing duplication. May be in Sales area or multiple addresses etc. Check once again and update. If you still cant sort it out then paste screen shot of your table join screen.
Thank$
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Ok then follow these steps.
So the issue is with PA0001. It is because it has multiple start and end dates. I would suggest you to take End date in your selection and save it as 31.12.9999 by default. Create a selection variant for your report and make this field invisible and with value. Then give your customer number in report selection and see you will have one record only.
Please test and update..
Thank$
Hi,
I hope KNA1 is not required in this query as KNVP has customer number as Key. Try to select all key fields of all tables in the list output and see. There might be difference in at least one of the fields.
Thanks,
Vinod.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
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.