duplicate entries

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

Hi,

After fetching the data,use DELETE ADJACENT DUPLICATES

statement.

Regards,

Ravindra

[kesavadas_thekkillath]

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

Split ur query and process it...

[Former Member]

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.