on BDC

[Former Member]

one Object on BDC....thing is to change devilary class of items on Sales order. using VA02 which runs in Bakground mode for importing valid data and eliminate duplicate entries.

........problem..is how can i eliminate duplicate entries.? plz Answer anybody.

[Former Member]

hi,

in bdc we add records from Interna table header line(workarea) to body by using

APPEND statement. you use COLLECT statement insted of using APPEND statement.

the COLLECT statement aviods the duplicate records from table, if any record exisisting with the same record number, the current record contents are added to the exisisting record.

<b>sample code</b>

form bdc_field using fname1 fvalue1.

refresh bdcdata.

bdcdata-fname = fname1.

bdcdata-fvalue = fvalue1.

COLLECT bdcdata.

endform.

regards,

Ashokreddy