cancel
Showing results for 
Search instead for 
Did you mean: 

Addition of Columns in RG23D Excise Register

Former Member
0 Kudos

Hi,

In Excise Register Print (in Excel) of RG23D at depot through J2I6, we need to add few columns such as Material Code, Excise Registration (ECC) No. & Address (Excise Commissionerate) of Receiving Plant.

Can any one assist in getting the required information in RG23D Register?

Thanks in advance

Accepted Solutions (0)

Answers (1)

Answers (1)

kailas_ugale
Active Contributor
0 Kudos

Hi

check following table it will be helpful in t-code SE16

table-J_1IMTCHID

J_1IRG23D

J_1IEXCDTL

Regards

Kailas Ugale

Edited by: kailasugale on Oct 20, 2011 8:09 PM

Former Member
0 Kudos

Thanks Kailas for the instant reply. But I need clarification on the following points:

1. From the tables (J_1IMTCHID, J_1IRG23D, J_1IEXCDTL), the Customer information and its Excise Details (ECC No., Excise Regn No. & Excise Commissionerate) can not be obtained

2. Is it possible to modify directly the RG23D Excise Register (Excel Format) coming through J2I6 in standard SAP so that we can get the desired information from J2I6 itself directly?

It would be great if some one assist here with the clarification required

Thanks in advance

kailas_ugale
Active Contributor
0 Kudos

Hi

I did same and we can add additional column in J2I6 in exiles for that your required good abap consultant

not only in RG23D,but in RG23A and C also we can do

1) Name & Address of Supplier/Buyer :

J_1IRG23D u2013 LIFNR = LFA1 u2013 LIFNR

2) Excise Details of Supplier :

table-J_1IMOVEND

u2022 RANGE : J_1IMOVEND - J_1IEXCRG

u2022 DIVISION : J_1IMOVEND - J_1IEXDI

u2022 COMMISSIONERATE : J_1IMOVEND - J_1IEXCO

u2022 ECC NO : J_1IMOVEND - J_1IEXCD

3) RG23D Register No : J_1IRG23D u2013 FOLIO

4) Purchaseu2013 Material & Excise Details

u2022 Description of Goods : J_1IRG23D u2013MAKTX

u2022 Pkt. Quantity : J_1IRG23D - MENGE (Qty) & J_1IRG23D u2013 MEINS

u2022 Rate : J_1IRG23D-EXBAS /J_1IRG23D- MENGE ( VALUE In Rs / Qty)

u2022 Tariff No. : J_1IRG23D u2013 CHAPID

Regards

Kailas Ugale

Edited by: kailasugale on Oct 21, 2011 12:35 PM