SAP ABAP Table J_1IEXDTL (Structure for mother Excise Invoice fetch)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷
FI-LOC (Application Component) Localization
⤷
J1I2 (Package) India, Phase II

⤷

⤷

Basic Data
Table Category | INTTAB | Structure |
Structure | J_1IEXDTL |
![]() |
Short Description | Structure for mother Excise Invoice fetch |
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 | ![]() |
MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | ![]() |
J_1ITRNTYP | J_1ITRNTYP | CHAR | 4 | 0 | Excise Transaction Type | * | |
3 | ![]() |
J_1IDOCUYR | J_1IDOCUYR | NUMC | 4 | 0 | Year | ||
4 | ![]() |
J_1IDOCNO | J_1IDOCNO | NUMC | 10 | 0 | Internal Excise Document Number | * | |
5 | ![]() |
J_1IZEILE | J_1IZEILE | NUMC | 4 | 0 | Item Number | ||
6 | ![]() |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
7 | ![]() |
J_1IEXCNUM | J_1IEXCNUM | CHAR | 10 | 0 | Official Excise Document Number | ||
8 | ![]() |
J_1IEXCDAT | J_1IEXCDAT | DATS | 8 | 0 | Excise Document Date | ||
9 | ![]() |
J_1IEXYEAR | GJAHR | NUMC | 4 | 0 | Excise Year | ||
10 | ![]() |
J_1IEXCGRP | J_1IEXCGRP | CHAR | 2 | 0 | Excise Group | * | |
11 | ![]() |
J_1ILIFNR | J_1ILIFNR | CHAR | 10 | 0 | Vendor | ||
12 | ![]() |
LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
13 | ![]() |
UMWRK | WERKS | CHAR | 4 | 0 | Receiving plant/issuing plant | * | |
14 | ![]() |
GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
15 | ![]() |
LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
16 | ![]() |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
17 | ![]() |
MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
18 | ![]() |
CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
19 | ![]() |
J_1ICHID | CHAR12 | CHAR | 12 | 0 | Chapter ID | ||
20 | ![]() |
J_1IMENGE | MENG13 | QUAN | 13 | 3 | Quantity mentioned in the excise invoice | ||
21 | ![]() |
J_1IMENGA | MENG13 | QUAN | 13 | 3 | Quantity of Goods Received | ||
22 | ![]() |
J_1IMENGC | MENG13 | QUAN | 13 | 3 | Quantity on Which CENVAT Credit Is Taken | ||
23 | ![]() |
J_1IMENGR | MENG13 | QUAN | 13 | 3 | Quantity remaining in the depot | ||
24 | ![]() |
J_1ISCPGN | MENG13 | QUAN | 13 | 3 | Quantity of Scrap generated | ||
25 | ![]() |
J_1IMEINS | MEINS | UNIT | 3 | 0 | Unit of Measure | * | |
26 | ![]() |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
27 | ![]() |
J_1IEXCCUR | WAERS | CUKY | 5 | 0 | Currency | * | |
28 | ![]() |
J_1IEXCBAS | WERT7 | CURR | 13 | 2 | Excise Duty Base Amount | ||
29 | ![]() |
J_1IEXCBED | WERT7 | CURR | 13 | 2 | Basic Excise Duty | ||
30 | ![]() |
J_1IEXCSED | WERT7 | CURR | 13 | 2 | Special Excise Duty | ||
31 | ![]() |
J_1IEXCAED | WERT7 | CURR | 13 | 2 | Additional Excise Duty | ||
32 | ![]() |
J_1IEXCESS | WERT7 | CURR | 13 | 2 | Cess amount | ||
33 | ![]() |
J_1IBEDINV | WERT7 | CURR | 13 | 2 | Inventorized BED | ||
34 | ![]() |
J_1IAEDINV | WERT7 | CURR | 13 | 2 | Inventorized AED | ||
35 | ![]() |
J_1ISEDINV | WERT7 | CURR | 13 | 2 | Inventorized SED | ||
36 | ![]() |
J_1IADDBED | WERT7 | CURR | 13 | 2 | Additional BED | ||
37 | ![]() |
J_1IADDSED | WERT7 | CURR | 13 | 2 | Additional SED | ||
38 | ![]() |
J_1IADDAED | WERT7 | CURR | 13 | 2 | Additional AED | ||
39 | ![]() |
J_1INDTAX | WERT7 | CURR | 13 | 2 | Non-deductible tax value | ||
40 | ![]() |
J_1IYEAR | NUMC4 | NUMC | 4 | 0 | Year of Register Entry | ||
41 | ![]() |
J_1I23ASER | NUMC10 | NUMC | 10 | 0 | RG23A serial no. | ||
42 | ![]() |
J_1I23CSER | NUMC10 | NUMC | 10 | 0 | RG23C serial no. | ||
43 | ![]() |
J_1IPLASER | NUMC10 | NUMC | 10 | 0 | PLA serial no. | ||
44 | ![]() |
J_1IYEAR | NUMC4 | NUMC | 4 | 0 | Year of Register Entry | ||
45 | ![]() |
J_1ISRLNO1 | NUMC10 | NUMC | 10 | 0 | Register Entry Serial Number | ||
46 | ![]() |
J_1IRDOC1 | CHAR10 | CHAR | 10 | 0 | Reference Document 1 | ||
47 | ![]() |
J_1IRYEAR1 | CHAR4 | CHAR | 4 | 0 | Reference year 1 | ||
48 | ![]() |
J_1IRITEM1 | NUMC6 | NUMC | 6 | 0 | Reference Item 1 | ||
49 | ![]() |
J_1IRIND1 | J_1IRIND | CHAR | 1 | 0 | Reference Document Type 1 | ||
50 | ![]() |
J_1IRDOC2 | CHAR10 | CHAR | 10 | 0 | Reference Document 2 | ||
51 | ![]() |
J_1IRYEAR2 | CHAR4 | CHAR | 4 | 0 | Reference year 2 | ||
52 | ![]() |
J_1IRITEM2 | NUMC6 | NUMC | 6 | 0 | Reference Item 2 | ||
53 | ![]() |
J_1IRIND2 | J_1IRIND | CHAR | 1 | 0 | Reference Document Type 2 | ||
54 | ![]() |
J_1IRDOC3 | CHAR40 | CHAR | 40 | 0 | Reference Document 3 | ||
55 | ![]() |
J_1IRIND3 | J_1IRIND | CHAR | 1 | 0 | Reference document type 3 | ||
56 | ![]() |
J_1ISTATUS | J_1ISTATUS | CHAR | 1 | 0 | Excise Document Status | ||
57 | ![]() |
J_1IBEDRAT | PRZ34 | DEC | 7 | 4 | BED percentage | ||
58 | ![]() |
J_1IAEDRAT | PRZ34 | DEC | 7 | 4 | Additional Excise Duty % | ||
59 | ![]() |
J_1ISEDRAT | PRZ34 | DEC | 7 | 4 | Special Excise Duty % | ||
60 | ![]() |
J_1ICESS | PRZ23 | DEC | 5 | 3 | Cess percentage | ||
61 | ![]() |
J_1ICAPIND | J_1ICAPIND | CHAR | 1 | 0 | Material Type | ||
62 | ![]() |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
63 | ![]() |
J_1IREJCODE | CHAR3 | CHAR | 3 | 0 | Rejection Code | ||
64 | ![]() |
J_1IUSNAM | CHAR12 | CHAR | 12 | 0 | Created By | ||
65 | ![]() |
J_1ICPUDT | DATUM | DATS | 8 | 0 | Excise Document Entry Date | ||
66 | ![]() |
CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
67 | ![]() |
J_1IUSNAMC | CHAR12 | CHAR | 12 | 0 | Changed by the user | ||
68 | ![]() |
J_1IAEDAT | J_1IAEDAT | DATS | 8 | 0 | Changed on date | ||
69 | ![]() |
J_1IADDATA | CHAR60 | CHAR | 60 | 0 | Additional Data | ||
70 | ![]() |
J_1IADDATA | CHAR60 | CHAR | 60 | 0 | Additional Data | ||
71 | ![]() |
J_1IADDATA | CHAR60 | CHAR | 60 | 0 | Additional Data | ||
72 | ![]() |
J_1IADDATA | CHAR60 | CHAR | 60 | 0 | Additional Data | ||
73 | ![]() |
J_1IADDVAL | WERT9 | CURR | 17 | 2 | Additional Value | ||
74 | ![]() |
J_1IADDVAL | WERT9 | CURR | 17 | 2 | Additional Value | ||
75 | ![]() |
J_1INUM_OF_PKG | J_1ICHAR10LOW | CHAR | 10 | 0 | Number of Packages | ||
76 | ![]() |
J_1IDESC_PKG | CHAR30LOW | CHAR | 30 | 0 | Package Description | ||
77 | ![]() |
NTGEW_15 | MENG15 | QUAN | 15 | 3 | Net weight | ||
78 | ![]() |
BRGEW_15 | MENG15 | QUAN | 15 | 3 | Gross weight | ||
79 | ![]() |
GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
80 | ![]() |
J_1IMRK_PKG | CHAR30LOW | CHAR | 30 | 0 | Marks on Package | ||
81 | ![]() |
J_1INOS_ON_PKG | CHAR30LOW | CHAR | 30 | 0 | Numbers on Package | ||
82 | ![]() |
J_1ILICYR | GJAHR | NUMC | 4 | 0 | License Year | ||
83 | ![]() |
J_1ILICNO | J_1ILICNO | NUMC | 10 | 0 | Internal License Number | ||
84 | ![]() |
J_1IZEILE | J_1IZEILE | NUMC | 4 | 0 | Item Number | ||
85 | ![]() |
J_1IEXNCCD | WERT7 | CURR | 13 | 2 | NCCD Value | ||
86 | ![]() |
J_1INCCDINV | WERT7 | CURR | 13 | 2 | NCCD Inventory Component | ||
87 | ![]() |
J_1INCCDRAT | PRZ34 | DEC | 7 | 4 | NCCD Rate in % | ||
88 | ![]() |
J_1IADDNCCD | WERT7 | CURR | 13 | 2 | Additional NCCD | ||
89 | ![]() |
J_1IEXECS | WERT7 | CURR | 13 | 2 | ECS Value | ||
90 | ![]() |
J_1IECSINV | WERT7 | CURR | 13 | 2 | ECS Inventory component | ||
91 | ![]() |
J_1IECSRAT | PRZ34 | DEC | 7 | 4 | ECS rate in % | ||
92 | ![]() |
J_1IEXADDTAX1 | WERT7 | CURR | 13 | 2 | Additional Tax1 value | ||
93 | ![]() |
J_1IEXADDINV1 | WERT7 | CURR | 13 | 2 | Inventorized AT1 | ||
94 | ![]() |
J_1IEXADDRAT1 | PRZ34 | DEC | 7 | 4 | AT1 rate in % | ||
95 | ![]() |
J_1IADDAT1 | WERT7 | CURR | 13 | 2 | Additional AT1 | ||
96 | ![]() |
J_1IEXADDTAX2 | WERT7 | CURR | 13 | 2 | Additional Tax2 value | ||
97 | ![]() |
J_1IEXADDINV2 | WERT7 | CURR | 13 | 2 | Inventorized AT2 | ||
98 | ![]() |
J_1IEXADDRAT2 | PRZ34 | DEC | 7 | 4 | AT2 rate in % | ||
99 | ![]() |
J_1IADDAT2 | WERT7 | CURR | 13 | 2 | Additional AT2 | ||
100 | ![]() |
J_1IEXADDTAX3 | WERT7 | CURR | 13 | 2 | Additional Tax3 value | ||
101 | ![]() |
J_1IEXADDINV3 | WERT7 | CURR | 13 | 2 | Inventorized AT3 | ||
102 | ![]() |
J_1IEXADDRAT3 | PRZ34 | DEC | 7 | 4 | AT3 rate in % | ||
103 | ![]() |
J_1IADDAT3 | WERT7 | CURR | 13 | 2 | Additional AT3 | ||
104 | ![]() |
J_1ISERTAXNO | NUMC10 | NUMC | 10 | 0 | Service Tax Serial Number | ||
105 | ![]() |
J_1IADDBED | WERT7 | CURR | 13 | 2 | Additional BED |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 606 |