topic Re: on BDC in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/on-bdc/m-p/2446506#M548003 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>in bdc we add records from Interna table header line(workarea) to body by using </P><P>APPEND statement. you use COLLECT statement insted of using APPEND statement.</P><P></P><P>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.</P><P></P><P></P><P>&lt;b&gt;sample code&lt;/b&gt;</P><P></P><P>form bdc_field using fname1 fvalue1.</P><P>refresh bdcdata.</P><P> bdcdata-fname = fname1.</P><P> bdcdata-fvalue = fvalue1.</P><P> COLLECT bdcdata.</P><P>endform.</P><P></P><P>regards,</P><P>Ashokreddy</P></BODY></HTML> Thu, 21 Jun 2007 21:49:50 GMT Former Member 2007-06-21T21:49:50Z on BDC https://community.sap.com/t5/application-development-and-automation-discussions/on-bdc/m-p/2446505#M548002 <HTML><HEAD></HEAD><BODY><P>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.</P><P>........problem..is how can i eliminate duplicate entries.? plz Answer anybody.</P></BODY></HTML> Thu, 21 Jun 2007 20:32:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/on-bdc/m-p/2446505#M548002 Former Member 2007-06-21T20:32:53Z Re: on BDC https://community.sap.com/t5/application-development-and-automation-discussions/on-bdc/m-p/2446506#M548003 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>in bdc we add records from Interna table header line(workarea) to body by using </P><P>APPEND statement. you use COLLECT statement insted of using APPEND statement.</P><P></P><P>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.</P><P></P><P></P><P>&lt;b&gt;sample code&lt;/b&gt;</P><P></P><P>form bdc_field using fname1 fvalue1.</P><P>refresh bdcdata.</P><P> bdcdata-fname = fname1.</P><P> bdcdata-fvalue = fvalue1.</P><P> COLLECT bdcdata.</P><P>endform.</P><P></P><P>regards,</P><P>Ashokreddy</P></BODY></HTML> Thu, 21 Jun 2007 21:49:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/on-bdc/m-p/2446506#M548003 Former Member 2007-06-21T21:49:50Z