topic Re: duplicate entries in Application Development and Automation Discussions

duplicate entries

Former Member — Mon, 18 Feb 2008 06:25:21 GMT

hi experts,

my select command is fetching duplicate entries..however in the database there are no such entries..tell me wat is the reason for this..m sending u the code of my select commands.

SELECT A_{BELNR A}DMBTR A_{BUDAT A}XBLNR A_{SGTXT A}SHKZG A_{BLART A}HKONT A_{ZUONR B}STBLG A~BLART INTO CORRESPONDING FIELDS OF TABLE IT_BSIS

FROM BKPF AS B INNER JOIN BSIS AS A ON ( A_{BELNR = B}BELNR )

WHERE A_{BUKRS = BUKRS AND A}BUDAT IN POSTDAT

AND A_{BLART = 'DG' AND A}GJAHR = YEAR

AND B~STBLG = ' ' AND ZUONR IN CUST

AND ( A~HKONT BETWEEN '0000235001' AND '0000235050'

OR A~HKONT BETWEEN '0000235101' AND '0000235201' )..

CLEAR IT_BSIS.

SELECT A_{BELNR A}DMBTR A_{BUDAT A}XBLNR A_{SGTXT A}SHKZG A_{BLART A}HKONT A_{ZUONR B}STBLG A~BLART INTO CORRESPONDING FIELDS OF IT_BSIS

FROM BSAS AS A INNER JOIN BKPF AS B ON ( A_{BELNR = B}BELNR )

WHERE A_{BUKRS = BUKRS AND A}BUDAT IN POSTDAT

AND A_{BLART = 'DG' AND A}GJAHR = YEAR

AND B~STBLG = SPACE AND ZUONR IN CUST

AND ( A~HKONT BETWEEN '0000235001' AND '0000235050'

OR A~HKONT BETWEEN '0000235101' AND '0000235201' )..

APPEND IT_BSIS.

CLEAR IT_BSIS.

ENDSELECT..

regards,

raman

Re: duplicate entries

Former Member — Mon, 18 Feb 2008 06:35:30 GMT

Since you are using the Joins, because of this the system checks the all the tables which are there joins and adds the fields which are having multiple entries to the itab

check the record which is having multiple entries and validate in all the tabels used by joins

delete which are not required

Regards

Shiva

Re: duplicate entries

Former Member — Mon, 18 Feb 2008 06:36:11 GMT

Hi,

After fetching the data,use DELETE ADJACENT DUPLICATES

statement.

Regards,

Ravindra

Re: duplicate entries

kesavadas_thekkillath — Mon, 18 Feb 2008 06:38:27 GMT

Just check..the second query will append the records after the first fetch...

Split ur query and process it...

Re: duplicate entries

Former Member — Mon, 18 Feb 2008 06:40:10 GMT

Hi,

after the query..sort the table with belnr then,

sort it_bsis by belnr,

delete adjacent duplicates from it_bsis comparing belnr.

hope it helps,

pls reward if helps,

regards.