ITAB_DUPLICATE_KEY

Former Member — Tue, 26 Feb 2013 18:51:34 GMT

We are getting a "ITAB duplicate key" error in a DataSource enhancement for BW that selects data from table MBEW into a hash table. The internal table has the same fields as the key of the table. I don't understand how we could be getting ITAB_DUPLICATE_KEY error when the where clause on the select statement has the key of the table. Is this a buffering issue? Here's a subset of the important code:

TYPES:
    BEGIN OF TY_MBEW,          "Material Valuation
      MATNR TYPE MBEW-MATNR,   "Material Number
      BWKEY TYPE MBEW-BWKEY,   "Valuation Area
      BWTAR TYPE MBEW-BWTAR,   "Valuation Type
      STPRS TYPE MBEW-STPRS,   "Standard Price
      PEINH TYPE MBEW-PEINH,   "Price Unit
      VERPR TYPE MBEW-VERPR,   "Moving Average Price/Periodic Unit Price
      VPRSV TYPE MBEW-VPRSV,   "Price Control Indicator
    END OF TY_MBEW.

DATA:

IT_MBEW_HSH TYPE HASHED TABLE OF TY_MBEW
WITH UNIQUE KEY MATNR BWKEY BWTAR,

SELECT MATNR
         BWKEY
         BWTAR
         STPRS
         PEINH
         VERPR   "Moving Average Price/Periodic Unit Price
         VPRSV   "Price Control Indicator
    FROM MBEW
    INTO CORRESPONDING FIELDS OF TABLE it_mbew_hsh
    FOR ALL ENTRIES IN LI_DATA
    WHERE MATNR = LI_DATA-MATNR AND
          BWKEY = LI_DATA-WERKS AND
          BWTAR = ''.

Re: ITAB_DUPLICATE_KEY

Former Member — Tue, 26 Feb 2013 19:35:18 GMT

Hi,

When you use for all entries in the select statement u should not use the table in the into clause as Hashed table instead use the standard table along with where clause with all primary key fields.

Regards,

Vineesh.

topic Re: ITAB_DUPLICATE_KEY in Application Development and Automation Discussions

ITAB_DUPLICATE_KEY

Re: ITAB_DUPLICATE_KEY