SQ02 exclude lines with same specific columns

[Former Member]

Hello,

I created Infoset with LTAK / LTAP tables (join via Warehouse number and Transfer order number).  There is one TO which has lines with same Source type, same source bin, same destination type, same destination st. bin, different TO item (field TO item is not in infoset /field group) .

I created query with source type/bin, destination type/bin and query showed me all lines. (I dont have access to ABAP coding) Is there possibility to define in infoset to show in query only one line where is same TO, same source type/bin, same destination type/bin?

Im trying to create statistics where must be only one record where is same TO, same source type/bin, same destination type/bin but always are showed all lines :-(.

Thank you

Standa

[eduardo_hinojosa]

Hi Standa

Try to do in the query definition (tcode SQ01) but instead in basic list, do it in statistics

I hope this helps you

Regards

Eduardo

[Former Member]

Hi Eduardo, this is what I tried, but statistics always show sum of all lines.

Please let me to re-defined this.

- I created infoset with LTAP / LTAK table and in LTAP table is one Transfer order with 10 lines. 3 lines has same TO number, same Source type, same source bin, same destination type, same destination st. bin, same storage location, different TO item. I was able to create statistics:

Storage location A - 10 (sum of lines)

But I would like to count as "1" following: same TO number, same Source type, same source bin, same destination type, same destination st. bin, same storage location. I was able to create statistics:

So output should to show:

Storage location A - 8 (sum of lines)

I was also able to define statistics by line - I choose in statistics following:

Storage location, TO number, Source type/bin, destination type bin and I got output 8 lines. But I dont know how to create statistics only with those 8 lines so output will show only one line:

Storage location A - 8 (sum of lines)