1. SAP Tutorial
  2. FI Module

J_1IEXCACC SAP table for – Excise Account Assignment table

Here we would like to draw your attention to J_1IEXCACC 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_1IEXCACC is a SAP standard transp table used for storing Excise Account Assignment table related data in SAP. It comes under the package J1I2.

SAP J_1IEXCACC table

Table J_1IEXCACC technical data

TableJ_1IEXCACC
Data storingExcise Account Assignment table
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ1I2
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_APPL
Table CategoryTRANSP

SAP J_1IEXCACC 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_1IEXCACC table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • J_1IEXGRP : Excise Group
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • J_1ITRNTYP : Excise Transaction Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • J_1IBUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • J_1ISTRTYP : Sub Transaction Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • J_1IKTOPL : Chart of Accounts
    Its data type is CHAR (Character String) with field length 4
  • J_1IRG23AB : G/L account RG23A BED account
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23AA : G/L account RG23A AED account
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23AS : G/L account for RG23A SED
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23CB : G/L account for RG23C BED
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23CA : G/L account for RG23C AED
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23CS : G/L account for RG23C SED
    Its data type is CHAR (Character String) with field length 10
  • J_1IOFFSET : G/L Account for CENVAT Offset
    Its data type is CHAR (Character String) with field length 10
  • J_1ICLEAR : G/L account for Modvat Clearing
    Its data type is CHAR (Character String) with field length 10
  • J_1IPLABED : G/L account for PLA BED (Personal Ledger Account)
    Its data type is CHAR (Character String) with field length 10
  • J_1IPLAAED : G/L account for PLA AED (Personal Ledger Account)
    Its data type is CHAR (Character String) with field length 10
  • J_1IPLASED : G/L account for PLA SED (Personal Ledger Account)
    Its data type is CHAR (Character String) with field length 10
  • J_1IPLACES : G/L account for PLA CESS (Personal Ledger Account)
    Its data type is CHAR (Character String) with field length 10
  • J_1IONHOLD : G/L Account for CENVAT On Hold
    Its data type is CHAR (Character String) with field length 10
  • J_1IMSUSP : G/L Account for CENVAT Suspense
    Its data type is CHAR (Character String) with field length 10
  • J_1IPONHLD : G/L account for PLA On Hold
    Its data type is CHAR (Character String) with field length 10
  • J_1IREVERS : G/L Account for CENVAT Reversal
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23AN : G/L account for RG23A NCCD
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23CN : G/L account for RG23C NCCD
    Its data type is CHAR (Character String) with field length 10
  • J_1IPLANCCD : G/L account for PLA NCCD
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23AE : G/L account for RG23A ECS
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23CE : G/L account for RG23C ECS
    Its data type is CHAR (Character String) with field length 10
  • J_1IPLAECS : G/L account for PLA ECS
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23AAT1 : G/L account RG23A AT1 account
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23CAT1 : G/L account RG23C AT1 account
    Its data type is CHAR (Character String) with field length 10
  • J_1IPLAAT1 : G/L account for PLA AT1 (Personal Ledger Account)
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23AAT2 : G/L account RG23A AT2 account
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23CAT2 : G/L account for RG23C AT2
    Its data type is CHAR (Character String) with field length 10
  • J_1IPLAAT2 : G/L account for PLA AT2 (Personal Ledger Account)
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23AAT3 : G/L account RG23A AT3 account
    Its data type is CHAR (Character String) with field length 10
  • J_1IRG23CAT3 : G/L account for RG23C AT3
    Its data type is CHAR (Character String) with field length 10
  • J_1IPLAAT3 : G/L account for PLA AT3 (Personal Ledger Account)
    Its data type is CHAR (Character String) with field length 10

    • J_1IEXCACC related tables

    • J_1ISERUTZ : Tracking accounting docs already utilized for service tax
    • J_1IFRDTPO : tranasction Table for Forms Tracking for Purchase
    • J_1ISERCATSD4 : Service Category determination based on Material Group (L4)
    • J_1IRG1 : Excise RG1 details
    • J_1ICALOC : Allocation of materials to assets
    • J_1ISERCATMMFI2 : Table to determine the Service Category on MM-FI – Level2
    • J_1ICUS_BILL_TYP : Assign Customer Category to Bill Type
    • J_1ITRAN : Transaction code
    • J_1I_WTH_SER_MM : Table to determine withholding line for GTA and Imports
    • J_1IMINBAL : Minimum account balances
    • J_1IGAR7 : Recordings of GAR7
    • J_1ISERCATMM3 : Cust table to determine the Service Category on MM – Level3
    • J_1IEXCDTL : Excise invoice line item details
    • J_1IEXCDEP : Excise information of vendor at detail level for depot
    • J_1IVATREGIO : States Under VAT regime
    • J_1IEXCACC : Excise Account Assignment table
    • J_1IFRDTSO : Transaction table for Forms Tracking for Sales.
    • J_1IITMDTL : Item Details – for Capital goods and subcontracting
    • J_1ISERCATSDFI4 : Customization table to determine the Service Category Level4
    • J_1ISERCATMMFI1 : Table to determine the Service Category on MM-FI – Level1

    J_1IEXCACC related transaction codes under SAP package J1I2

    • S_AL0_96000112 : IMG activity: J_1IREJMAS
    • J1ID : Rate maint & amend open po’s/so’s
    • S_AL0_96000113 : IMG activity: J_1IMVMT
    • J1I7 : Query Excise invoices
    • J1IU : Forms capture
    • J1ISAL : Sales Register – India
    • J1I6 : Modvat forecast
    • J1I5 : Register creation for RG23 and RG1
    • J1IJ : Excise invoice selec. at depot sale
    • S_EBS_44000483 : Program J_1IER1
    • J1IF : Subcontracting
    • S_AL0_96000116 : IMG activity: J_1IEXCREF
    • S_AL0_96000121 : IMG activity: J_1IMESG
    • S_AL0_96000119 : IMG activity: J_1IJ1I9
    • S_AL0_96000105 : IMG activity: J_1IEXCDEF
    • S_AL0_96000108 : IMG activity: J_1IMINBAL
    • J1IM : Maintain Excise Number Range
    • J1IV : Excise post & print for others mvmts
    • J1IB : Excise Verification And Posting
    • J1IL : India Localization

    Related References

    Related Tutorials

    J_2ILAYCTR SAP table for – Table for all the layouts of excise reporting

    J_2ILAYCTR table in SAP FI (Localization in FI) module. This table is used for storing data of Table for all...

    J_2IEXTRCT SAP table for – Data Extract table for Excise Registers

    J_2IEXTRCT table in SAP FI (Localization in FI) module. This table is used for storing data of Data Extract table...

    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...

    J_1ISERACC SAP table for – Service tax account assignment table

    J_1ISERACC table in SAP FI (Localization in FI) module. This table is used for storing data of Service tax account...

    J_1IPART1 SAP table for – Excise part I detials

    J_1IPART1 table in SAP FI (Localization in FI) module. This table is used for storing data of Excise part I...

    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_1IEXESTA SAP table for – Excise indicator determination for co / cust / form code

    J_1IEXESTA table in SAP FI (Localization in FI) module. This table is used for storing data of Excise indicator determination...

    «
    »