topic getting one extra row for each object_id using insert lines statement. in Application Development and Automation Discussions

getting one extra row for each object_id using insert lines statement.

Pranil1 — Mon, 16 Jul 2007 11:30:42 GMT

Hi.

I m using insert lines statement to merge two internal table. Its working properly but i m getting one blank row extra for each object id. so i wanna know how to delete this one extra row.

I m using the following syntax.

LOOP AT ITAB.

LOOP AT NTAB WHERE PARTNER_FCT = '00000015'.

IF NTAB-object_id = iTAB-object_id .

itab-partner_no2 = NTab-partner_no2.

itab-partner_fct = ntab-partner_fct.

itab-bez30 = ntab-bez30.

itab-bez20 = ntab-bez20.

itab-bez2 = ntab-bez2.

itab-others = ntab-others.

INSERT lines of nTAB INTO ITAB.

modify itab.

sort itab by OBJECT_ID descending PARTNER_NO2 .

delete adjacent duplicates from itab comparing partner_no2 object_id.

ENDIF.

endloop.

Thanx in Advance.

Pranil Shinde.

Re: getting one extra row for each object_id using insert lines statement.

Former Member — Mon, 16 Jul 2007 11:36:58 GMT

Are you trying to update some fields of a single row of itab from ntab or want to insert a new line in itab?

Re: getting one extra row for each object_id using insert lines statement.

Pranil1 — Mon, 16 Jul 2007 14:04:11 GMT

I am trying to update some fields of a single row of itab from ntab

Re: getting one extra row for each object_id using insert lines statement.

Former Member — Mon, 16 Jul 2007 14:31:45 GMT

Hey try using in following way...

LOOP AT ITAB.

LOOP AT NTAB WHERE PARTNER_FCT = '00000015' and object_id = iTAB-object_id .

itab-partner_no2 = NTab-partner_no2.

itab-partner_fct = ntab-partner_fct.

itab-bez30 = ntab-bez30.

itab-bez20 = ntab-bez20.

itab-bez2 = ntab-bez2.

itab-others = ntab-others.

modify itab.

sort itab by OBJECT_ID descending PARTNER_NO2 .

delete adjacent duplicates from itab comparing partner_no2 object_id.

endloop.

Regards

Prax