J_1IEXCDTL - Excise invoice line item details
Excise invoice line item details information is stored in SAP table J_1IEXCDTL.
It is part of development package J1I2 in software component FI-LOC-LO-IN. This development package consists of objects that can be grouped under "India, Phase II".
It is part of development package J1I2 in software component FI-LOC-LO-IN. This development package consists of objects that can be grouped under "India, Phase II".
Fields for table J_1IEXCDTL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
TRNTYP | Excise Transaction Type | X | J_1ITRNTYP | CHAR | 8 | J_1ITRAN |
DOCYR | Year | X | J_1IDOCUYR | NUMC | 8 | |
DOCNO | Internal Excise Document Number | X | J_1IDOCNO | NUMC | 20 | J_1IEXCHDR |
WERKS | Plant | WERKS_D | CHAR | 8 | T001W | |
EXNUM | Official Excise Document Number | J_1IEXCNUM | CHAR | 20 | ||
EXDAT | Excise Document Date | J_1IEXCDAT | DATS | 16 | ||
EXYEAR | Excise Year | J_1IEXYEAR | NUMC | 8 | ||
EXGRP | Excise Group | J_1IEXCGRP | CHAR | 4 | ||
LIFNR | Vendor | J_1ILIFNR | CHAR | 20 | ||
SHIPFROM | Account Number of Supplier | LIFNR | CHAR | 20 | ||
RCWRK | Receiving plant/issuing plant | UMWRK | CHAR | 8 | T001W | |
GSBER | Business Area | GSBER | CHAR | 8 | TGSB | |
LGORT | Storage location | LGORT_D | CHAR | 8 | T001L | |
MATNR | Material Number | MATNR | CHAR | 80 | MARA | |
MAKTX | Material Description | MAKTX | CHAR | 80 | ||
CHARG | Batch Number | CHARG_D | CHAR | 20 | ||
CHAPID | Chapter ID | J_1ICHID | CHAR | 24 | ||
MENGE | Quantity mentioned in the excise invoice | J_1IMENGE | QUAN | 7 | ||
MENGA | Quantity of Goods Received | J_1IMENGA | QUAN | 7 | ||
CREDIT_QTY | Quantity on Which CENVAT Credit Is Taken | J_1IMENGC | QUAN | 7 | ||
MENGR | Quantity remaining in the depot | J_1IMENGR | QUAN | 7 | ||
SCPGN | Quantity of Scrap generated | J_1ISCPGN | QUAN | 7 | ||
MEINS | Unit of Measure | J_1IMEINS | UNIT | 6 | T006 | |
MENGR_UOM | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
EXCUR | Currency | J_1IEXCCUR | CUKY | 10 | TCURC | |
EXBAS | Excise Duty Base Amount | J_1IEXCBAS | CURR | 7 | ||
EXBED | Basic Excise Duty | J_1IEXCBED | CURR | 7 | ||
EXSED | Special Excise Duty | J_1IEXCSED | CURR | 7 | ||
EXAED | Additional Excise Duty | J_1IEXCAED | CURR | 7 | ||
CESS | Cess amount | J_1IEXCESS | CURR | 7 | ||
BEDINV | Inventorized BED | J_1IBEDINV | CURR | 7 | ||
AEDINV | Inventorized AED | J_1IAEDINV | CURR | 7 | ||
SEDINV | Inventorized SED | J_1ISEDINV | CURR | 7 | ||
ADDBED | Additional BED | J_1IADDBED | CURR | 7 | ||
ADDSED | Additional SED | J_1IADDSED | CURR | 7 | ||
ADDAED | Additional AED | J_1IADDAED | CURR | 7 | ||
INDTAX | Non-deductible tax value | J_1INDTAX | CURR | 7 | ||
PART2YR | Year of Register Entry | J_1IYEAR | NUMC | 8 | ||
RG23ASER | RG23A serial no. | J_1I23ASER | NUMC | 20 | ||
RG23CSER | RG23C serial no. | J_1I23CSER | NUMC | 20 | ||
RGPLASER | PLA serial no. | J_1IPLASER | NUMC | 20 | ||
PART1YR | Year of Register Entry | J_1IYEAR | NUMC | 8 | ||
PART1SER | Register Entry Serial Number | J_1ISRLNO1 | NUMC | 20 | ||
RDOC1 | Reference Document 1 | J_1IRDOC1 | CHAR | 20 | ||
RYEAR1 | Reference year 1 | J_1IRYEAR1 | CHAR | 8 | ||
RITEM1 | Reference Item 1 | J_1IRITEM1 | NUMC | 12 | ||
RIND1 | Reference Document Type 1 | J_1IRIND1 | CHAR | 2 | ||
RDOC2 | Reference Document 2 | J_1IRDOC2 | CHAR | 20 | ||
RYEAR2 | Reference year 2 | J_1IRYEAR2 | CHAR | 8 | ||
RITEM2 | Reference Item 2 | J_1IRITEM2 | NUMC | 12 | ||
RIND2 | Reference Document Type 2 | J_1IRIND2 | CHAR | 2 | ||
RDOC3 | Reference Document 3 | J_1IRDOC3 | CHAR | 80 | ||
RIND3 | Reference document type 3 | J_1IRIND3 | CHAR | 2 | ||
STATUS | Excise Document Status | J_1ISTATUS | CHAR | 2 | ||
BEDRATE | BED percentage | J_1IBEDRAT | DEC | 4 | ||
AEDRATE | Additional Excise Duty % | J_1IAEDRAT | DEC | 4 | ||
SEDRATE | Special Excise Duty % | J_1ISEDRAT | DEC | 4 | ||
CESSRATE | Cess Rate | J_1ICESS | DEC | 4 | ||
CAPIND | Material Type | J_1ICAPIND | CHAR | 2 | ||
MRPIND | Single-Character Flag | CHAR1 | CHAR | 2 | ||
REJ_CODE | Rejection Code | J_1IREJCODE | CHAR | 6 | J_1IREJMAS | |
USNAM | Created By | J_1IUSNAM | CHAR | 24 | ||
CPUDT | Excise Document Entry Date | J_1ICPUDT | DATS | 16 | ||
CPUTM | Time of Entry | CPUTM | TIMS | 12 | ||
AENAM | Changed by the user | J_1IUSNAMC | CHAR | 24 | ||
AEDAT | Changed on date | J_1IAEDAT | DATS | 16 | ||
ADDLDATA1 | Additional Data | J_1IADDATA | CHAR | 120 | ||
ADDLDATA2 | Additional Data | J_1IADDATA | CHAR | 120 | ||
ADDLDATA3 | Additional Data | J_1IADDATA | CHAR | 120 | ||
ADDLDATA4 | Additional Data | J_1IADDATA | CHAR | 120 | ||
ADDLVAL1 | Additional Value | J_1IADDVAL | CURR | 9 | ||
ADDLVAL2 | Additional Value | J_1IADDVAL | CURR | 9 | ||
NUM_OF_PKGS | Number of Packages | J_1INUM_OF_PKG | CHAR | 20 | ||
DESC_PKG | Package Description | J_1IDESC_PKG | CHAR | 60 | ||
NTGEW | Net weight | NTGEW_15 | QUAN | 8 | ||
BRGEW | Gross weight | BRGEW_15 | QUAN | 8 | ||
GEWEI | Weight Unit | GEWEI | UNIT | 6 | ||
MRK_PKG | Marks on Package | J_1IMRK_PKG | CHAR | 60 | ||
NOS_ON_PKG | Numbers on Package | J_1INOS_ON_PKG | CHAR | 60 | ||
LICYR | License Year | J_1ILICYR | NUMC | 8 | ||
LICNO | Internal License Number | J_1ILICNO | NUMC | 20 | ||
LICZEILE | Item Number | J_1IZEILE | NUMC | 8 | ||
NCCD | NCCD Value | J_1IEXNCCD | CURR | 7 | ||
NCCDINV | NCCD Inventory Component | J_1INCCDINV | CURR | 7 | ||
NCCDRATE | NCCD Rate in % | J_1INCCDRAT | DEC | 4 | ||
ADDNCCD | Additional NCCD | J_1IADDNCCD | CURR | 7 | ||
ECS | ECS Value | J_1IEXECS | CURR | 7 | ||
ECSINV | ECS Inventory component | J_1IECSINV | CURR | 7 | ||
ECSRATE | ECS rate in % | J_1IECSRAT | DEC | 4 | ||
EXADDTAX1 | Additional Tax1 value | J_1IEXADDTAX1 | CURR | 7 | ||
EXADDINV1 | Inventorized AT1 | J_1IEXADDINV1 | CURR | 7 | ||
EXADDRATE1 | AT1 rate in % | J_1IEXADDRAT1 | DEC | 4 | ||
ADDAT1 | Additional AT1 | J_1IADDAT1 | CURR | 7 | ||
EXADDTAX2 | Additional Tax2 value | J_1IEXADDTAX2 | CURR | 7 | ||
EXADDINV2 | Inventorized AT2 | J_1IEXADDINV2 | CURR | 7 | ||
EXADDRATE2 | AT2 rate in % | J_1IEXADDRAT2 | DEC | 4 | ||
ADDAT2 | Additional AT2 | J_1IADDAT2 | CURR | 7 | ||
EXADDTAX3 | Additional Tax3 value | J_1IEXADDTAX3 | CURR | 7 | ||
EXADDINV3 | Inventorized AT3 | J_1IEXADDINV3 | CURR | 7 | ||
EXADDRATE3 | AT3 rate in % | J_1IEXADDRAT3 | DEC | 4 | ||
ADDAT3 | Additional AT3 | J_1IADDAT3 | CURR | 7 | ||
SERTAXSERNO | Service Tax Serial Number | J_1ISERTAXNO | NUMC | 20 |