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

CIN

Dear all.

How do I update the material data in to the table J_2irg1bal. This is required for the excise register update program.

Regards.

Milind

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2008 at 12:09 PM

    Hi,

    You can use Transaction J1I5. I havent tried yet.

    Let me know if it works.

    Regards,

    Komal

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 22, 2008 at 12:11 PM

    Hi,

    Go to SE16, here enter Table Name - J_2IRG1BAL and Click on "Create" button in initial screen, it will give the maintenance screen. Here mainatin following;

    For each of these materials, you have maintained the material form in table J_2IRG1BAL as below. Do not make any entries in fields that are not listed below:

    EXGRP - Materialu2019s excise group

    DATUM - Date from which RG1 report is required, normally the date of going live

    MATNR - Material

    FORM - Enter P (Packed) or L (Loose). Do not leave this field blank.

    WERKS - Leave this field blank.

    OP FN UOM, OP BN UOM, CB FN UOM - Leave these fields blank. All quantities in this table are updated in the base unit of measure of the material

    USNAM - User ID of the person filling out the table.

    CPUDT - Date of entry

    CPUTM - Time of entry

    Note: - This is to be done before J1I5, J2I5.

    Also refer link;

    [Update of Registers RG 1 and RG 23 (Part I)|http://help.sap.com/saphelp_erp60_sp/helpdata/en/1e/f4a1a011d811d4b5af006094b9ec21/content.htm]

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      You can use following code to load multiple entires into table J_2IRG1BAL.

      Take help of abaper to create this abap program in system.

       
        TABLES: 
        DATA : BEGIN OF IT_FILE  OCCURS 1, 
                      EXGRP  TYPE  J_2IRG1BAL-EXGRP, 
                      DATUM  TYPE  J_2IRG1BAL-DATUM, 
                      MATNR  TYPE  J_2IRG1BAL-MATNR,
                      FORM  TYPE  J_2IRG1BAL-FORM,   " P-Packed / L-Loose
                      WERKS  TYPE  J_2IRG1BAL-WERKS,
                      BALANCE TYPE J_2IRG1BAL-CB_FN_UOM,
                    END OF IT_FILE.
      
      * Upload data into from File into IT_RG1 table
        CALL FUNCTION 'GUI_UPLOAD'
               FILEPATH = P_FILEPATH
               FILETYPE = 'DAT'
            TABLES
                 DATA_TAB = IT_RG1.
      
      
        LOOP AT IT_RG1 INTO WA_RG1.
      
      J_2IRG1BAL-EXGRP = wa_rg1-exgrp. 
      J_2IRG1BAL-DATUM = wa_rg1- datum.
      J_2IRG1BAL-MATNR = wa_rg1-matnr.
      J_2IRG1BAL-FORM = wa_rg1-form.
      J_2IRG1BAL-WERKS = wa_rg1-werks.
      J_2IRG1BAL-CB_FN_UOM = wa_rg1-balance.
      J_2IRG1BAL-USNAM = sy-uname.
      J_2IRG1BAL-CPUDT = sy-datum.
      J_2IRG1BAL-CPUTM = sy-uzeit.
      insert j_2irg1bal.
      clear j_2irg1bal.
      
        ENDLOOP.
      
      

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 07:09 AM

    Resolved

    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.