select and count

[Former Member]

Hello everyone,

I need codding to process VBAK table and get information for KNUMVs wchich appears more than 1.
KNUMV is not key field here and im processing data to KONV where KNUMV is a key field, and I need check it before processing to not get any errors about duplicates.

Anyone can help?

[GK817]

Hi Beata,

Distinct Column:

SELECT COUNT( DISTINCT carrid )  FROM spfli  WHERE cityto = 'NEW YORK'  INTO @DATA(count).

Distinct Row:

SELECT DISTINCT cityto
  FROM spfli
  WHERE carrid = 'LH' AND
  cityfrom = 'FRANKFURT'
  INTO TABLE @DATA(destinations).

Gaurav

[VeselinaPeykova]

Would you please share an example where you have more than one entry in VBAK for a specific VBAK-KNUMV?

[former_member1716]

plmalekbe,

I don't think that is necessary because every sales order in VBAK table will have unique Condition record numbers.

If you still need to check you can use below code, after the delete statement if you still have any entries left in table GT_VBAK then those are the KNUMV entries which are assigned to multiple VBELN values.

SELECT knumv,
       COUNT( vbeln ) AS count
FROM vbak
INTO TABLE @DATA(gt_vbak)
GROUP BY knumv.
IF sy-subrc EQ 0.
  DELETE gt_vbak WHERE count EQ 1.
ENDIF.

Regards!

[DoanManhQuynh]

so why don't inner join those table?

[Former Member]

Hi,

Thank you all for help, Satish your codding its very nice,

I will use it for sure. You may be right with VABK because I was checking it for many tables and this is true that VABAK was fine, but for example in VFKONV i found duplicates in KNUMV and I had to change approchach. Thanks again!

Example from se16h:

przechwytywanie.png