Large table S003: No first field of a table index in WHERE condition

[Former Member]

in code inspector   error

Large table S003: No first field of a table index in WHERE condition

any one help me

SELECT VKORG AS SALESORG

          VTWEG AS DISTR_CHANNEL

          SPART AS DIVISION

          KUNNR AS CUSTOMER

          MATNR AS MATERIAL

          SUM( UMNETWR )  AS SALES

          SUM( UMMENGE )  AS BILLING_QTY

          SUM( UMWAVWR )  AS INV_SALES_COST

          SUM( UMKZWI1 )  AS GROSS_SALES

          FROM S003

          INTO CORRESPONDING FIELDS OF TABLE P_ITAB_S_R

          WHERE VKORG = P_IM_SALESORG AND VTWEG = P_IM_DISTR_CHANNEL AND SPART = P_IM_DIVISION

                AND KUNNR = P_IM_CUSTOMER  AND SPMON IN P_S_RANGE

          GROUP BY VKORG VTWEG SPART KUNNR MATNR.

same error in another code

SELECT VKORG AS SALESORG

        VTWEG AS DISTCHANNEL

        SPART AS DIVISION

        KUNNR AS CUSTOMERNO

        FROM KNVV

        INTO CORRESPONDING FIELDS OF P_WA_ZMOUN

         WHERE  VKORG = P_IM_SALESORG AND

                VTWEG = P_IM_DISTCHANNEL AND

                SPART = P_IM_DIVISION.

[JasonLax]

SCN Support is for SAP Community Network support related queries only.

To get a quick (or any) response, create your new discussion in a space related to your query.  This way it will be visible to topic experts who will then see and reply to it.  The SCN Site Index contains a full listing of all SCN spaces.

Where should this thread be moved to?