dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table J_1IEXCDTL

Excise invoice line item details

Unsere Literaturempfehlung

Kundeneigene Erweiterungen mit ABAP: User-Exits, klassische und neue BAdIs, Switch und Enhancement Framework

Alle Technologien in einem Band! Ob Sie zukunftssichere Erweiterungen programmieren oder mit den Modifikationen in Ihren SAP-Systemen aufräumen möchten – hier erhalten Sie das erforderliche Wissen. Jede Methode wird ausführlich und mit Codebeispielen erläutert: User-Exits, klassische und neue BAdIs, Business Transaction Events, implizite und explizite Erweiterungspunkte u. v. m.

Bei amazon.de ansehen →

The table J_1IEXCDTL (Excise invoice line item details) is a standard table in SAP ERP. It belongs to the package J1I2.

Technical Information

Table J_1IEXCDTL
Short Text Excise invoice line item details
Package J1I2
Table Type Transparent Table

Fields for Table J_1IEXCDTL

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