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
⤷ FI-LOC (Application Component) Localization
⤷ J1I2 (Package) India, Phase II
Basic Data
Table Category | INTTAB | Structure |
Structure | J_1IEXDTL | Table Relationship Diagram |
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 | MANDT | CLNT | 3 | 0 | Client | * | |
2 | TRNTYP | J_1ITRNTYP | J_1ITRNTYP | CHAR | 4 | 0 | Excise Transaction Type | * | |
3 | DOCYR | J_1IDOCUYR | J_1IDOCUYR | NUMC | 4 | 0 | Year | ||
4 | DOCNO | J_1IDOCNO | J_1IDOCNO | NUMC | 10 | 0 | Internal Excise Document Number | * | |
5 | ZEILE | J_1IZEILE | J_1IZEILE | NUMC | 4 | 0 | Item Number | ||
6 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
7 | EXNUM | J_1IEXCNUM | J_1IEXCNUM | CHAR | 10 | 0 | Official Excise Document Number | ||
8 | EXDAT | J_1IEXCDAT | J_1IEXCDAT | DATS | 8 | 0 | Excise Document Date | ||
9 | EXYEAR | J_1IEXYEAR | GJAHR | NUMC | 4 | 0 | Excise Year | ||
10 | EXGRP | J_1IEXCGRP | J_1IEXCGRP | CHAR | 2 | 0 | Excise Group | * | |
11 | LIFNR | J_1ILIFNR | J_1ILIFNR | CHAR | 10 | 0 | Vendor | ||
12 | SHIPFROM | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
13 | RCWRK | UMWRK | WERKS | CHAR | 4 | 0 | Receiving plant/issuing plant | * | |
14 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
15 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
16 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
17 | MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
18 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
19 | CHAPID | J_1ICHID | CHAR12 | CHAR | 12 | 0 | Chapter ID | ||
20 | MENGE | J_1IMENGE | MENG13 | QUAN | 13 | 3 | Quantity mentioned in the excise invoice | ||
21 | MENGA | J_1IMENGA | MENG13 | QUAN | 13 | 3 | Quantity of Goods Received | ||
22 | CREDIT_QTY | J_1IMENGC | MENG13 | QUAN | 13 | 3 | Quantity on Which CENVAT Credit Is Taken | ||
23 | MENGR | J_1IMENGR | MENG13 | QUAN | 13 | 3 | Quantity remaining in the depot | ||
24 | SCPGN | J_1ISCPGN | MENG13 | QUAN | 13 | 3 | Quantity of Scrap generated | ||
25 | MEINS | J_1IMEINS | MEINS | UNIT | 3 | 0 | Unit of Measure | * | |
26 | MENGR_UOM | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
27 | EXCUR | J_1IEXCCUR | WAERS | CUKY | 5 | 0 | Currency | * | |
28 | EXBAS | J_1IEXCBAS | WERT7 | CURR | 13 | 2 | Excise Duty Base Amount | ||
29 | EXBED | J_1IEXCBED | WERT7 | CURR | 13 | 2 | Basic Excise Duty | ||
30 | EXSED | J_1IEXCSED | WERT7 | CURR | 13 | 2 | Special Excise Duty | ||
31 | EXAED | J_1IEXCAED | WERT7 | CURR | 13 | 2 | Additional Excise Duty | ||
32 | CESS | J_1IEXCESS | WERT7 | CURR | 13 | 2 | Cess amount | ||
33 | BEDINV | J_1IBEDINV | WERT7 | CURR | 13 | 2 | Inventorized BED | ||
34 | AEDINV | J_1IAEDINV | WERT7 | CURR | 13 | 2 | Inventorized AED | ||
35 | SEDINV | J_1ISEDINV | WERT7 | CURR | 13 | 2 | Inventorized SED | ||
36 | ADDBED | J_1IADDBED | WERT7 | CURR | 13 | 2 | Additional BED | ||
37 | ADDSED | J_1IADDSED | WERT7 | CURR | 13 | 2 | Additional SED | ||
38 | ADDAED | J_1IADDAED | WERT7 | CURR | 13 | 2 | Additional AED | ||
39 | INDTAX | J_1INDTAX | WERT7 | CURR | 13 | 2 | Non-deductible tax value | ||
40 | PART2YR | J_1IYEAR | NUMC4 | NUMC | 4 | 0 | Year of Register Entry | ||
41 | RG23ASER | J_1I23ASER | NUMC10 | NUMC | 10 | 0 | RG23A serial no. | ||
42 | RG23CSER | J_1I23CSER | NUMC10 | NUMC | 10 | 0 | RG23C serial no. | ||
43 | RGPLASER | J_1IPLASER | NUMC10 | NUMC | 10 | 0 | PLA serial no. | ||
44 | PART1YR | J_1IYEAR | NUMC4 | NUMC | 4 | 0 | Year of Register Entry | ||
45 | PART1SER | J_1ISRLNO1 | NUMC10 | NUMC | 10 | 0 | Register Entry Serial Number | ||
46 | RDOC1 | J_1IRDOC1 | CHAR10 | CHAR | 10 | 0 | Reference Document 1 | ||
47 | RYEAR1 | J_1IRYEAR1 | CHAR4 | CHAR | 4 | 0 | Reference year 1 | ||
48 | RITEM1 | J_1IRITEM1 | NUMC6 | NUMC | 6 | 0 | Reference Item 1 | ||
49 | RIND1 | J_1IRIND1 | J_1IRIND | CHAR | 1 | 0 | Reference Document Type 1 | ||
50 | RDOC2 | J_1IRDOC2 | CHAR10 | CHAR | 10 | 0 | Reference Document 2 | ||
51 | RYEAR2 | J_1IRYEAR2 | CHAR4 | CHAR | 4 | 0 | Reference year 2 | ||
52 | RITEM2 | J_1IRITEM2 | NUMC6 | NUMC | 6 | 0 | Reference Item 2 | ||
53 | RIND2 | J_1IRIND2 | J_1IRIND | CHAR | 1 | 0 | Reference Document Type 2 | ||
54 | RDOC3 | J_1IRDOC3 | CHAR40 | CHAR | 40 | 0 | Reference Document 3 | ||
55 | RIND3 | J_1IRIND3 | J_1IRIND | CHAR | 1 | 0 | Reference document type 3 | ||
56 | STATUS | J_1ISTATUS | J_1ISTATUS | CHAR | 1 | 0 | Excise Document Status | ||
57 | BEDRATE | J_1IBEDRAT | PRZ34 | DEC | 7 | 4 | BED percentage | ||
58 | AEDRATE | J_1IAEDRAT | PRZ34 | DEC | 7 | 4 | Additional Excise Duty % | ||
59 | SEDRATE | J_1ISEDRAT | PRZ34 | DEC | 7 | 4 | Special Excise Duty % | ||
60 | CESSRATE | J_1ICESS | PRZ23 | DEC | 5 | 3 | Cess percentage | ||
61 | CAPIND | J_1ICAPIND | J_1ICAPIND | CHAR | 1 | 0 | Material Type | ||
62 | MRPIND | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
63 | REJ_CODE | J_1IREJCODE | CHAR3 | CHAR | 3 | 0 | Rejection Code | ||
64 | USNAM | J_1IUSNAM | CHAR12 | CHAR | 12 | 0 | Created By | ||
65 | CPUDT | J_1ICPUDT | DATUM | DATS | 8 | 0 | Excise Document Entry Date | ||
66 | CPUTM | CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
67 | AENAM | J_1IUSNAMC | CHAR12 | CHAR | 12 | 0 | Changed by the user | ||
68 | AEDAT | J_1IAEDAT | J_1IAEDAT | DATS | 8 | 0 | Changed on date | ||
69 | ADDLDATA1 | J_1IADDATA | CHAR60 | CHAR | 60 | 0 | Additional Data | ||
70 | ADDLDATA2 | J_1IADDATA | CHAR60 | CHAR | 60 | 0 | Additional Data | ||
71 | ADDLDATA3 | J_1IADDATA | CHAR60 | CHAR | 60 | 0 | Additional Data | ||
72 | ADDLDATA4 | J_1IADDATA | CHAR60 | CHAR | 60 | 0 | Additional Data | ||
73 | ADDLVAL1 | J_1IADDVAL | WERT9 | CURR | 17 | 2 | Additional Value | ||
74 | ADDLVAL2 | J_1IADDVAL | WERT9 | CURR | 17 | 2 | Additional Value | ||
75 | NUM_OF_PKGS | J_1INUM_OF_PKG | J_1ICHAR10LOW | CHAR | 10 | 0 | Number of Packages | ||
76 | DESC_PKG | J_1IDESC_PKG | CHAR30LOW | CHAR | 30 | 0 | Package Description | ||
77 | NTGEW | NTGEW_15 | MENG15 | QUAN | 15 | 3 | Net weight | ||
78 | BRGEW | BRGEW_15 | MENG15 | QUAN | 15 | 3 | Gross weight | ||
79 | GEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
80 | MRK_PKG | J_1IMRK_PKG | CHAR30LOW | CHAR | 30 | 0 | Marks on Package | ||
81 | NOS_ON_PKG | J_1INOS_ON_PKG | CHAR30LOW | CHAR | 30 | 0 | Numbers on Package | ||
82 | LICYR | J_1ILICYR | GJAHR | NUMC | 4 | 0 | License Year | ||
83 | LICNO | J_1ILICNO | J_1ILICNO | NUMC | 10 | 0 | Internal License Number | ||
84 | LICZEILE | J_1IZEILE | J_1IZEILE | NUMC | 4 | 0 | Item Number | ||
85 | NCCD | J_1IEXNCCD | WERT7 | CURR | 13 | 2 | NCCD Value | ||
86 | NCCDINV | J_1INCCDINV | WERT7 | CURR | 13 | 2 | NCCD Inventory Component | ||
87 | NCCDRATE | J_1INCCDRAT | PRZ34 | DEC | 7 | 4 | NCCD Rate in % | ||
88 | ADDNCCD | J_1IADDNCCD | WERT7 | CURR | 13 | 2 | Additional NCCD | ||
89 | ECS | J_1IEXECS | WERT7 | CURR | 13 | 2 | ECS Value | ||
90 | ECSINV | J_1IECSINV | WERT7 | CURR | 13 | 2 | ECS Inventory component | ||
91 | ECSRATE | J_1IECSRAT | PRZ34 | DEC | 7 | 4 | ECS rate in % | ||
92 | EXADDTAX1 | J_1IEXADDTAX1 | WERT7 | CURR | 13 | 2 | Additional Tax1 value | ||
93 | EXADDINV1 | J_1IEXADDINV1 | WERT7 | CURR | 13 | 2 | Inventorized AT1 | ||
94 | EXADDRATE1 | J_1IEXADDRAT1 | PRZ34 | DEC | 7 | 4 | AT1 rate in % | ||
95 | ADDAT1 | J_1IADDAT1 | WERT7 | CURR | 13 | 2 | Additional AT1 | ||
96 | EXADDTAX2 | J_1IEXADDTAX2 | WERT7 | CURR | 13 | 2 | Additional Tax2 value | ||
97 | EXADDINV2 | J_1IEXADDINV2 | WERT7 | CURR | 13 | 2 | Inventorized AT2 | ||
98 | EXADDRATE2 | J_1IEXADDRAT2 | PRZ34 | DEC | 7 | 4 | AT2 rate in % | ||
99 | ADDAT2 | J_1IADDAT2 | WERT7 | CURR | 13 | 2 | Additional AT2 | ||
100 | EXADDTAX3 | J_1IEXADDTAX3 | WERT7 | CURR | 13 | 2 | Additional Tax3 value | ||
101 | EXADDINV3 | J_1IEXADDINV3 | WERT7 | CURR | 13 | 2 | Inventorized AT3 | ||
102 | EXADDRATE3 | J_1IEXADDRAT3 | PRZ34 | DEC | 7 | 4 | AT3 rate in % | ||
103 | ADDAT3 | J_1IADDAT3 | WERT7 | CURR | 13 | 2 | Additional AT3 | ||
104 | SERTAXSERNO | J_1ISERTAXNO | NUMC10 | NUMC | 10 | 0 | Service Tax Serial Number | ||
105 | ADDECS | J_1IADDBED | WERT7 | CURR | 13 | 2 | Additional BED |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 606 |