SQL Count on multiple fields

Former Member — Mon, 17 Sep 2007 16:50:14 GMT

Does anyone know if it is possible to create a count on multiple fields. I am trying to create an SQL statement that will indicate the number of Delivery Items in a Shipment.

The Delivery and Delivery-item need to be counted for each shipment. I was hoping to use something like the following but I can not get it passed the syntax checker:

select OI_SHNUM

count( distinct OI_DOCNR OI_ITEM )

from /BIC/AZOITRO0200

into table i_dlvCount_data

group by OI_SHNUM.

select OI_SHNUM

count( distinct OI_DOCNR )

count( distinct OI_ITEM )

from /BIC/AZOITRO0200

into table i_dlvCount_data

group by OI_SHNUM.

Any ideas appreciated. For the time being I will concatenate these in the preceeding BW data target.

Re: SQL Count on multiple fields

Former Member — Tue, 18 Sep 2007 20:03:39 GMT

This should work:

DATA: BEGIN OF i_dlvcount OCCURS 0,
        oi_shnum TYPE /bic/azoitro0200-oi_shnum,
        oi_docnr TYPE i,
        oi_item  TYPE i,
      END   OF i_dlvcount.

SELECT oi_shnum
       COUNT( DISTINCT oi_docnr )
       COUNT( DISTINCT oi_item )
  FROM /bic/azoitro0200
  INTO TABLE i_dlvcount_data.

Rob

topic Re: SQL Count on multiple fields in Application Development and Automation Discussions

SQL Count on multiple fields

Re: SQL Count on multiple fields