Skip to Content
0
Former Member
Dec 06, 2006 at 06:28 PM

Strange behavior of KONV

65 Views

Hi guys

In KONV table there are two records with the same data:

- this selection works fine:

      SELECT KPOSN KSCHL KWERT KAWRT KBETR KRECH KPEIN KMEIN FROM KONV
         INTO CORRESPONDING FIELDS OF TB_KONV
                                          WHERE KNUMV = TB_VBRK-KNUMV
                                            AND KSCHL IN TBINS_COND
*                                            AND KPOSN = TB_VBRP-POSNR
                                            AND KINAK = SPACE.
        INSERT TB_KONV INTO TABLE TB_KONV.
      ENDSELECT.

It can pick up the two records

- This selection doesn't work:

     SELECT KPOSN KSCHL KWERT KAWRT KBETR KRECH KPEIN KMEIN FROM KONV
         INTO CORRESPONDING FIELDS OF TABLE TB_KONV
                              FOR ALL ENTRIES IN  TB_VBRP
                                          WHERE KNUMV = TB_VBRK-KNUMV
                                            AND KSCHL IN TBINS_COND
                                            AND KPOSN = TB_VBRP-POSNR
                                            AND KINAK = SPACE.

It can pick up only one

Why?

Thanks

Max