Internal Table Operations...

[Former Member]

hi all,

i have a internal table , iam sorting with three fields ,, say x1,x2, x3...

i have values like this

x1 x2 x3

001 inr 01.01.2007

001 inr 01.01.2007

001 inr 02.01.2007

001 cad 01.01.2007

001 cad 01.01.2007

002 us 01.01.2007

002 cad 03.01.2007 for the internal table ..

first two lines should be posted once, next one line item and then next two line item etc ,, in tat manner , how to control the statements ??

plz give some idea on it..

thanks in advance

[Former Member]

i think you want to delete the duplicate entries from internal table

use this..

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS.

[Former Member]

i don't want to delete duplicate records ,,

i need to collect the records based on sorting and post it ...

[Former Member]

Hi,

i advise you to have a look at the statements 'at first.' and 'at new.' , to be used inside a loop.

regards,

Rolf

[Former Member]

Hi Krishna,

Use Control breaks.

sort itab by x1 x2 x3.

loop at itab.

at new x1.

write:/10 iatb-x1.

endat.

at new x2.

write:/10 iatb-x2.

endat.

write:/10 iatb-x3.

endloop.

Regards,

Hemant

[Former Member]

hi ,

yeah iam using control Break Statements.. i am using AT new statement,, at end of x1 statements..

at end of X1 -- i need to post a doc

at end of x2 -- i need to post a doc

at end of x3 -- i need to post a doc

how to handle this part

[Former Member]

Hi,

If using 'At New' is not giving you the desired result, create another internal table with same structure as the first one and append one record at a time, until one of the 3 fields changes from the previous record. Post those records that are appended into the second internal table.

[Former Member]

hi Krishna,

As your internal table is having duplicate records you can use.

delete adjacent duplicates....

to delete the duplicate entries in the internla table ..

Regards,

Jayant

[Former Member]

Hi

The data what is given is incorrect.Same data in 2 records(repetetive)

Are you talking about one header Header and mulitple Item records

Keep a Single char field first in the file (with H (header)and I (Item)values) and then do the processing of upload to post multpile item records for one single record.

Means there should be some differentiation key in the internal table to disntuinguish whether the record is a Header or Item record.

Reward points if useful

Regards

Anji

[Former Member]

HE'S RIGHT...

or you can also use

DELETE ADJACENT DUPLICATES FROM <NAME OF ITAB> COMPARING <NAME OF FIELD1>.

[Former Member]

Hi Krishna,

Use the following code after the sort statement:

DELETE ADJACENT DUPLICATES FROM itab COMPARING x1 x2 x3.

If you want to compare all fields, first sort table on all fields and then use the following satement:

DELETE ADJACENT DUPLICATES FROM itab COMPARING ALL FIELDS.

Hope it helps.

Regards,

Neeraj

[Former Member]

loop at itab.

At new x3.

"Post data using x1,x2,x3

End At.

endloop.