J_1IER1 SAP ABAP Report - Monthly Return of Excisable Goods and Availment of CENVAT Credit
J_1IER1 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.
If you would like to execute this report or see the full code listing simply enter J_1IER1 into the relevant SAP transactions such as SE38 or SE80
Transaction Code(s):
Below is a list of transaction codes which are relevant to this SAP report
J2IER1 - Monthly er1 report
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT J_1IER1. "Basic submit
SUBMIT J_1IER1 AND RETURN. "Return to original report after report execution complete
SUBMIT J_1IER1 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Selection Text: P_WERKS = Plant
Selection Text: P_UTDAT = Last Utilization Period
Selection Text: P_FILE = Export to XML
Selection Text: P_EXGRP = Excise group
Selection Text: P_BUDAT = Report Period
Title: Monthly Return of Excisable Goods and Availment of CENVAT Credit
Text Symbol: 182 = to
Text Symbol: 183 = and transfer challan under rule 12A of the CENVAT Credit Rule, 2004 bearing S. No
Text Symbol: 184 = were issued.
Text Symbol: 185 = 4. Clearance details of inter unit transfer of intermediate goods without payment of duty under sub-rule(1)of rule 12BB
Text Symbol: 186 = Registration
Text Symbol: 187 = Name and
Text Symbol: 188 = number of the
Text Symbol: 189 = address of the
Text Symbol: 190 = goods sent
Text Symbol: 191 = cleared
Text Symbol: 192 = recepient unit
Text Symbol: 193 = recepient premises
Text Symbol: 194 = Clearance details of goods transfer without payment of duty under rule 12BB
Text Symbol: 195 = 5. Receipt details of intermediate goods received from other premises under sub-rule(1)of rule 12BB.-
Text Symbol: 196 = sender premises
Text Symbol: 197 = goods received
Text Symbol: 198 = received
Text Symbol: 199 = 8. Abstract of ACCOUNT-CURRENT (Cash payment).-
Text Symbol: 200 = Summary particulars
Text Symbol: 201 = Amount in Rs.
Text Symbol: 202 = Add: TR-6/ GAR-7 Challan payments made in the
Text Symbol: 203 = month (in aggregate)
Text Symbol: 204 = Add*:Adjustment of the excess duty paid during previous
Text Symbol: 205 = period under subrule (2) of rule 12BB (incase of LT)
Text Symbol: 206 = Total amount available
Text Symbol: 207 = Less: Utilization towards Payment of duties on excisable
Text Symbol: 156 = 10.Self- assessment memorandum
Text Symbol: 157 = a)I hereby declare that the information given in this Return is true, correct and
Text Symbol: 158 = complete in every respect and that I am authorised to sign on behalf of the assessee.
Text Symbol: 159 = b)During the month, total Rs.
Text Symbol: 160 = was deposited vide TR 6 Challans(copies enclosed)
Text Symbol: 161 = c)During the month, invoices bearing S.No
Text Symbol: 162 = to S.No.
Text Symbol: 163 = were issued.
Text Symbol: 164 = Name and signature of Assessee or
Text Symbol: 165 = Authorised Signatory
Text Symbol: 166 = ACKNOWLEDGEMENT
Text Symbol: 167 = Return of excisable goods and availment of CENVAT credit for the month of
Text Symbol: 168 = Date of receipt
Text Symbol: 169 = Name and Signature of the Range Officer with Official Seal
Text Symbol: 170 = Utilization Period
Text Symbol: 171 = Service Tax account details
Text Symbol: 172 = Large Taxpayer Unit opted for (name of the city)
Text Symbol: 173 = ADC
Text Symbol: 174 = on imported inputs
Text Symbol: 175 = from inter-unit
Text Symbol: 176 = transfer of credit
Text Symbol: 177 = by a large taxpayer
Text Symbol: 178 = under sub-rule(2) of
Text Symbol: 179 = rule 12BB of Central
Text Symbol: 180 = Excise Rules, 2002
Text Symbol: 181 = d) During the month, transfer challans under rule 12BB of the Central Excise Rules, 2002 bearing S. No
Text Symbol: 239 = Other Interest
Text Symbol: 240 = Payments
Text Symbol: 241 = Misc. payments
Text Symbol: 242 = for other payment
Text Symbol: 243 = when inputs are
Text Symbol: 244 = when capital goods
Text Symbol: 245 = are removed as such
Text Symbol: 246 =
Text Symbol: 247 =
Text Symbol: 248 = Details
Text Symbol: 249 = Export
Text Symbol: 250 = Under
Text Symbol: 251 = Bond
Text Symbol: 252 = amount in terms
Text Symbol: 253 = of Rule 6 of
Text Symbol: 254 = CENVAT Credit
Text Symbol: 255 = Rules, 2004
Text Symbol: 256 = Output Format
Text Symbol: 257 = XML
Text Symbol: 258 = Export to XML
Text Symbol: 259 = Credit taken from
Text Symbol: 260 = inter-unit transfer
Text Symbol: 261 = of credit under rule
Text Symbol: 262 = 10A of CENVAT Credit
Text Symbol: 263 = Rules, 2004
Text Symbol: 264 = Credit utilised towards
Text Symbol: 208 = goods during the month (vide. Details furnished under
Text Symbol: 209 = col.no.3 in Sl.No.(6) of the Return)
Text Symbol: 210 = Less Utilization towards Other Payments made during the
Text Symbol: 211 = month (vide. Details furnished under Sl.No.(9) of the Return)
Text Symbol: 212 = Details of intermediate goods received from other premises under rule 12BB.
Text Symbol: 213 = Abstract of ACCOUNT-CURRENT (Cash payment)
Text Symbol: 214 = Duty(adv)
Text Symbol: 215 = Duty(specific)
Text Symbol: 216 = on imported
Text Symbol: 217 = capital goods
Text Symbol: 218 = SECess on
Text Symbol: 219 = 9. Details of other payments made :
Text Symbol: 220 = Payments
Text Symbol: 221 = Amount paid (Rs.)
Text Symbol: 222 = Source Document
Text Symbol: 223 = Current
Text Symbol: 224 = Credit
Text Symbol: 230 = Total
Text Symbol: 231 = Account
Text Symbol: 232 = Arrears of duty
Text Symbol: 233 = under Rule 8
Text Symbol: 234 = Other arrears
Text Symbol: 235 = of duty
Text Symbol: 236 = Interest
Text Symbol: 237 = payment under
Text Symbol: 238 = Rule 8
Text Symbol: 155 = Self- assessment memorandum
Text Symbol: 030 = Opening
Text Symbol: 031 = Value of goods
Text Symbol: 032 = Type of
Text Symbol: 033 = Quantity cleared
Text Symbol: 034 = clearance
Text Symbol: 035 = cleared
Text Symbol: 036 = Unit
Text Symbol: 037 = CENVAT Credit
Text Symbol: 038 = Interest
Text Symbol: 039 = Duty
Text Symbol: 040 = Total
Text Symbol: 041 = Others
Text Symbol: 042 = Code
Text Symbol: 043 = Challan
Text Symbol: 044 = Mode of
Text Symbol: 045 = paid(Rs)
Text Symbol: 046 = 6. Details of duty paid on excisable goods:
Text Symbol: 047 = Credit
Text Symbol: 048 = Removed
Text Symbol: 049 = Assessable
Text Symbol: 050 = Total duty
Text Symbol: 051 = Quantity
Text Symbol: 052 = Unit of
Text Symbol: 053 = Description of
Text Symbol: 054 = CETSH NO
Text Symbol: 055 = No.
Text Symbol: 056 = Date
Text Symbol: 029 = Description
Text Symbol: 001 = Details
Text Symbol: 002 = Details of manufacture, clearance and duty payable
Text Symbol: 004 = Details of CENVAT credit availed and utilized
Text Symbol: 005 = Details of other payments made
Text Symbol: 006 = Details of duty paid on excisable goods
Text Symbol: 007 = Select
Text Symbol: 008 = Display headings
Text Symbol: 009 = No details found
Text Symbol: 010 = No duty payment details found
Text Symbol: 011 = No removal details found
Text Symbol: 012 = Address:
Text Symbol: 013 = 1. Registration No :
Text Symbol: 014 = 2. Name of Assessee:
Text Symbol: 015 = G.S.R. (E). - In exercise of the powers conferred by rule 12 of the Central Excise Rule
Text Symbol: 016 = 2002 and sub-rule (7) of rule 9 of CENVAT Credit Rules, 2004, and in super session of the
Text Symbol: 017 = notification of the Government of India, Ministry of Finance (Department of Revenue), No.26/
Text Symbol: 018 = 2005-Central Excise (N.T.), dated the 16th May, 2005 published vide G.S.R.313 (E),
Text Symbol: 019 = dated the 16th May, 2005, the Central Board of Excise and Customs hereby specifies the
Text Symbol: 020 = following forms for the purposes of the said rules, namely:-
Text Symbol: 021 = CBEC notifies new ER-1 and ER-3 forms
Text Symbol: 022 = Notifications No.23/2006
Text Symbol: 023 = Law : Tax - Indirect
Text Symbol: 024 = Category : Central Excise Non-Tariff
Text Symbol: 025 = Manufactured
Text Symbol: 026 = Balance
Text Symbol: 027 = Closing
Text Symbol: 028 = Quantity removed
Text Symbol: 128 = ADE
Text Symbol: 129 = ECS on
Text Symbol: 130 = Service Tax
Text Symbol: 131 = excisable goods
Text Symbol: 132 = taxable services
Text Symbol: 133 = Opening balance
Text Symbol: 134 = Credit availed
Text Symbol: 135 = on inputs on
Text Symbol: 136 = invoices issued by
Text Symbol: 137 = manufacturers
Text Symbol: 138 = 1 or 2 stage dealer
Text Symbol: 139 = on capital goods
Text Symbol: 140 = on input services
Text Symbol: 141 = Total credit availed
Text Symbol: 142 = Credit utilized
Text Symbol: 143 = for payment of
Text Symbol: 144 = duty on goods
Text Symbol: 145 = when inputs or
Text Symbol: 146 = capital goods are
Text Symbol: 147 = removed as such
Text Symbol: 148 = for payment of
Text Symbol: 149 = duty on services
Text Symbol: 150 = Closing balance
Text Symbol: 151 = Duties are already paid so suty payable equal to duty paid.
Text Symbol: 152 = Confirm
Text Symbol: 153 = Do you want to continue with the report?
Text Symbol: 154 = Duties are not yet paid for this period.
Text Symbol: 127 = NCCD
Text Symbol: 057 = Value
Text Symbol: 100 = 4. DETAILS OF EXCISABLE GOODS MANUFACTURED, FOR THE MONTH/QUARTER
Text Symbol: 101 = 8. DETAILS OF GOODS CLEARED WITHOUT PAYMENT OF DUTY OR UNDER FULL EXEMPTION OR AT
Text Symbol: 102 = NIL
Text Symbol: 103 = Rate of
Text Symbol: 104 = DETAILS OF REMOVALS OF ALL EXCISABLE GOODS ON WHICH DUTY IS PAYABLE IN THE SECOND FORTNIGHT OF MONTH/SECOND MONTH OF QUARTER
Text Symbol: 105 = 3. Details of the manufacture, clearance and duty payable:
Text Symbol: 107 = Excise group
Text Symbol: 108 = (A) for monthly return for production and removal of goods and other relevant particulars and
Text Symbol: 109 = CENVAT credit, the following form shall be used, namely:-
Text Symbol: 110 = [See rule 12 of the Central Excise Rules, 2002 and rule 9 (7) of CENVAT Credit Rules, 2004]
Text Symbol: 111 = Return of excisable goods and availment of CENVAT credit for the month of
Text Symbol: 112 = Notification
Text Symbol: 113 = Serial No. in
Text Symbol: 114 = Provisional
Text Symbol: 115 = goods
Text Symbol: 116 = availed
Text Symbol: 117 = Payable
Text Symbol: 118 = assessment number
Text Symbol: 119 = Account
Text Symbol: 120 = BSR
Text Symbol: 121 = Current(Rs)
Text Symbol: 122 = Account(Rs)
Text Symbol: 123 = 7. Details of CENVAT credit availed and utilized:
Text Symbol: 124 = Details of
Text Symbol: 125 = CENVAT
Text Symbol: 126 = AED(TTA)
INCLUDES used within this REPORT J_1IER1
INCLUDE J_1IER1TOP.
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
J_1I7_USEREXIT_UPDATE_DETAIL CALL FUNCTION 'J_1I7_USEREXIT_UPDATE_DETAIL' EXPORTING utdate_low = p_utdat-low utdate_high = p_utdat-high rptdate_low = g_p_fdate rptdate_high = g_p_edate TABLES itab_header = gt_header itab_detail = gt_detail itab_detail_paid = gs_detail_paid itab_rg1 = gt_rg1 itab_extrct = gt_extrct. "#EC ARGCHECKED
J_1I7_USEREXIT_UPDATE_DETAIL CALL FUNCTION 'J_1I7_USEREXIT_UPDATE_DETAIL' EXPORTING utdate_low = p_utdat-low utdate_high = p_utdat-high rptdate_low = g_p_fdate rptdate_high = g_p_edate TABLES itab_header = gt_header itab_detail = gt_detail itab_detail_paid = gs_detail_paid itab_rg1 = gt_rg1 itab_extrct = gt_extrct. "#EC ARGCHECKED
J_1I_DETERMINE_SER_ACCOUNT CALL FUNCTION 'J_1I_DETERMINE_SER_ACCOUNT' EXPORTING bukrs = lv_bukrs werks = p_werks TABLES seracc = gt_sertax.
J_1I7_USEREXIT_CAL_BALANCE CALL FUNCTION 'J_1I7_USEREXIT_CAL_BALANCE' EXPORTING open_bal_aed = g_open_bal_aedt cr_aed = g_cr_aedt cr_cap_aed = g_cr_cap_aedt util_rm_aed = g_util_rm_aedt util_aed = g_util_aedt open_ade = g_open_bal_ade credit_ade = g_cr_ade credit_cap_ade = g_cr_cap_ade util_re_ade = g_util_rm_ade utilised_ade = g_util_ade IMPORTING open_bal_aedt = g_open_bal_aedt cr_aedt = g_cr_aedt cr_cap_aedt = g_cr_cap_aedt util_rm_aedt = g_util_rm_aedt util_aedt = g_util_aedt open_bal_ade = g_open_bal_ade cr_ade = g_cr_ade cr_cap_ade = g_cr_cap_ade util_rm_ade = g_util_rm_ade util_ade = g_util_ade TABLES excacc = gt_excacc itab_header_availed = gt_header_availed itab_part2_immd = gt_part2_immd itab_header = gt_header itab_part2_mont = gt_part2_mont.
J_1I6_DETERMINE_ACCOUNT CALL FUNCTION 'J_1I6_DETERMINE_ACCOUNT' EXPORTING bukrs = g_company_code werks = p_werks excgrp = p_exgrp trntyp = p_trntyp indicator = p_indicator strtyp = adcindicator TABLES excacc = p_excacc EXCEPTIONS OTHERS = 1.
J_1I6_DETERMINE_ACCOUNT CALL FUNCTION 'J_1I6_DETERMINE_ACCOUNT' EXPORTING bukrs = g_company_code werks = p_werks excgrp = p_exgrp trntyp = p_trntyp indicator = p_indicator TABLES excacc = p_excacc EXCEPTIONS OTHERS = 1.
J_1I6_CALCULATE_MONTHLY_BAL CALL FUNCTION 'J_1I6_CALCULATE_MONTHLY_BAL' EXPORTING bukrs = g_company_code werks = p_werks excgrp = p_exgrp i_budat = v_budat TABLES accbal = gt_excacc EXCEPTIONS excise_acc_notfound = 1.
J_1I6_CALCULATE_MONTHLY_BAL CALL FUNCTION 'J_1I6_CALCULATE_MONTHLY_BAL' EXPORTING bukrs = g_company_code werks = p_werks excgrp = p_exgrp i_budat = g_p_edate TABLES accbal = gt_acc EXCEPTIONS excise_acc_notfound = 1.
POPUP_TO_CONFIRM_LOSS_OF_DATA CALL FUNCTION 'POPUP_TO_CONFIRM_LOSS_OF_DATA' EXPORTING textline1 = text-154 textline2 = text-153 titel = text-152 start_column = 25 start_row = 6 IMPORTING answer = get_answer EXCEPTIONS OTHERS = 1.
POPUP_TO_CONFIRM_LOSS_OF_DATA CALL FUNCTION 'POPUP_TO_CONFIRM_LOSS_OF_DATA' EXPORTING textline1 = text-151 textline2 = text-153 titel = text-152 start_column = 25 start_row = 6 IMPORTING answer = get_answer EXCEPTIONS OTHERS = 1.
J_1I7_USEREXIT_UPDATE_CHALLAN CALL FUNCTION 'J_1I7_USEREXIT_UPDATE_CHALLAN' EXPORTING excise_group = p_exgrp werks = p_werks report_fdate = g_p_fdate report_tdate = g_p_edate util_fdate = p_utdat-low util_tdate = p_utdat-high TABLES itab_header = gt_header itab_part2 = gt_part2 itab_part2_paid = gs_part2_paid itab_part2_challan = gt_part2_challan itab_header_mont = gt_header_mont.
J_1I6_CALCULATE_DAILY_BAL * call function 'J_1I6_CALCULATE_DAILY_BAL' * EXPORTING * bukrs = g_company_code * werks = p_werks * excgrp = p_exgrp * i_budat = p_budat-low * t_budat = p_budat-high * TABLES * accbal = gt_excacc * EXCEPTIONS * excise_acc_notfound = 1 * others = 2.
J_1I6_CALCULATE_MONTHLY_BAL CALL FUNCTION 'J_1I6_CALCULATE_MONTHLY_BAL' EXPORTING bukrs = g_company_code werks = p_werks excgrp = p_exgrp i_budat = t_utdat TABLES accbal = gt_excacc EXCEPTIONS excise_acc_notfound = 1.
J_1I7_USEREXIT_UPDATE_CHALLAN CALL FUNCTION 'J_1I7_USEREXIT_UPDATE_CHALLAN' EXPORTING excise_group = p_exgrp werks = p_werks report_fdate = g_p_fdate report_tdate = g_p_edate util_fdate = p_utdat-low util_tdate = p_utdat-high TABLES itab_header = gt_header itab_part2 = gt_part2 itab_part2_paid = gs_part2_paid itab_part2_challan = gt_part2_challan itab_header_mont = gt_header_mont.
HR_KR_XSTRING_TO_STRING CALL FUNCTION 'HR_KR_XSTRING_TO_STRING' EXPORTING in_xstring = xml_clearancex IMPORTING out_string = xml_clearances.
HR_KR_XSTRING_TO_STRING CALL FUNCTION 'HR_KR_XSTRING_TO_STRING' EXPORTING in_xstring = xml_notifx IMPORTING out_string = xml_notift.
HR_KR_XSTRING_TO_STRING CALL FUNCTION 'HR_KR_XSTRING_TO_STRING' EXPORTING in_xstring = xml_dutypayablex IMPORTING out_string = xml_dutypayablest.
HR_KR_XSTRING_TO_STRING CALL FUNCTION 'HR_KR_XSTRING_TO_STRING' EXPORTING in_xstring = g_xml_outputx IMPORTING out_string = g_xml_outputs.
GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING * BIN_FILESIZE = filename = p_file filetype = 'ASC' * APPEND = ' ' * WRITE_FIELD_SEPARATOR = ' ' * HEADER = '00' * TRUNC_TRAILING_BLANKS = ' ' * WRITE_LF = 'X' * COL_SELECT = ' ' * COL_SELECT_MASK = ' ' * DAT_MODE = ' ' * CONFIRM_OVERWRITE = ' ' * NO_AUTH_CHECK = ' ' * CODEPAGE = ' ' * IGNORE_CERR = ABAP_TRUE * REPLACEMENT = '#' * WRITE_BOM = ' ' * TRUNC_TRAILING_BLANKS_EOL = 'X' * WK1_N_FORMAT = ' ' * WK1_N_SIZE = ' ' * WK1_T_FORMAT = ' ' * WK1_T_SIZE = ' ' * WRITE_LF_AFTER_LAST_LINE = ABAP_TRUE * SHOW_TRANSFER_STATUS = ABAP_TRUE * IMPORTING * FILELENGTH = TABLES data_tab = lt_erfiling * FIELDNAMES = * EXCEPTIONS * FILE_WRITE_ERROR = 1 * NO_BATCH = 2 * GUI_REFUSE_FILETRANSFER = 3 * INVALID_TYPE = 4 * NO_AUTHORITY = 5 * UNKNOWN_ERROR = 6 * HEADER_NOT_ALLOWED = 7 * SEPARATOR_NOT_ALLOWED = 8 * FILESIZE_NOT_ALLOWED = 9 * HEADER_TOO_LONG = 10 * DP_ERROR_CREATE = 11 * DP_ERROR_SEND = 12 * DP_ERROR_WRITE = 13 * UNKNOWN_DP_ERROR = 14 * ACCESS_DENIED = 15 * DP_OUT_OF_MEMORY = 16 * DISK_FULL = 17 * DP_TIMEOUT = 18 * FILE_NOT_FOUND = 19 * DATAPROVIDER_EXCEPTION = 20 * CONTROL_FLUSH_ERROR = 21 * OTHERS = 22 .
IDWT_READ_MONTH_TEXT CALL FUNCTION 'IDWT_READ_MONTH_TEXT' EXPORTING langu = lv_langu month = lv_month IMPORTING t247 = lv_t247.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name J_1IER1 or its description.
J_1IER1 - Monthly Return of Excisable Goods and Availment of CENVAT Credit J_1IER1 - Monthly Return of Excisable Goods and Availment of CENVAT Credit J_1IEIOT - OTHR SAPSCRIPT DRIVING PROGRAM J_1IEIOT - OTHR SAPSCRIPT DRIVING PROGRAM J_1IDOCLIST - List of Subcontracting Challans J_1IDOCLIST - List of Subcontracting Challans