topic Re: Duplicate entries in Database View in Application Development and Automation Discussions

Duplicate entries in Database View

Former Member — Fri, 30 Dec 2005 07:40:35 GMT

Hi ,

I created view to get Sales Order BOM Material, PO Number , Vendor Name and Status of Sales Order based on Sales Order Number. I'm able to retrieve the Values but duplicate entries are coming in View.

How to avoid duplicates ?

Thanks,

anjani.

Re: Duplicate entries in Database View

Former Member — Fri, 30 Dec 2005 07:45:22 GMT

are they really duplicates, did you check it.

did you check select conditions.

check them properly..

vijay

Message was edited by: Vijay Babu Dudla

Re: Duplicate entries in Database View

Former Member — Fri, 30 Dec 2005 08:11:30 GMT

check this

http://www.sappoint.com/faq/faqsql.pdf

http://www.sap-basis-abap.com/abap/abap-interview-questions.htm

regs

Arun

Re: Duplicate entries in Database View

Former Member — Fri, 30 Dec 2005 09:25:18 GMT

Hi Anajani,

Please check whether you are using proper keys in the

Table/ Join conditions. Provide the complete key then

you wont get duplicate values.

Thanks&Regards,

Siri.

Re: Duplicate entries in Database View

madan_ullasa — Fri, 30 Dec 2005 09:35:56 GMT

Hi,

Im not sure if u vill get duplicates after creating a view. anyways if u r using this view in ur program, and u get duplicates , use " DELETE ADJACENT DUPLICATES "...

I was also getting duplicates when i used " inner join" in select statement. And database views are created using inner joins...

regrds,

Madan...

Re: Duplicate entries in Database View

Former Member — Fri, 30 Dec 2005 10:30:17 GMT

Hi Anjani,

You should be careful when creating views.

There are proper conditions to create a view. If you have

identified those conditions then you can create a view.

If the view is created with proper keys there will not be

any duplicate values. This link may help you in how to specify the conditions.

http://help.sap.com/saphelp_erp2004/helpdata/en/cf/21ec5d446011d189700000e8322d00/frameset.htm

Hope it helps you.

Regards,

Maheswaran.B

Re: Duplicate entries in Database View

Former Member — Fri, 30 Dec 2005 17:10:31 GMT

Please give us the tables you used in the view and your selection condition. Please explain what 'Sales Order BOM Material' means. Are you going to BOM tables directly? Then I am afraid, duplication is quite possible. A BOM in MAST for a material plant combination can have multiple alternates and also can remain in the table if there are multiple BOMs with different validity periods. I don't think you can simply create a view and eliminate the duplicates. You have to do it programatically.

Srinivas

Re: Duplicate entries in Database View

Former Member — Sat, 31 Dec 2005 04:06:22 GMT

Hi Srinivas ,

New search help should display following info for both fields.

Sales order Number , SO High level item number,SO high level material,SO Completion date,Warranty date(SO completion date + 12),Po document number,Po line item,Po line item description,Vendor number,Vendor name .

Based on the Sales Order Number i need to get all the information. BOM material is Hilgh level material in Sales Order . Only BOM materials should be displayed . to get the above fields i gave following Joins and Selection Conditions in View.

Table/Join Conditions :

VBAP-VBELN = EBKN-VBELN

VBAP-VBELN = VBAK-VBELN

EBKN-BANFN = EBAN-BANFN

EBAN-EBELN = EKKO-EBELN

JCDS-STAT = TJ02T-ISTAT

LFA1-LIFNR = EKKO-LIFNR

Selection Conditions :

VBAP-UEPOS NE '000010' AND

TJ02T-SPRAS EQ 'E' AND

JCDS-STAT EQ 'I0045' OR

JCDS-STAT EQ 'I0002'

Based on these i'm able to select correct entries . but getting duplicate entries.

Thanks,

anjani.