topic Re: Duplicate records data on view in Application Development and Automation Discussions

Duplicate records data on view

Former Member — Thu, 10 Sep 2009 07:18:51 GMT

Dear Gurus

I create view and join some colume of table VBAK VBAP VBKD

This join condition.

VBAP.MANDT = VBAK.MANDT

VBAP.VBELN = VBAK.VBELN

VBAP.VBELN = VBKD.VBELN

Data records is dupplicate, what happen and how to resolve?

Thank.

Re: Duplicate records data on view

Former Member — Thu, 10 Sep 2009 07:41:39 GMT

Hello

And what fields from what tables are present in view ?

Re: Duplicate records data on view

Former Member — Thu, 10 Sep 2009 08:20:16 GMT

Dear Maroz

MANDT CLNT 3 Client

VBELN CHAR 10 Sales Document

MATNR CHAR 18 Material Number

COMMINV CHAR 10 Commercial Invoice No.

KUNNR CHAR 10 Sold-to party

ZROUTE CHAR 6 Route

ERDAT DATS 8 Date on Which Record Was Created

KNUMV CHAR 10 Number of the document condition

POSNR NUMC 6 Sales Document Item

KWMENG QUAN 15 Cumulative Order Quantity in Sales Units

ZJOBNO CHAR 20 Job No.

ZJOBDATE DATS 8 Job Date

BSTKD CHAR 35 Customer purchase order number

ZTERM CHAR 4 Terms of Payment Key

KURSK DEC 9 Exchange Rate for Price Determination

Re: Duplicate records data on view

Former Member — Thu, 10 Sep 2009 08:23:42 GMT

Hello

Try to add in join conditions:

VBAP.POSNR = VBKD.POSNR

Re: Duplicate records data on view

Former Member — Thu, 10 Sep 2009 08:29:55 GMT

There might be multiple entries for Vbeln field (sales document) in VBAP table, thats why its fetching the duplicate entries.

Regards,

Prashant

Re: Duplicate records data on view

Former Member — Thu, 10 Sep 2009 09:16:26 GMT

Thank Maroz

I alredy try, no record select.

Re: Duplicate records data on view

Former Member — Thu, 10 Sep 2009 10:38:25 GMT

Hello

In such event try this:

join conditions:

VBAP.MANDT = VBAK.MANDT

VBAP.VBELN = VBAK.VBELN

VBAP.MANDT = VBKD.MANDT

VBAP.VBELN = VBKD.VBELN

selection conditions:

VBKD-POSNR = '000000'

Re: Duplicate records data on view

Former Member — Thu, 10 Sep 2009 13:08:25 GMT

try with

vbak-vbeln = vbap-vbeln

vbak-vbeln = vbkd-vbeln

Re: Duplicate records data on view

Former Member — Fri, 11 Sep 2009 03:53:22 GMT

Join conditions will be as below :

VBAK and VBAP by VBELN

VBKD by VBELN and POSNR from VBAP.

Duplicate entries should not come after this..

Re: Duplicate records data on view

Former Member — Mon, 14 Sep 2009 08:57:58 GMT

HI,

try this.

VBAP.MANDT = VBAK.MANDT

VBAP.VBELN = VBAK.VBELN

Thanks and Regards,

Ahamed.

Re: Duplicate records data on view

Former Member — Mon, 14 Sep 2009 08:59:32 GMT

and also try this. i forgot show this...

vbap.vbeln = vbkd.vbeln.

Thanks and Regards,

Ahamed.

Re: Duplicate records data on view

Former Member — Thu, 15 Oct 2009 10:34:20 GMT

Hi,

Try to display MANDT in the View Fields, it should solve your problem.

Regards,

Nicolas