Skip to Content
author's profile photo Former Member
Former Member

short dumop in J2I5 (provide duplicate entry in Standard table)

Hello Expert ,

We have a problem in T.Code J2I5 ( Excise Register Extraction) input entry is lelect Excise group 20 . and a date from 04.08.09 onwards. and select the register RG23D . it shows the run time error ( Eg The ABAP/4 Open SQL array insert results in duplicate database record ) . but in the standard Tcode is there possible to provide duplicate entry in Standard table

Thaks & regards

Aditya Kr Tripathi

.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2010 at 08:01 AM

    Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

    Except. CX_SY_OPEN_SQL_DB

    Date and Time 29.01.2010 10:57:09

    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

    problem occurs in this code :

    • assign I_RG23D_TAB-I_RG23D_TYP to <x_rg23dtyp> casting.

    • <x_extrctdata> = <x_rg23dtyp>.

    class CL_ABAP_CONTAINER_UTILITIES definition load.

    call method CL_ABAP_CONTAINER_UTILITIES=>FILL_CONTAINER_C

    EXPORTING

    IM_VALUE = i_rg23d_tab-i_rg23d_typ

    IMPORTING

    EX_CONTAINER = i_report_tab-extrctdata

    EXCEPTIONS

    ILLEGAL_PARAMETER_TYPE = 1

    others = 2.

    • I_REPORT_TAB-EXTRCTDATA = I_RG23D_TAB-I_RG23D_TYP.

    COMPUTE I_REPORT_TAB-EXTRCTLNGT = STRLEN( I_REPORT_TAB-EXTRCTDATA ).

    APPEND I_REPORT_TAB.

    ENDLOOP.

    IF M_EXTRACTED = 'X'.

    LOOP AT I_RG23D_KEY.

    DELETE

    FROM J_2IEXTRCT

    WHERE BUDAT = I_RG23D_KEY-BUDAT

    AND SERIALNO = I_RG23D_KEY-SERIALNO

    AND REGISTER = I_RG23D_KEY-REGISTER

    AND EXGRP = I_RG23D_KEY-EXGRP.

    ENDLOOP.

    ENDIF.

    • Control table check here for data Extraction

    INSERT J_2IEXTRCT FROM TABLE I_REPORT_TAB.

    • If the insertion of the extract table is successfull then the table

    • for Extraction is Inserted

    IF SY-SUBRC EQ 0.

    PERFORM FILL_EXTDT USING C_RG23D M_EXTRACTED.

    ENDIF.

    ENDFORM. " RG23D

    *

    &----


    *& Form RG23CPART1

    &----


    • Purpose : RG23C Part I extraction logic

    ----


    FORM RG23CPART1.

    DATA: $PART1 TYPE PART1_TYP,

    $LINCNT LIKE SY-LINCT,

    M_EXTRACTED VALUE '',

    $RC LIKE SY-SUBRC.

    *********************************************************************************************8

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.