topic Re: SQ02 exclude lines with same specific columns in Application Development and Automation Discussions

SQ02 exclude lines with same specific columns

Former Member — Tue, 03 Dec 2013 09:00:12 GMT

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

Re: SQ02 exclude lines with same specific columns

eduardo_hinojosa — Tue, 03 Dec 2013 14:51:25 GMT

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

Re: SQ02 exclude lines with same specific columns

Former Member — Thu, 05 Dec 2013 12:40:30 GMT

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)