cancel
Showing results for 
Search instead for 
Did you mean: 

SQVI

siva_vasireddy2
Active Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member183155
Active Contributor
0 Kudos

Hi all ;

Can you try this path ?

     Regards

     M.Ozgur Unal

siva_vasireddy2
Active Contributor
0 Kudos

Hi,

Thanks for the Reply

plz check my screen shots

JL23
Active Contributor
0 Kudos

add all key fields of PA0001 table to the shown fields, then you will probably see that there is a difference

siva_vasireddy2
Active Contributor
0 Kudos

Sir,

i have tried as per your Suggestion but still the Duplicates are Displayed

JL23
Active Contributor
0 Kudos

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.

siva_vasireddy2
Active Contributor
0 Kudos

Sir,

In the selections iam just executing with one sales area and one customer

which is getting repeated twice in the display as shown in my previous postings

JL23
Active Contributor
0 Kudos

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?

former_member183155
Active Contributor
0 Kudos

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_vasireddy2
Active Contributor
0 Kudos

Hi,

Thank you for sharing the Document

you mean to tell this is the standard behaviour of the system.

former_member183155
Active Contributor
0 Kudos

Hi Siva ,

It is result of your Enterprise Structure Design , i hope that you did not benefit from cross division for this reason you create customer master data for all sd area.

Regards.

M.Ozgur Unal

siva_vasireddy2
Active Contributor
0 Kudos

Hi,

yes Exactly

Hope  we can solve this problem with Query creation through sq01,sq02,sq03

Former Member
0 Kudos

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

former_member183155
Active Contributor
0 Kudos

Hi Mr. Dogboy ;

I think that this duplication record related with unusing of cross division in Sd area. Am i right ?

KNA1 have records for all sd area for a custumer.

Regards.

M.Ozgur Unal

Former Member
0 Kudos

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_vasireddy2
Active Contributor
0 Kudos

Hi,

i have done as Suggested and tested but i could not find MANDT field in KNVP

could you plz Test the same scenarion at your end as i cannot post too many screen shots in the Blog.

Thanking you in Advance

Siva

Former Member
0 Kudos

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_vasireddy2
Active Contributor
0 Kudos

Hi,

1. still joining KNA1 to KNVP on KUNNR; 

yes

2. still joining PA0001 to KNVP on PERNR.  

yes

3. you have examined PA0001 table in detail, and you have verified that for every PERNR, there is one and only one entry. 

yes

After Executing every field is repeated Twice.

Former Member
0 Kudos

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

moazzam_ali
Active Contributor
0 Kudos

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$

siva_vasireddy2
Active Contributor
0 Kudos

Hi,

plz find the screen shot

moazzam_ali
Active Contributor
0 Kudos

Hi

Ok then follow these steps.

  • Go to SE11>KNA1 and give your customer number and see there will be only one line.
  • Go to SE11>KNVV and give your customer number and sale area and see there will be one line.
  • Go to SE11>PA0001 and give employee number and see there will be 3 lines.

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$

siva_vasireddy2
Active Contributor
0 Kudos

Hi,

i have tried as per your Suggestion with taking End date in the Selection but still the Duplicates are Displaying.

JL23
Active Contributor
0 Kudos

how many partners which are linked to a personal number do you have in KNVP for your customer?

you get a record in the list per partner

siva_vasireddy2
Active Contributor
0 Kudos

we have two 2 additional partner functions

JL23
Active Contributor
0 Kudos

the question is what you want to show as result,

you may need to add the fields from KNVP into your selection and select then only a certain partner role.

siva_vasireddy2
Active Contributor
0 Kudos

iam displaying the Following field

customer number

name1,name2,region,city,postal code,phone number,sales area,salesoffice,employee code and name

Iam selecting only particular partner Function

moazzam_ali
Active Contributor
0 Kudos

Then please follow the steps I have mentioned in my earlier post and see which field is causing duplication. Like I have said you can control this by taking that field in selection giving some value. You have to identify the duplication cause by checking the joins and fields in SE11.

Thank$

siva_vasireddy2
Active Contributor
0 Kudos

All the Fields in the Display report for Repeating thrice

JL23
Active Contributor
0 Kudos

you are selecting based on partner role

so go into SE16 for table KNVP and do the same selection, how many records do you see?

take the personal number from all those records

and do SE16 at table  PA0001

How many records do you have?

siva_vasireddy2
Active Contributor
0 Kudos

Sir,

in SE16 iam able to see the Exact Records and no Duplications are seen but in SQVI Duplicates are Appearing

i have tried with Sorting option in the report,after sorting Duplicates are not visible but while exporting the data to Excel i can Find the Duplicates.

JL23
Active Contributor
0 Kudos

what about some screen shots of your selection in SQVI

the result in SQVI

the selection for SE16 KNVP and its result

and selction and result for SE16 PA0001

vinod_vemuru2
Active Contributor
0 Kudos

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.

siva_vasireddy2
Active Contributor
0 Kudos

Hi,

Thanks for the Reply

iam also extracting complete Address detials of the customer along with Phone numbers

vinod_vemuru2
Active Contributor
0 Kudos

Hi,

I was talking about all the primary key fields of all the tables.

Thanks,

Vinod.

siva_vasireddy2
Active Contributor
0 Kudos

Hi,

May be the problem is customer number is existing the in both tables,so the Dupicates are Dispalyed

iam displaying the Following field

customer number

name1,name2,region,city,postal code,phone number,sales area,salesoffice,employee code and name