1. SAP Tutorial
  2. FI Module

J_1IEXCHDR SAP table for – Excise invoice header detail

Here we would like to draw your attention to J_1IEXCHDR table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). J_1IEXCHDR is a SAP standard transp table used for storing Excise invoice header detail related data in SAP. It comes under the package J1I2.

SAP J_1IEXCHDR table

Table J_1IEXCHDR technical data

TableJ_1IEXCHDR
Data storingExcise invoice header detail
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ1I2
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_APPL
Table CategoryTRANSP

SAP J_1IEXCHDR Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in J_1IEXCHDR table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • TRNTYP : Excise Transaction Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • DOCYR : Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • DOCNO : Internal Excise Document Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • EXGRP : Excise Group
    Its data type is CHAR (Character String) with field length 2
  • SRGRP : Excise Document Series Group
    Its data type is CHAR (Character String) with field length 3
  • STRTYP : Sub Transaction Type
    Its data type is CHAR (Character String) with field length 2
  • EXNUM : Official Excise Document Number
    Its data type is CHAR (Character String) with field length 10
  • EXDAT : Excise Document Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXYEAR : Excise Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REMTIME : Time of Removal
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • SHIPFROM : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • RCWRK : Receiving plant/issuing plant
    Its data type is CHAR (Character String) with field length 4
  • EXCUR : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EXBED : Basic Excise Duty
    Its data type is CURR (Currency Field) with field length 13
  • EXSED : Special Excise Duty
    Its data type is CURR (Currency Field) with field length 13
  • EXAED : Additional Excise Duty
    Its data type is CURR (Currency Field) with field length 13
  • CESS : Cess amount
    Its data type is CURR (Currency Field) with field length 13
  • REFDOC : Internal reference document
    Its data type is CHAR (Character String) with field length 10
  • RDOC : Reference Document 1
    Its data type is CHAR (Character String) with field length 10
  • RYEAR : Reference year 1
    Its data type is CHAR (Character String) with field length 4
  • RIND : Reference Document Type 1
    Its data type is CHAR (Character String) with field length 1
  • KUNAG : Sold-to party
    Its data type is CHAR (Character String) with field length 10
  • KUNWE : Ship-to party
    Its data type is CHAR (Character String) with field length 10
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • EXCCD : ECC Number
    Its data type is CHAR (Character String) with field length 40
  • EXCRN : Excise Registration Number
    Its data type is CHAR (Character String) with field length 40
  • EXCRG : Excise Range
    Its data type is CHAR (Character String) with field length 60
  • EXCDI : Excise Division
    Its data type is CHAR (Character String) with field length 60
  • EXCCO : Excise Commissionerate
    Its data type is CHAR (Character String) with field length 60
  • CSTNO : Central Sales Tax Number
    Its data type is CHAR (Character String) with field length 40
  • LSTNO : Local Sales Tax Number
    Its data type is CHAR (Character String) with field length 40
  • PANNO : Permanent Account Number
    Its data type is CHAR (Character String) with field length 40
  • PREPRN : Preprinted Serial Number
    Its data type is CHAR (Character String) with field length 10
  • RTDAT : Return Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CVDIND : CVD indication
    Its data type is CHAR (Character String) with field length 1
  • EXPIND : Export Type
    Its data type is CHAR (Character String) with field length 1
  • STATUS : Excise Document Status
    Its data type is CHAR (Character String) with field length 1
  • CENSTAT : CENVAT Utilization status
    Its data type is CHAR (Character String) with field length 1
  • REJ_CODE : Rejection Code
    Its data type is CHAR (Character String) with field length 3
  • MRPIND : Maximum Retail Price
    Its data type is CHAR (Character String) with field length 1
  • USNAM : Created By
    Its data type is CHAR (Character String) with field length 12
  • CPUDT : Excise Document Entry Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADDLDATA1 : Additional Data
    Its data type is CHAR (Character String) with field length 60
  • ADDLDATA2 : Additional Data
    Its data type is CHAR (Character String) with field length 60
  • ADDLDATA3 : Additional Data
    Its data type is CHAR (Character String) with field length 60
  • ADDLDATA4 : Additional Data
    Its data type is CHAR (Character String) with field length 60
  • ADDLVAL : Additional Value
    Its data type is CURR (Currency Field) with field length 17
  • RULES : Rule/Section
    Its data type is CHAR (Character String) with field length 10
  • TCODE : Transaction code
    Its data type is CHAR (Character String) with field length 20
  • REJ_ACC_DOCNO : Accounting Document
    Its data type is CHAR (Character String) with field length 10
  • REJ_ACC_DOCTYP : Object type of calling application (FI)
    Its data type is CHAR (Character String) with field length 5
  • REJ_ACC_YEAR : Financial posting year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PRECUSDAT : Arrived at Customs
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ACKCUSDAT : Countersigned
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECPTDAT : Arrived Back
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXCSUBDAT : Sent to Excise Department
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • POEXPDAT : Export Confirmed
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AMENDIND
    Its data type is CHAR (Character String) with field length 1
  • BONDNO : Internal Bond Number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • BONDYR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BOAMTBAL : Bond Balance
    Its data type is CURR (Currency Field) with field length 13
  • AMENDED_BALANCE : BED After Amendment
    Its data type is CURR (Currency Field) with field length 13
  • AMENDED_ON : Exc Bonding: Date of Amendment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXC_ADDRESS_NO : Address
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CUS_ADDRESS_NO : Address
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • INTEREST_VALUE : Interest Amount
    Its data type is CURR (Currency Field) with field length 13
  • NCCD : NCCD Value
    Its data type is CURR (Currency Field) with field length 13
  • ECS : ECS Value
    Its data type is CURR (Currency Field) with field length 13
  • EXADDTAX1 : Additional Tax1 value
    Its data type is CURR (Currency Field) with field length 13
  • EXADDTAX2 : Additional Tax2 value
    Its data type is CURR (Currency Field) with field length 13
  • EXADDTAX3 : Additional Tax3 value
    Its data type is CURR (Currency Field) with field length 13
  • BELNR : Accounting Document
    Its data type is CHAR (Character String) with field length 10
  • GJAHR : Financial posting year
    Its data type is NUMC (Character String with Digits Only) with field length 4

    • J_1IEXCHDR related tables

    • J_1IASSVAL : Assessable value table for excise calculation
    • J_1IVATINVOICE : Billing type determination for VAT
    • J_1ISERCATMMFI3 : Table to determine the Service Category on MM-FI – Level3
    • J_1IEXCDEF : Tax default informations
    • J_1IPART2 : Excise Part II details
    • J_1IREJAPPL_T : Rejection code description for Applications
    • J_1ISERCATGTA : Service Category based on GTA Code (LEVEL 5)
    • J_1ISER_BSEG : Transaction table having the Invoices with Service Category
    • J_1ISTAPPL : Tax applicability
    • J_1ISRGRPS : Excise Document Series
    • J_1IKONV : Excise recalculated conditions
    • J_1ISERCATMM5 : Cust table to determine the Service Category on MM – Level5
    • J_1IFRDTSO : Transaction table for Forms Tracking for Sales.
    • J_1IREJAPPL : Rejection code for Applications
    • J_1ISERCAT : Service tax category description table
    • J_1IEXCACC : Excise Account Assignment table
    • J_1IRG23D : RG23D register for the depot
    • J_1ISERCATSD2 : Ser category based on Customer and Material (L2)
    • J_1IGAR7 : Recordings of GAR7
    • J_1IVATDATE : Maintain Valid from date of VAT legislation in India

    J_1IEXCHDR related transaction codes under SAP package J1I2

    • J1IGAR7 : Capture – GAR7 Information
    • J1IC194I : Annual Return under section 194i
    • J1ID : Rate maint & amend open po’s/so’s
    • J1ICANCINV : Cancel Invoice
    • J1IK : Selection of Excise Invoice – Common
    • S_AL0_96000116 : IMG activity: J_1IEXCREF
    • J1I3 : Modvat utilzation in batch
    • J1IS : Excise invoice for other movements
    • S_AL0_96000099 : IMG activity: J_1IREGSET
    • J1I6 : Modvat forecast
    • S_EBS_44000097 : Report J_1I_ST3
    • J1I7 : Query Excise invoices
    • S_AL0_96000103 : IMG activity: J_1IWRKCUS
    • J1IL : India Localization
    • J1ISAL : Sales Register – India
    • S_AL0_96000120 : IMG activity: J_1IVTTXID
    • J1I2 : Sales Tax Register
    • J1IPUR : Purchase Register – India
    • S_AL0_96000104 : IMG activity: J_1ISRGRPS
    • J1IHBK : Copy House Bank ID from Invoice

    Related References

    Related Tutorials

    J_1ILICDTL SAP table for – Excise Bonding: License detail

    J_1ILICDTL table in SAP FI (Localization in FI) module. This table is used for storing data of Excise Bonding: License...

    J_1IEXCDTL SAP table for – Excise invoice line item details

    J_1IEXCDTL table in SAP FI (Localization in FI) module. This table is used for storing data of Excise invoice line...

    J_1IGRXREF SAP table for – Goods Receipt to Excise Invoice Coss Reference

    J_1IGRXREF table in SAP FI (Localization in FI) module. This table is used for storing data of Goods Receipt to...

    J_1ILICHDR SAP table for – Excise Bonding: License Header

    J_1ILICHDR table in SAP FI (Localization in FI) module. This table is used for storing data of Excise Bonding: License...

    ISJPINVSUMHD SAP table for – Invoice Summary Header

    ISJPINVSUMHD table in SAP FI (Localization in FI) module. This table is used for storing data of Invoice Summary Header....

    J_1IBOND SAP table for – Excise Bonding: Bonds/UT-/Running Bond master

    J_1IBOND table in SAP FI (Localization in FI) module. This table is used for storing data of Excise Bonding: Bonds/UT-/Running...

    J_1IPART2 SAP table for – Excise Part II details

    J_1IPART2 table in SAP FI (Localization in FI) module. This table is used for storing data of Excise Part II...

    «
    »