SAP ABAP Table J_1IEXHEAD (Incoming Excise Invoice: CIN40A : Header Data)
Hierarchy
☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J1ICIN40A (Package) CIN40A developments
Basic Data
Table Category INTTAB    Structure 
Structure J_1IEXHEAD   Table Relationship Diagram
Short Description Incoming Excise Invoice: CIN40A : Header Data    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 TRNTYP J_1ITRNTYP J_1ITRNTYP CHAR 4   0   Excise Transaction Type *
2 DOCYR J_1IDOCUYR J_1IDOCUYR NUMC 4   0   Year  
3 DOCNO J_1IDOCNO J_1IDOCNO NUMC 10   0   Internal Excise Document Number *
4 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
5 WERKS WERKS_D WERKS CHAR 4   0   Plant *
6 EXGRP J_1IEXCGRP J_1IEXCGRP CHAR 2   0   Excise Group *
7 SRGRP J_1ISERGRP J_1ISERGRP CHAR 3   0   Excise Document Series Group *
8 STRTYP J_1ISTRTYP CHAR2 CHAR 2   0   Sub Transaction Type  
9 EXNUM J_1IEXCNUM J_1IEXCNUM CHAR 10   0   Official Excise Document Number  
10 OLD_EXNUM J_1IEXCNUM J_1IEXCNUM CHAR 10   0   Official Excise Document Number  
11 EXDAT J_1IEXCDAT J_1IEXCDAT DATS 8   0   Excise Document Date  
12 OLD_EXDAT J_1IEXCDAT J_1IEXCDAT DATS 8   0   Excise Document Date  
13 EXYEAR J_1IEXYEAR GJAHR NUMC 4   0   Excise Year  
14 REMTIME J_1IREMTIM UZEIT TIMS 6   0   Time of Removal  
15 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
16 OLD_LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
17 SHIPFROM J_1IEXSHIPFROM LIFNR CHAR 10   0   Ship-From Vendor *
18 RCWRK UMWRK WERKS CHAR 4   0   Receiving plant/issuing plant *
19 EXCUR J_1IEXCCUR WAERS CUKY 5   0   Currency *
20 EXBED J_1IEXCBED WERT7 CURR 13   2   Basic Excise Duty  
21 EXSED J_1IEXCSED WERT7 CURR 13   2   Special Excise Duty  
22 EXAED J_1IEXCAED WERT7 CURR 13   2   Additional Excise Duty  
23 SALES_TAX J_1INDTAX WERT7 CURR 13   2   Non-deductible tax value  
24 OTHERS J_1INDTAX WERT7 CURR 13   2   Non-deductible tax value  
25 CESS J_1IEXCESS WERT7 CURR 13   2   Cess amount  
26 REFDOC J_1IINTREF CHAR10 CHAR 10   0   Internal reference document  
27 RDOC J_1IRDOC1 CHAR10 CHAR 10   0   Reference Document 1  
28 RYEAR J_1IRYEAR1 CHAR4 CHAR 4   0   Reference year 1  
29 RIND J_1IRIND1 J_1IRIND CHAR 1   0   Reference Document Type 1  
30 KUNAG KUNAG KUNNR CHAR 10   0   Sold-to party *
31 KUNWE KUNWE KUNNR CHAR 10   0   Ship-to party *
32 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
33 EXCCD J_1IEXCD CHAR40 CHAR 40   0   ECC Number  
34 EXCRN J_1IEXRN CHAR40 CHAR 40   0   Excise Registration Number  
35 EXCRG J_1IEXRG CHAR60 CHAR 60   0   Excise Range  
36 EXCDI J_1IEXDI CHAR60 CHAR 60   0   Excise Division  
37 EXCCO J_1IEXCO CHAR60 CHAR 60   0   Excise Commissionerate  
38 CSTNO J_1ICSTNO CHAR40 CHAR 40   0   Central Sales Tax Number  
39 LSTNO J_1ILSTNO CHAR40 CHAR 40   0   Local Sales Tax Number  
40 PANNO J_1IPANNO CHAR40 CHAR 40   0   Permanent Account Number  
41 PREPRN J_1IPREPRN CHAR10 CHAR 10   0   Preprinted Serial Number  
42 RTDAT J_1IRTDAT DATS DATS 8   0   Return Date  
43 CVDIND J_1ICVDIND CHAR1_X CHAR 1   0   CVD indication  
44 EXPIND J_1IINDEXP J_1IINDEXP CHAR 1   0   Export Type  
45 STATUS J_1ISTATUS J_1ISTATUS CHAR 1   0   Excise Document Status  
46 CENSTAT J_1ICENST J_1ICENST CHAR 1   0   CENVAT Utilization status  
47 REJ_CODE J_1IREJCODE CHAR3 CHAR 3   0   Rejection Code J_1IREJMAS
48 MRPIND J_1IMRPIND CHAR1 CHAR 1   0   Maximum Retail Price  
49 USNAM J_1IUSNAM CHAR12 CHAR 12   0   Created By  
50 CPUDT J_1ICPUDT DATUM DATS 8   0   Excise Document Entry Date  
51 CPUTM CPUTM UZEIT TIMS 6   0   Time of data entry  
52 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
53 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
54 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
55 ADDLDATA1 J_1IADDATA CHAR60 CHAR 60   0   Additional Data  
56 ADDLDATA2 J_1IADDATA CHAR60 CHAR 60   0   Additional Data  
57 ADDLDATA3 J_1IADDATA CHAR60 CHAR 60   0   Additional Data  
58 ADDLDATA4 J_1IADDATA CHAR60 CHAR 60   0   Additional Data  
59 ADDLVAL J_1IADDVAL WERT9 CURR 17   2   Additional Value  
60 RULES J_2IRULE J_2IRULE CHAR 10   0   Rule/Section *
61 TOTAL_ITEMS J_1IEX_TOT_ITM NUMC4 NUMC 4   0   Number of Items in Excise Invoice  
62 TOTAL_QTY J_1IEX_TOT_QTY MENG13 QUAN 13   3   Total Quantity of All Items  
63 TOTAL_BED J_1IEX_TOT_AMT WERT7 CURR 13   2   Total Excise Duty  
64 TOTAL_AED J_1IEX_TOT_AMT WERT7 CURR 13   2   Total Excise Duty  
65 TOTAL_SED J_1IEX_TOT_AMT WERT7 CURR 13   2   Total Excise Duty  
66 TOT_SALES_TAX J_1INDTAX WERT7 CURR 13   2   Non-deductible tax value  
67 TOT_OTHERS J_1INDTAX WERT7 CURR 13   2   Non-deductible tax value  
68 LOGLEVEL J_1IEX_LOGLEVEL TEXT50 CHAR 50   0   Error status  
69 J_1IGRXREF J_1IGREX J_1IXREF CHAR 1   0   Number of Goods Receipts per Excise Invoice  
70 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
71 R_BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
72 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
73 REJ_ONHOLD J_1IEX_REJ_ONHOLD CHAR1 CHAR 1   0   Indicator for rejection onhold account  
74 REJ_VENDOR_PAY J_1IPAYVEN CHAR1 CHAR 1   0   Indicator whether Vendor payment should include excise am  
75 REJ_ACC_DOCNO J_1IFAWREF AWREF CHAR 10   0   Accounting Document  
76 REJ_ACC_DOCTYP J_1IFAWTYP AWTYP CHAR 5   0   Object type of calling application (FI) *
77 REJ_ACC_YEAR J_1IFAYEAR NUMC4 NUMC 4   0   Financial posting year  
78 TCODE TCODE TCODE CHAR 20   0   Transaction Code *
79 NO_OF_PART1     INT2 5   0    
80 NO_OF_PART2     INT2 5   0    
81 PART1_FROM J_1ISRLNO1 NUMC10 NUMC 10   0   Register Entry Serial Number  
82 PART1_TO J_1ISRLNO1 NUMC10 NUMC 10   0   Register Entry Serial Number  
83 PART2_FROM J_1ISRLNO1 NUMC10 NUMC 10   0   Register Entry Serial Number  
84 PART2_TO J_1ISRLNO1 NUMC10 NUMC 10   0   Register Entry Serial Number  
85 NO_OF_CANCEL     INT1 3   0    
86 REV_ACC_DOCNO J_1IFAWREF AWREF CHAR 10   0   Accounting Document  
87 EXCISE_ACTION J_1IEXCISE_ACTION J_1IEXCISE_ACTION CHAR 2   0   Excise Action  
88 PLANT_IND     CHAR 1   0    
89 DEPOT_IND     CHAR 1   0    
90 EXCISE_IND     CHAR 1   0    
91 SUBCON_IND     CHAR 1   0    
92 BONDNO J_1IBONDNO J_1IBONDNO NUMC 10   0   Internal Bond Number  
93 BONDTYP J_1IBONDTYP J_1IBONDTYP CHAR 4   0   Bond Type  
94 BONDYR J_1IBONDYR GJAHR NUMC 4   0   Fiscal Year  
95 BONDAMT J_1IBOAMT WERT7 CURR 13   2   Bond Value  
96 BONDCURBAL J_1IBOCURBAL WERT7 CURR 13   2   Bond Balance  
97 BOAMTBAL J_1IBOCURBAL WERT7 CURR 13   2   Bond Balance  
98 BOND_RESERV_AMT J_1IBORESERV WERT7 CURR 13   2   Reservation Amount  
99 BONDNOEX J_1IBONDNOEX CHAR60 CHAR 60   0   Official Bond Number  
100 BONDSTATUS J_1IBOSTATUS J_1IBOSTATUS CHAR 1   0   Bond Status  
101 BONDEXPDT J_1IBOEXPDT DATUM DATS 8   0   Expiry Date  
102 TOTAL_EXCINV J_1IEX_TOT_EXC NUMC4 NUMC 4   0   Excise Bonding: Total number of excise invoices  
103 PRECUSDAT J_1IPRECUSDAT DATUM DATS 8   0   Arrived at Customs  
104 ACKCUSDAT J_1IACKCUSDAT DATUM DATS 8   0   Countersigned  
105 RECPTDAT J_1IRECPTDAT DATS DATS 8   0   Arrived Back  
106 EXCSUBDAT J_1IEXCSUBDAT DATUM DATS 8   0   Sent to Excise Department  
107 POEXPDAT J_1IPOEXPDAT DATUM DATS 8   0   Export Confirmed  
108 AMENDIND     CHAR 1   0    
109 AMENDED_BALANCE J_1IAMD_BAL WERT7 CURR 13   2   BED After Amendment  
110 AMENDED_ON J_1IAMD_DAT DATS DATS 8   0   Exc Bonding: Date of Amendment  
111 ADDN_EXNUM J_1IEXCNUM J_1IEXCNUM CHAR 10   0   Official Excise Document Number  
112 ADDN_EXYEAR J_1IEXYEAR GJAHR NUMC 4   0   Excise Year  
113 PRINT_ARE J_1IPRINT_ARE CHAR1 CHAR 1   0   Print ARE Document  
114 EXC_ADDRESS_NO J_1IADDR_NO NUM3 NUMC 3   0   Address  
115 EXC_ADDR_DESCP J_1IADDR_DESC J_1ICHAR40LOW CHAR 40   0   Excise Address Description  
116 CUS_ADDRESS_NO J_1IADDR_NO NUM3 NUMC 3   0   Address  
117 CUS_ADDR_DESCP J_1IADDR_DESC J_1ICHAR40LOW CHAR 40   0   Excise Address Description  
118 EXPORT_PRD_EXCEED     CHAR 1   0    
119 RG23ABEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
120 RG23CBEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
121 PLABEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
122 IRG23ABEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
123 IRG23CBEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
124 IPLABEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
125 TOTAL_UTIL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
126 AUTO_RECON     CHAR 1   0    
127 NCCD J_1IEXCNCCD WERT7 CURR 13   2   National Calamity Contingency Duty  
128 TOTAL_NCCD J_1IEX_TOT_AMT WERT7 CURR 13   2   Total Excise Duty  
129 ECS J_1IEXECS WERT7 CURR 13   2   ECS Value  
130 TOTAL_ECS J_1IEX_TOT_AMT WERT7 CURR 13   2   Total Excise Duty  
131 EXADDTAX1 J_1IEXADDTAX1 WERT7 CURR 13   2   Additional Tax1 value  
132 TOTAL_AT1 J_1IEX_TOT_AMT WERT7 CURR 13   2   Total Excise Duty  
133 EXADDTAX2 J_1IEXADDTAX2 WERT7 CURR 13   2   Additional Tax2 value  
134 TOTAL_AT2 J_1IEX_TOT_AMT WERT7 CURR 13   2   Total Excise Duty  
135 EXADDTAX3 J_1IEXADDTAX3 WERT7 CURR 13   2   Additional Tax3 value  
136 TOTAL_AT3 J_1IEX_TOT_AMT WERT7 CURR 13   2   Total Excise Duty  
137 RG23AAEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
138 RG23CAEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
139 PLAAEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
140 IRG23AAEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
141 IRG23CAEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
142 IPLAAEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
143 RG23ASEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
144 RG23CSEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
145 PLASEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
146 IRG23ASEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
147 IRG23CSEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
148 IPLASEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
149 RG23ANCCDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
150 RG23CNCCDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
151 PLANCCDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
152 IRG23ANCCDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
153 IRG23CNCCDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
154 IPLANCCDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
155 RG23AECSBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
156 RG23CECSBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
157 PLAECSBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
158 IRG23AECSBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
159 IRG23CECSBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
160 IPLAECSBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
161 RG23AAT1BAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
162 RG23CAT1BAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
163 PLAAT1BAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
164 IRG23AAT1BAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
165 IRG23CAT1BAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
166 IPLAAT1BAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
167 ISTBEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
168 ISTAEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
169 ISTSEDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
170 ISTNCCDBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
171 ISTECSBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
172 ISTAT1BAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
173 IECSSTECSBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
174 IAT1STAT1BAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
175 STBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
176 STECSBAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
177 STAT1BAL J_1IBEDBAL WERT7 CURR 13   2   Excise Bonding: BED balance RG23A/C  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 J_1IEXHEAD GSBER TGSB GSBER    
2 J_1IEXHEAD LIFNR LFA1 LIFNR    
3 J_1IEXHEAD REJ_CODE J_1IREJMAS REJ_CODE    
History
Last changed by/on SAP  20130529 
SAP Release Created in 40A