incorrect data selection

Former Member — Thu, 05 Aug 2010 14:07:35 GMT

Hi experts,

below is my part of code.

SELECT A~MATNR A~VKORG A~AUDAT A~VTWEG A~SPART A~AUART
           A~VKBUR A~VKGRP A~KUNNR A~VBELN A~POSNR A~WERKS B~ETENR
           B~J_3ASIZE B~J_4KRCAT B~J_3AABGRU B~LMENG B~J_3ANETW
           FROM VAPMA AS A JOIN VBEP AS B ON A~MANDT = B~MANDT
                                         AND A~VBELN = B~VBELN
                                         AND A~POSNR = B~POSNR

           INTO CORRESPONDING FIELDS OF TABLE IT_VBEP
           FOR ALL ENTRIES IN TMP_PLAN
           WHERE A~MATNR EQ TMP_PLAN-STYLECODE
             AND A~VKORG EQ P_VKORG
             AND A~TRVOG EQ '0'
             AND A~AUDAT IN S_AUDAT
             AND A~VTWEG IN S_VTWEG
             AND ( A~AUART IN S_AUART AND A~AUART NE 'ZORB' AND
                   A~AUART NE 'ZKA' AND A~AUART NE 'KA'     AND
                   A~AUART NE 'ZRE' AND A~AUART NE 'RE'     AND
                   A~AUART NE 'ZKE' AND A~AUART NE 'ZKR'    AND
                   A~AUART NE 'ZCR' AND A~AUART NE 'ZDR' )
             AND A~KUNNR IN S_KUNNR
             AND A~WERKS IN S_WERKS.

in the above code when i debug the values are like this.

matnr is space, vkorg = 1000 , audat between 01.01.2010 to 01.02.2010

vtweg eq space and auart ne above specified values and kunnr eq space and werks eq space.

while debugging i get 4 entries in it_vbep for which vbeln contains 3 repeated entries 1998(3 times) and another entry 1999(once).

but if i put exact selection option in VAPMA table i get only 2 entries where vbeln is 1998 & 1997.

and it_vbep contains wrong spart value(HR,which is not correct as we are providing LE only on selection screen) also for vbeln 1999.

Am i getting this duplicate entry in it_vbep because of 'FOR ALL ENTRIES IN TMP_PLAN'.?????

plz help.

You would help yourself by using code tags to format the code

Regards,

Ashmita Singh

Edited by: Rob Burbank on Aug 5, 2010 10:13 AM

Re: incorrect data selection

andreas_mann3 — Thu, 05 Aug 2010 14:27:18 GMT

this part

AND ( A_{AUART IN S_AUART AND A}AUART NE 'ZORB' AND
                   A_{AUART NE 'ZKA' AND A}AUART NE 'KA'     AND
                   A_{AUART NE 'ZRE' AND A}AUART NE 'RE'     AND
                   A_{AUART NE 'ZKE' AND A}AUART NE 'ZKR'    AND
                   A_{AUART NE 'ZCR' AND A}AUART NE 'ZDR' )

seems to be contradictorily - please check it

and use ranges or select-options for the literals 'ZKA' . etc.

hope that helps

Andreas

Edited by: Andreas Mann on Aug 5, 2010 4:27 PM

topic Re: incorrect data selection in Application Development and Automation Discussions

incorrect data selection

Re: incorrect data selection