Data inconsistency in database view

[former_member382013]

After Executing one database view, i m getting 22000 records. But as per the requirement after deleting the duplicate entries, only 800 records are there but customer is expecting more than 2800+ records. As I am new so don't know the initial approach.

Experts plz help...........

[ThomasZloch]

What do you mean with "executing a database view"?

What means "getting 22000 records"?

How are you deleting duplicate entries?

Where are the 800 records?

What is the requirement and what does the customer expect?

Please don't use SMS speak like "plz".

Thomas

[former_member382013]

1. executing means clicking on contents
2. after clicking on contents 22000 records are coming
3. some records are same (that is one record is repeating 7 or 8 times)
4. as in point 3, after deleting the duplicate entries, only 800 records are there.
5. expected records are more than records coming. End user is expecting more than 2800 records
6. I will not use SMS speak like "plz".

[matt]

"Executing means clicking on contents

No - that doesn't mean anything either. What exactly are you doing?

Why does the user expect 2800 records? If there are only 800, then there are only 800. A user's expectation is kind of irrelevant when faced with facts. A user may expect all kinds of things.

[Former Member]

Hi Anand,

Is it custom database view?

If yes then show me the screenshot of database view created by you because duplicate entrries should not exist in database view.

Regards,

Sudeesh Soni

[former_member382013]

hi Sudheesh.

screenshot for join conditions

screenshot of contents

thanks

Anand

[Former Member]

Hi Anand,

You need to keep a note that in database view try to mapped most of the table key fields with another table if not possible then give the not mapped field value in Selection condition.

Also, always mapped field MANDT as a 1st table condition in table join.

Please recheck your database view and incorporate above mentioned point, i hope it will give much more accurate result in view output.

Refer below mentioned thread in which we resolved the same issue.

Regards,

Sudeesh Soni

[former_member382013]

Hi Sudeesh,

Sorry for being late.

I Checked all the join conditions. All of them are correct.

But one point that I noted is, For some vendors LFBK, ADR2,ADR6,LFM1,ADR3 tables do not contain any value.

is this the reason for improper data.

Please let me know.

[Former Member]

If your key field is getting duplicate then you need to re-evaluate join conditions.

you need to concentrate on other primary keys from all other tables

and apply specific condition to them so they will also come unique .

for example...consider

vendor master company code (LFB1 - here bukrs)

Vendor master record purchasing organization data (LFM1 -  here Purchasing Organization)