Select mit Aggregation

Code: Alles auswählen.

  select sum( labst ) matnr from mard
                    into corresponding fields of table t_mard
                      where werks in so_werks
                        and matnr in so_matnr
                        and lgort ne 'KD'                   "BO300511
                        and lvorm =  space
                            group by matnr .

Code: Alles auswählen.

assign t_mard to <t_mard>.

  select sum( labst ) matnr from mard
                    into (<t_mard>-labst, <t_mard>-matnr )
                      where werks in so_werks
                        and matnr in so_matnr
                        and lgort ne 'KD'                   "BO300511
                        and lvorm =  space
                           group by matnr .

    append <t_mard> to t_mard.

  endselect.